…mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers…quorum… [ OK ] Starting fenced… [ OK ] Starting dlm_controld… [ OK ] Tuning DLM kernel config… [ OK ] Starting gfs_controld… [ OK ] …
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… sessions including presentations on Oracle MySQL, Percona Server, and MariaDB during the Percona Live MySQL Conference. Percona Live MySQL Conference Keynotes Tuesday Peter Zaitsev… Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer, Oracle Topic: “MySQL 5.6: Redefining Replication” Breakout Sessions on Percona Server and…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… focus the most in their MySQL 5.6 benchmarks. However, the “trx descriptors” optimization in Percona Server 5.5 is fairly close… introduced in Percona Server 5.5.30-30.2 and the special-case “read-only transactions” optimization in MySQL 5.6 are… the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned.
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for…_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read… 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
… against both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are…array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true ); $memcacheOpts = array( ‘servers‘ =>array( array( ‘host’ => ’192.168.57.51′, ‘port’ => 11211, …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…law to single-server Innodb, we’d get: [On a single node Innodb server] a given…standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication?…can update much faster. I see this tuning very frequently for “performance” reasons when data…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight… servers are where in wild which are running with default settings. Even though you can tune quite a lot of variables in MySQL Servers… less secure as you can lose transactions even in case MySQL Server crashes. Value 2 only cause data loss with full OS…
Page: Consulting for MySQL
July 31, 2006 By
… replication, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL Upgrades, Backup… flawed there is only limited gain you can achieve by MySQL Server tuning. Working with us on architecture design or refactoring will ensure…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
…MySQL, Drizzle, and Oracle MySQL, MySQL 5.6 is fully supported by our MySQL Consulting, MySQL Support, MySQL Server Development, and MySQL Remote DBA teams: Our MySQL…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… for MySQL Server code and various small static buffers. This is memory which you can consider used when you just start MySQL Server. The rest of memory is available for connections. For exampe with 8GB server you might have everything… which are not tuned as buffers. Watch for these especially now with many storage engines being released for MySQL by various parties…
