…how to read these, there’s a full explanation in our book, High Performance MySQL…of the analysis we do. A lot of times, customers will tell us up front to limit the work to some number of…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…connections opened to the slaves, which would allow to read old data as application is designed to…to strip comments when checking…of applications. Many applications in MySQL have very large number of…script which can have application-specific tunings to prioritize which queries are more important to…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection…how can we deal with that and avoid the resource to stop ? If we check the list of…number of nodes: 1, my index: 0, protocol version 2 Now when we put the two settings to…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of…to synchronize binary log position with backup you can skip this step. 2) While holding connection open…script…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…number of locked rows – there are normally many rows for each lock structure. For each of connections for MySQL…how many inserts were done in insert buffer, how many recs were merged and how many merges did it took. Ratio of number of merges to number of…
Post: Living with backups
November 6, 2008 By 28 Comments
… a utility called ionice. It allows to affect how I/O scheduler will be dealing with … file that was opened with O_DIRECT flag, the file needs to be aligned to the file …script does is to check MySQL status every second and in case the number of connected threads goes above 50, it sends STOP signal to…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…to check the platform specific part of the reference manual for hints about installing MySQL…of them thus limiting the number of writes to the log. Note: this feature will fail to work well if your application uses some kind of connection…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…to handle both network and IO which is not going to scale especially if you have storage build from large number of…to do this kind of job. The other solution is to use X-send-file or similar custom headers which make PHP script just to check…
