I wanted to write a few administrative updates in one so I didn’t spam everyone’s feed readers too much. Here we go:
|
1 |
My favorite Percona patch : innodb fast recovery patch. |
|
1 |
|
1 |
Reason: Innodb recovery has always been a big headache for any DBA since it used to take ages to complete a recovery after crash. Now with the patch I am able to do a recovery in less than a tenth of the time it used to take. Great job by Yasufumi in hacking the code(not just this patch :) ) which has been a nightmare for all DBA's.<br> |
|
1 |
My favorite patch is "Micro second slow query patch" as it actively allows me to identify the queries which takes few seconds to execute but their frequencies is just too high i.e. few hundred times a hour. By optimizing these queries I can freeup the server resources to do other useful work.<br> |