…heartbeat:IPaddr2): Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: …perform the following command on one server only: [root@percona1 ~]# ccs -f /…] Starting fenced… [ OK ] Starting dlm_controld… [ OK ] Tuning DLM kernel config… [ OK ] Starting gfs_controld……
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… are: [mysqld_safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib…_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read… understand from documentation TokuDB comes with good settings out-of-box, but I am ready to tune something if there are suggestions.
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… layer to store expensive result sets or objects. Some typical use cases… memcached instance and a minimally tuned MySQL 5.6 instance running the … => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true ); $memcacheOpts = array( ‘servers‘ =>array( array( ‘host’ => ’192.168.57.51′, ‘port…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… applying Callaghan’s law to single-server Innodb, we’d get: [On a single node Innodb server] a given row can’t…: set innodb_flush_log_at_trx_commit to something besides 1 and suddenly you can update much faster. I see this tuning… periodically? if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements SET count = $last_count where achievement = ‘killed_troll’”; } change your schema…
Page: Presentations
May 3, 2006 By
… MySQL Server Settings Tuning MySQL Users Conference 2007, Santa Clara,CA, April 2007 Presentation covering most important MySQL Settings which should be tuned for optimal… Innodb specific application design recommendations as well as Innodb MySQL Server Settings and Hardware selection aspects. Download Effective Full Text Search for…
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
… also how your scaling is set up. For smaller systems lets say running couple of MySQL servers running another couple can be… adding more servers, because scaling up and purchasing more and more powerful servers will not tall you far, especially as MySQL Server may… help to access if minor face lifting such as MySQL Server settings tuning, changing indexes and queries is enough to deliver performance required…
Post: Quality Assurance: Percona Server Development Now Monitored by Automated Sysbench Performance Regression Checks!
October 23, 2012 By Leave a Comment
… a solution either: even small changes in hardware, OS or server settings will often directly affect the test outcome. There is usually… exactly such automated performance regression monitoring in place: Live Percona Server Performance Regression Checks Using Sysbench While systems are being optimized… in a 3 VM node setup for performance regressions. Stay Tuned!
Post: UC2007 Presentation and Notes
May 2, 2007 By 5 Comments
… lightning talks. I’ve now published PDFs for these: MySQL Server Settings Tuning MySQL Performance Cookbook Innodb Performance Optimization Last one was presented…
Post: Speaking at MySQL Users Conference 2007
January 16, 2007 By 2 Comments
… my talks being accepted to MySQL Users Conference 2007 “MySQL Server Settings Tuning” and “MySQL Performance Cookbook”. This is great as MySQL Conferences…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… 0.001% Which server is badly tuned? Maybe you’re objecting that you don’t know enough about the servers. OK, I’ll… MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically designed to mock and… unscientific-ness, they shouldn’t. The reality is that this server setting is very subjective, and there is no good instrumentation in…
