…mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.25 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW…=user:pass@localhost test.test # Source on localhost: … connected. $ pt-duplicate-key-checker –tables test.test # …
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… privilege; a user with SUPER will always be able to connect, and that may not accurately report what your application servers… the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL server’s…
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… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the slave to the correct master with master_auto_position…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 35301 Connect_Retry…) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 18675 Connect_Retry…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… the show I make some new friends or have a chance to meet, in person, people who I previously only connected with…’re shopping for MySQL technology and services, then you’ll see the largest selection of MySQL Ecosystem vendors at the show. If you’re doing business associated with MySQL, you’ll have the…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… 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 or anything else that’s on your mind! There are numerous solutions for MySQL… 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
…: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… plugin. Bugs fixed: Percona Playback for MySQL now shows error when it’s unable to connect to the MySQL database server. Bug fixed #1070824… (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: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5… innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
