….31), looking for optimizations with HAProxy to account for high connection rates, and using pacemaker with PXC. The goal is to…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…dynamic main menu and sub menu using php and mysql php CREATE TABLE `menu` ( `id` int(11) … int(11) default NULL, PRIMARY KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db…
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… in turn, load that data into and pollute the buffer pool. Note that this can be somewhat mitigated using innodb_old… (redo logs, binlogs, etc) as well further polluting the buffer pool. Enter Xtrabackup… As a quick refresher, Xtrabackup works by copying…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The entire main db would be…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took a look…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… ports. Why 4? Two of those NICs should be directly connected from one machine to another and configured with Linux network… privilege; a user with SUPER will always be able to connect, and that may not accurately report what your application servers are seeing. But, if you can connect and run a simple query and receive a response back…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… $ mysqlindexcheck –server=user:pass@localhost test.test # Source on localhost: … connected. $ pt-duplicate-key-checker –tables test.test # ######################################################################## # test.test…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the slave to the correct master with master_auto_position…
