… properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0… possible relationships between columns/tables based on names, tables without indexes, columns flagged ‘nullable’ and ‘must be unique’ (woops!), single column…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to… to missing libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used to hold…
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… the index will be created-, but we will get a warning (note severity, to be exact): mysql> ALTER TABLE test ADD INDEX (col2…% of all applications out there that use MySQL, for which we at Percona tend to find redundant indexes. And second, because in some…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… better than another equivalent solution. If you’re talking about using a temporary table to store an interim result set, and…, if I were using the tuple syntax to look up values against multiple columns in a compound index, then the order would… in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… was used so, there was no caching of data at the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I used a 10GB key buffer. I used ALTER… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
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…now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve … tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… explicitly named foreign key constraint which implied an implicit secondary index with the same name. Fixed by detecting such cases and… Kopytov). Percona Server for MySQL was built with YaSSL which could cause some of the programs that use it to crash. Fixed… #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…replication. The buffer pool and adaptive hash index on the standby server will not have…| percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name … will need Percona Server in order to use innodb_fake_changes. Thread pool Percona Playback…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… key constraint which implied an implicit secondary index with the same name. Fixed by detecting … optimization. Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data … Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…node communication). Results: First of all, we used a smaller dataset for this benchmarks …–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…oltp-read-only=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT…
