I cant’ save this url in delicious 
http://www.mysqlperformanceblog.com/2009/10/16/finding-your-mysql-high-availability-solution-%E2%80%93-the-questions/ Looks like and strange character on: —
Comment: Finding your MySQL High-Availability solution – The questions
December 19, 2011 By 36 Comments
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…any actual data, and their index usage was fairly high, so we decided to look for unused indexes that…(0.03 sec) Now I need a way to find the set of indexes in all_indexes, but … then you can rebuild the tablespace for your table by simply doing: mysql> alter table mytable ENGINE=Innodb; However, this…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…determine normal versus abnormal, the higher quality your results will be. Find and change the following lines: # This… Sometimes it’s glaringly obvious even at a high level, but not always. Most of the … many things that can cause a stall in MySQL, and they usually begin microscopically and get worse…
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
… talk MySQL High Availability Sprint: Launch the Pacemaker! will talk about MySQL High Availability using DRBD and Pacemaker (Heartbeat) which have been a high availability… probably the most accomplished and experienced person you can find to talk about High Availability with DRBD, and with his experience both… are not only helpful for your MySQL Server but can be used for other applications such as designing highly available storage systems. Johan…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… can work very well when you don’t need high concurrency from your MySQL database. When you do, the limitations on the core…, Percona Server 5.5, and MySQL 5.5. These observations lead to the following guidelines. Whether your database is read-heavy or… activity you’re generating, whichever comes first. And you could find that you generate more I/O than you can push…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 12 Comments
… your problem. But with RHEL/CentOS 6 (and derivatives) and Fedora 9 and later, you’ll likely find… to your MySQL instance are contingent upon how/when it was launched, and if you don’t restart your MySQL … and logging back in). If we have a high-traffic MySQL server with a very large InnoDB buffer …
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
…,2 MySQL allows us to set FOREIGN_KEY_CHECKS=0 to disable enforcement of RI when the overhead is too high. But if you later restore enforcement, MySQL does not immediately scan all your data to verify that… of foreign key relationships in any complex database. We can find all foreign keys by querying the INFORMATION_SCHEMA. The KEY…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the…the problem 070223 13:26:01InnoDB: Warning: cannot find a free slot for an undo log. …engine interface Sun/MySQL spends some time to make things consistent. There should be general high level …
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… it is the case by running netstat -s and finding something like: 38409 times the listen queue of a … 1000 of connects/sec in average. This is a high number but you can see ones even higher. In… creating 1000 of connections a second to MySQL Server you might be pushing your luck and at very least you’…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… server, though panic might be good option in high availability setup which would cause server to crash… buy a little bit of time before they find more permanent solution. Maximum mount count: -1 and…your data partition and just check it manually as needed, same as you would every so often check MySQL…
