…to monitor in MySQL. Those are only suggestions; any given deployment might want to monitor only some of them, as appropriate, and might need to…to fix these problems is in the application, but the DBA really needs to…how often a server crashes, perhaps even cycling through crashes…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…to ensure both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL…to caught up you can use mk-table-checksum to ensure data is the same. It is possible some update statements worked differently in…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
…in mySQL teach you ? Of course you have to learn a lot about query optimization, art of building summary tables…to deal with which can slow down some queries considerably. You need to be planning for your handling of crashed…fixed them by adding indexes and got back to fix…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…to fix mistakes in the applications which make MySQL Server useless (though few of them cause crashes to…tables in MySQL 5.1 Disk Space For MyISAM tables hosting providers used to use disk quotas for MyISAM tables…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
…tables: $tables = { rows => [1..50], partitions => [ undef ] }; The value in the ‘rows’ section tells the data generator to produce 50 tables…mysql –basedir=/path/to/Percona-Server –suite=randgen_basic innodbDictSizeLimit_test This enabled us to reproduce the crash…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… to Oracle? HT: You are right, bugs that cause data corruption, crashes,…in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to…table, but how long will this take? Is there a facility we can run to show any table / index fragmentation, without having to…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… in the error log after a crash: “It is possible that mysqld could use up to… lot of tables. We’re trying to fix that, but it’s unbounded in a non-Percona… ran the following on my laptop: mysql> set @a := repeat(‘a’, 1024 * 1024 * 100… a 100M lock key. Note how long it took to run these statements! And…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…in case of crash database may become corrupted, just as with MyISAM, and you might need to repair tables. This is of course something which is scheduled to be fixed before stable release but performance effect of it is yet unknown – how…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
…to survive the server crash – using them you can do point in…oltp –oltp-table-size=10000000 –db-driver=mysql –mysql-user=root –mysql-db=…to this box the throughput on the Master drops to about 2800 updates sec…. which is very close to the magic number how…to avoid it or if we need to fix MySQL…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… to write a series of blog posts on MySQL…, no matter how large the read-to-write ratio…to choose a solution that works for all situations. For example, mixtures of transactional and non-transactional tables…crash when you have to fix multiple threads that have forgotten where they should be reading in…
