…using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required, I prefer to…to use the search feature of your browser to zero in on a particular table Constraints – lists the explicit Foreign Key…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…not -for example, if one of the two indexes was unique or a foreign key. This is the output of our tool when…to pt-duplicate-key-checker, but it does not detect all cases. For example: mysql> alter table test add index…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…to performance is a case-by-case decision. There are other drawbacks to using temporary tables in this way, for example when using…to force MySQL to scan the `title` table first, grouping by kind_id in index…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…when the working set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used…indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I used a 10GB key buffer. I used ALTER TABLE DISABLE KEYS…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…keys option it produced invalid SQL for cases when there was an explicitly named foreign key constraint which implied an implicit secondary index…to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…index on the standby server will not have recently accessed pages. When…mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql…to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on the standby server. You will need Percona Server in order to use… key errors…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…keys option it produced invalid SQL for cases when there was an explicitly named foreign key constraint which implied an implicit secondary index…to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…when switching to Galera is existence of a replication feedback mechanism, unlike anything you find in standard async MySQL…to date without needing to use…key lookups into the certification index, which is a hash table. A small fc_limit does however keep the certification index…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… locking in Innodb is a single row (well, the PRIMARY KEY index entry for that row). This means typically on a single… to replicate your data to a distributed system requires tradeoffs. Most of us are used to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… PARTITIONed or non-PARTITIONed. When PARTITIONed, first it has to find and open the …not the whole table”: * If the DELETE is a single row based on a UNIQUE/PRIMARY key…mysql.rjweb.org/doc.php/partitionmaint The third use case for PARTITIONing involves 2D-like indexing. I have not found a 4th use…
