…5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:… columns/tables based on names, tables without indexes, columns flagged ‘nullable’ and ‘must be unique’ (woops… value. This is basically a quick sanity check of your schema for any significant errors …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2); Query OK… release” means. In MySQL 5.7 the checks will be stricter: in the default SQL mode, a duplicate index will throw a warning… query optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL server, of course…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the… some more tips: Check out upcoming Percona Training classes in North America and Europe. Join Percona and the MySQL community at our…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption… tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER… the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations….
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…for replication. The buffer pool and adaptive hash index on the standby server will not have …slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query…the graph lines up with the blue part. Check back Thursday for Part…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… key constraint which implied an implicit secondary index with the same name. Fixed by detecting…the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch …(Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help …
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… nearly every recovery case the same question arises: How many MySQL records were recovered and how many were lost. Until now…: ./constraints_parser -5f pages-actor/FIL_PAGE_INDEX/0-1599/00000000-00000003.page -V … Checking a page Infimum offset: 0×63 Supremum offset…. Then the contraints_parser tries to recover the records. It checks whether fields have permitted values, etc. In the end it…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… this benchmark for MySQL Server 5.5.30, 5.6.11 and Percona Server 5.5.30 and check how these servers… data size of datadir ~10GB). We used this dataset to check server behavior when data fully fits buffer pool(size of… related to BUG#67808. For MySQL 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock. I profiled 5.6…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…(about 23GB). So it makes sense to check if the dataset size makes any difference…. –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-…–oltp-read-only=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT +…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…by XtraBackup when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel … Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client… SST to fail. Fixed by fix checking if xtrabackup_pid file exists once innobackupex…
