May 24, 2012

Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

you have workload which includes some very long SELECT queries youmysql client, so you might get a feel you can’t connect to the database at all (use mysqlyou‘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?

you commit a transaction, the commit does not complete until all replicas have also committed successfully. In MySQLconnectionhave 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 ?

…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

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

how many physical spindles are under the box, and howmysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysqlconnectshave a lot of stored procedures, which are more difficult to analyze because you have

Post: MySQL extensions for hosting

how each customer utillizes the database. Having manyyou 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

MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how manyconnection needs its own entry) if you have many connections or many

Post: When would you use SAN with MySQL ?

you have MySQL/server restart you may haveactive-passive clusters for availability purposes and they look to do the same with MySQLyou 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

you have small number of connections all connections will be printed in transaction list, if you have large number of connectionsactivity 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

you have slave which is used for backups/reporting etc) is to stop the replication for some time and when see how