… solution for systems based on InnoDB/XtraDB. The recommended setup is 3 nodes and you can add / … cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to … again, it has to copy the whole data set again. But if it was disconnected only for …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary… when it would make a difference though. Q: Would you recommend creating an index in every table you create? Example: CREATE… prepdefined A: MySQL Server will not automatically define any indexes for you. Hopefully your CMS already comes with reasonable set of indexes…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
…) — Shoring up information about new Xtrabackup feature sets. Internals of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb… for MariaDB - (Antony Curtis, LinkedIn Corp) – I generally don’t recommend stored procedures, but I need to learn more about Maria…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By 2 Comments
… to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because I wanted to…, and doing it excellently. This makes the plugins easier to set up and use, and I believe it should help avoid… is the pmp-check-mysql-status plugin, which can perform computations on status variables. By default, I recommend using it only for…
Post: Must read talk from MySQL Conference and Expo
May 9, 2011 By 2 Comments
… going over the slides from talks from MySQL Conference and Expo 2011 to pick set of must see presentations and publish the… to lack of time. Instead I’m only going to recommend 1 talk, from list of tutorials I had a chance… slides alone. Were you excited by some other talk on MySQL Conference and Expo ? Feel free to leave it as a…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… the my.cnf settings again? A: Sure, see this post or webinar recording. Q: Fault tolerance: Can you recommend a three node cluster for production use? A: Yes, that’s the recommended configuration. The number of… or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I installed Percona…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…fact an odd number is recommended in that kind of …mysql> select * from percona; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ | 2 | percona1 | lefred | | 3 | percona2 | kenny | +—-+—————+——–+ 2 rows in set (0.00 sec) percona2 mysql…
Post: Adventures in archiving
February 11, 2013 By 16 Comments
… Use of INSERT DELAYED is not recommended. #48339 Use of statement based replication is not recommended. #48343 Flush buffers before attempting a… desc limit 1; +———+ | id | +———+ | 1143883 | +———+ 1 row in set (2.04 sec) mysql> select id from compressed_row order by id desc…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… provided a very detailed and thoughtful article, and I strongly recommend reading if you want to understand how InnoDB works. In… [1] recommends using the innodb_max_dirty_pages_pct and innodb_io_capacity parameters to get stable throughput in MySQL 5.5… what result we have when we disable doublewrite; that is, set innodb_doublewrite=0. Now, although throughput is not a perfect…
