…the mysql.properties file in the same directory as the jar file, I don’t need to…in tables, and tables with the string NULL instead of the actual SQL NULL value. This is basically a quick sanity check…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in the default SQL mode, a duplicate index…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…to look up values against multiple columns in a compound index, then the order would matter, and it would have to match the order of columns in the index… Check out upcoming Percona Training classes in North America and Europe. Join Percona and the MySQL community at our events. The next one is in …
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60.3 is the first RC release in the…the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…index with the same name. Fixed by detecting such cases and omitting the… Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by …in the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…the Percona Live MySQL Conference and Expo next week in Santa Clara, California so look for me there – I’d love to…the graphs from such self-warming experiments look like this one. The green part of the graph lines up with the blue part. Check…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…of datadir ~10GB). We used this dataset to check server behavior when data fully fits buffer…->mutex,&new_index->lock. I profiled 5.6.11 in this IO bound scenario with the perf …In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
…the same question arises: How many MySQL records were recovered and how many were lost. Until now there was no way to answer the… to know how many records an InnoDB page stores. The index…the contraints_parser tries to recover the records. It checks whether fields have permitted values, etc. In the…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…to check if the dataset size makes any difference. We first excluded NUMA from the…the descriptors optimization that I thought was explained in the original post, but seems to cause much confusion. Even though the read-only transactions optimization in MySQL…oltp-index-updates=0 –oltp-non-index-…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…the index. Percona XtraBackup has implemented Encrypted Backups. This feature can be used to encrypt/decrypt both local and streamed backups in order to…
