….1.2 would hang when performing State Snapshot Transfer. Bug fixed #1182698. … complete quickly and reliably Uninterrupted transaction processing during backups Savings on disk space…, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… rules are processed. There are some informative flowcharts in addition to the textual explanation. Q: What is my recommendation for MySQL 5… can consider it truly production-ready. I suppose I should state an obvious disclaimer here in that the aforementioned statements reflect… mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and pre… a cluster and we often ended up is strange, unexpected states. What was I missing? In order to figure out, I… short while. Here’s the vmstat output during the split process, the cron job started at 10am. Fri Mar 22 10…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…. For example we can use factor of 0.7 and state we can safely run 0.7*16 ~= 12 queries per… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1… and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is pretty idle…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… number of MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL 5.5… the new one. Note that ALTER is a multi-step process, the old table is locked in shared mode and then… spent nearly all its time waiting in the “Opening tables” state. Now this behavior with respect to ALTER making the table…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
… process looks like in an error.log: 130129 23:01:22 mysqld_safe Starting mysqld daemon with databases from /mnt/data/mysql… 23:01:56 [Note] WSREP: State transfer required: Group state: 50176f05-69b5-11e2-0800-930817fe924a:8549242 Local state: 50176f05-69b5-11e2-0800-930817fe924a…, seqnos 8549230-8549242 130129 23:02:01 [Note] /usr/local/mysql/bin/mysqld: ready for connections. So what happens there? Basically…
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
… profiler has become a key tool in helping us analyze MySQL when customers are having trouble. We have our own implementation… most obvious impact on the running server: GDB forklifts the process and gets a stack trace from every thread, then lets… server can be left in an unstable state. Sometimes when GDB detaches, the process‘s state isn’t quite as it was before…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… time critical process I would not use more than 4 parallel processes heavily writing to database. Introduce Throttling Sometimes even single process overloads…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…to this rather boring process – install, configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security …, the latter were in half-configured state. Obviously binutils has nothing to do with MySQL, but it would not install …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…. The script examines wsrep_local_state variable. To set it up, create the clustercheck user. mysql> grant process on *.* to ‘clustercheckuser’@'localhost’ identified by ‘clustercheckpassword!’; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges…
