Tag Archives: Performance Tuning

Day 25 Optimization

Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column locking) for all storage engines except InnoDB, which uses row level locking locking system in MySQL: Implicit Locking: To maintain the … Continue reading

Posted in DeadLock, Lock/Blocking, MySQL, Others, Performance Tuning, What I learned today | Tagged , , , | Leave a comment

Day 20 Innodb Storage engine

InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID properties and to make the Enterprise level of the system requires Transaction management. Before this MySQL was known to be … Continue reading

Posted in MySQL, Others | Tagged , , | Leave a comment

Day 15 Server Logs

There are 6 types of logs available for MySQL environment, Logs are important information for DBA to troubleshoot or understand the system. MySQL track the information in those logs. Following are the list of logs: Error Log (– start/stop/errors) Query … Continue reading

Posted in Error Log, MySQL, Others, Performance Tuning, Transaction Log, Troubleshooting | Tagged , , | Leave a comment

Day 14 MySQL sys Schema

MySQL 5.7.7 and higher includes the sys schema, This has View, Stored Procedures and Functions to gather the performance related information, as it works on Performance Schema the Performance Schema must be enabled for the sys database. Following some of the important tables: sys_config: … Continue reading

Posted in MySQL, Others, Performance Tuning, What I learned today | Tagged , , , | Leave a comment

Day 13 MySQL Performance_Schema

performace_schema is a dynamic database created when you restart the mysql, all the data from performance_schema database will be clear. This database has its own storage engine –“performance_schema” Even you may have this database but it could be possible that … Continue reading

Posted in MySQL, Others, Performance Tuning, What I learned today | Tagged , , , , | Leave a comment

DBCC Cleaning CACHE – Memory

DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know at sql everything is on memory, memory information retrieve quickly compare to Disk. So if things are not in … Continue reading

Posted in Memory, Performance Tuning, Troubleshooting | Tagged , , , , | Leave a comment

Denali — Day 5: Column-store indexes (aka Project Apollo)

Denali – Day 5: Column-store indexes (aka Project Apollo)   There is another great achievement for Denali, especially for Data warehouse, where data is static and very huge – READONLY, and user always require data to be retrieved quickly as … Continue reading

Posted in Denali, Index, Performance Tuning | Tagged , , | Leave a comment

Performance Tunning Part 2

After checking on the net found that there are lots of lots of good stuff (queries) already describe the performance related information, so I would like the share and refer some of the very good site. I have already blog … Continue reading

Posted in DMV, Lock/Blocking, Performance Tuning, Whitepapers | Tagged , , | Leave a comment

performance Tunning continue…

We have discussed performance tunning part1, continue on that… Resource is the base for performance, if you don’t have sufficient space the optimum query/system may also not work efficiently. Latch: Latch is for physical synchronization, like while >> accessing pages … Continue reading

Posted in Performance Tuning | Tagged | Leave a comment

Miscellaneous Info

Some undocumented and important stuff   DMV: dbcc showcontig – index_physical_stats will scan complete index pages even if you use where clause Backup : uses 960k speed can reduce to 64k. Virtual File Space … for 32 bit system. Default big … Continue reading

Posted in DMV, Experts, General, Others, Tool | Tagged , , | Leave a comment