…Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level…in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in…test # Source on localhost: … connected. $ pt-duplicate-key-checker –…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…show where GTIDs shine and where improvements are expected. This is the second post of a series of articles focused on MySQL… a solution of course, but very poor in my opinion: look for the binlog file… when using GTIDs is usually straightforward: just connect the slave to the correct master with…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… you monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to… seeing. But, if you can connect and run a simple query and receive a response back in a reasonable (what is reasonable… queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL server…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…. So how do you safely disconnect a replication slave? In short For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE…) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 35301 Connect_Retry…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… to the show I make some new friends or have a chance to meet, in person, people who I previously only connected with… New Companies. Many companies and products in the MySQL space have been launched at this show. It is important for me to stay attuned to the new companies, products and other developments in the MySQL ecosystem…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… Percona Live MySQL Conference and Expo next week in Santa Clara, California so look for me there – I’d love to connect and talk more about MySQL buffer pools… looked like this (we did 39 measurements), the next graph shows chunk 4’s workload warmed up with chunk 3. The…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing…fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. …
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… threads in the thread pool dispatcher plugin. Bugs fixed: Percona Playback for MySQL now shows error when it’s unable to connect to the MySQL… (Stewart Smith). Percona Playback for MySQL wouldn’t reconnect or log the error if the connection was broken during the query. Bug fixed #1080654 (Vlad Lesin). Release notes with all the bugfixes for Percona Playback for MySQL…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT …in Percona Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL… innodb_io_capacity = 2000 max_connections=5000 table_open_cache=…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows much better results…_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query…
