Percona's MySQL & InnoDB performance and scalability blog
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.
@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.
Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering 
Thanks for sharing.
… website where we have about 1200 tables each with hundreds of thousands of records, for we use sphinx based on attributes, but…
…; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ Great! So again, using GTIDs avoids the tedious work of looking for the binlog position of a… the data with mysqlbinlog? There is a solution of course, but very poor in my opinion: look for the binlog file/position…
… well as hosts of OpenSQL Camp in 2009. As such it is a very natural place for our next Percona MySQL University event… area. Percona MySQL University is a daylong, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers…
… are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs… and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of the servers with GTIDs Let… by inspecting the output of SHOW SLAVE STATUS? Look at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto…
Can different filters be combined? For example, all the select queries in mysql.user from a particular user.
…the metadata of a schema in a database and generates a visual representation of it in a … the relationships between tables versus observing queries only. An additional benefit is that…in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.