…MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL… the general log. Bear in mind these were basic tests (just a few mysqlslap …query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… in-depth. If you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows… explains more in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in the…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… common in OLAP analysis. Each query in each flight (Q1.1 for example) is tested with a cold buffer pool. Then the query is tested again… #4 There is one query in this flight, Q4.3, which is faster using MyISAM than InnoDB. Like the queries in Flight #3 that… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… the MySQL designers know can be improved. But there’s a finite amount of engineer-years spent developing and testing the query optimizer… be some cases where optimizing a query automatically would be more costly than just running the query in a suboptimal form. Q: Doesn… in performance like this, so it pays to test all different solutions, and measure the resulting performance! Q: Bill, back to the query…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… start to degrade. If you’re just setting up a test environment to get familiar with the technology, certainly there’s…-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL… simple query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL HA…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…_Error: Error ‘Duplicate entry ’4′ for key ‘PRIMARY” on query. Default database: ‘test‘. Query: ‘insert into t VALUES(NULL,’salazar’)’ Retrieved_Gtid_Set… an overview of MySQL 5.6 GTID that can help people to start working with this new feature in MySQL 5.6. Here are the slides from that session. I hope you find it useful: MySQL 5.6 GTID in a…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read… fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… and replicating from the active master. In theory, failing over is the simple…-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log… our test database so that our test database was consistent before applying the captured query …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… slave? In short For MySQL 5.0…mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: test…mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql > reset slave; Query OK, 0 rows affected (0,11 sec) mysql…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL…=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema…MyConfig.properties -l command line to run test for 10x dataset: ./bin/linkbench -D …
