…you have workload which includes some very long SELECT queries you…mysql client, so you might get a feel you can’t connect to the database at all (use mysql…you‘re just using Innodb tables and you‘re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
…you commit a transaction, the commit does not complete until all replicas have also committed successfully. In MySQL…connection…have reached any slave. Finally, I would be interested to hear how many people are actually running semi-synchronous replication in production. I have…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…call an Active Cache meaning it takes care of the misses itself, without you have to …you have item invalidated from query cache and there are multiple connection requesting the same item. What MySQL will… Improve Manageability What is in the MySQL Query Cache ? How many hits did we get for this query…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
Many of the prominent companies in the MySQL… about how we’ll work with you, so …You hire Percona to review the architecture. We do not authorize you to mention our name in connection…this is rare. Most vendors have active sales efforts, so … If you have any questions or comments, I invite you to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how many physical spindles are under the box, and how…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…connects…have a lot of stored procedures, which are more difficult to analyze because you have…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…how each customer utillizes the database. Having many…you with some strategic decisions. Sample outputs: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User: hosting2 Total_connections: 84 Concurrent_connections: 0 Connected…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many…connection needs its own entry) if you have many connections or many…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…you have MySQL/server restart you may have…active-passive clusters for availability purposes and they look to do the same with MySQL…you do not run any “Cluster” having SAN you can always “connect” the storage to another node – if server fails or if you…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…you have small number of connections all connections will be printed in transaction list, if you have large number of connections…activity on the row basics and some system information. It shows innodb thread queue status – how many threads are waiting and being active. How many…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…you have slave which is used for backups/reporting etc) is to stop the replication for some time and when see how…
