…Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** …in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in…Warnings: 0 $ mysqlindexcheck –server=user:pass@localhost test.test # Source…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…user=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql…coordinates of the last event executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-… a solution of course, but very poor in my opinion: look for the binlog …
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB …vulnerability would allow remote attacker to detect what user accounts exist on the server. This bug … for Percona Server for MySQL 5.5.31-30.3 are available in our online documentation. Bugs …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…’d suggest doing this as a user that does NOT have the SUPER privilege; a user with SUPER will always be able… queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL server…/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… the first MySQL user conference independently organized by MySQL AB. It was called the “MySQL Users Conference” …show. Marten reports revenues of almost $50 million in 2006, preparing for an IPO, and MySQL…announced for MySQL Server – the online backup in MySQL 6.0, it’s to ship in commercial version…
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… (0.03 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port… (0,11 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… and speaking at the MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back in 2003), and for me…=”alignright” width=”336″] Registration signs from the 2003 MySQL Users Conference and Expo in San Jose, Calif. It ran from April 10-11… New Companies. Many companies and products in the MySQL space have been launched at this show. It is important for me to stay…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… in MySQL 5.6, because all SELECT queries in the …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… –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql….
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… -D dbid=linkdb -D host=127.0.0.1 -D user=root -D port=3306 -D password= -D maxid1=100000001 -c…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in… was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure no additional…
