…descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory … would allow remote attacker to detect what user accounts exist on the server. This bug… the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password…
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… the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL server’s…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: …) Records: 0 Duplicates: 0 Warnings: 0 $ mysqlindexcheck –server=user:pass@localhost test.test # Source on localhost: … connected. $…
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…’,master_user=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql… to know the coordinates of the last event executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… the year that marked the first MySQL user conference independently organized by MySQL AB. It was called the “MySQL Users Conference” and took place at… show with keynotes and I recall one of them saying something like, “12 full-time engineers are working on MySQL server.” The MySQL… refocused back on MySQL and the needs of the MySQL community covering other technologies, as it is relevant to MySQL users. MySQL, MariaDB, Percona Server…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… (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
… my 10th year attending and speaking at the MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back…’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: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing… was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure no additional…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… it can read queries from MySQL query-log and MySQL tcpdump files and run them on other MySQL server. With Percona Playback you… MySQL database server. Percona Playback for MySQL can also help evaluate new server versions, patches and hardware against existing setups to allow users…. Bugs fixed: Percona Playback for MySQL now shows error when it’s unable to connect to the MySQL database server. Bug fixed #1070824…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… available for download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost…_window and evs.user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would… leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would…
