June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

… sanity check of your schema for any significant errors or items requiring review. Columns – a listing of all columns in the… can then write into your metadata file. Donate – This is free software and John Currier asks for donations so he can… you use and how do they compare with SchemaSpy?  Feel free to answer via the comments.  Thanks for reading!

Post: Percona Monitoring Plugins 1.0.3 for MySQL now available

… with all kind of threads (bug 1157911) * Some Cacti single-item graphs were broken due to cacti hexadecimal transformation (bug 1155513… fully supported for customers with a Percona Support contract and free installation services are provided as part of some contracts. In…

Post: Improved InnoDB fast index creation

… | 0.000007 | | query end | 0.000003 | | closing tables | 0.000008 | | freeing items | 0.000021 | | cleaning up | 0.000003 | +——————————+———–+ 18 rows in set… | 0.000007 | | query end | 0.000003 | | closing tables | 0.000008 | | freeing items | 0.000019 | | cleaning up | 0.000003 | +——————————+———–+ 19 rows in set…

Comment: Solving INFORMATION_SCHEMA slowness

….000012 | | Opening tables | 0.000013 | | removing tmp table | 0.000013 | | freeing items | 0.000014 | | Opening tables | 0.000014 | | Opening tables | 0.000014… | 0.000030 | | Opening tables | 0.000030 | | Opening tables | 0.000030 | | freeing items | 0.000031 | | Opening tables | 0.000031 | | Opening tables | 0.000031…

Comment: Query_cache and column level privileges

… end | 0.000005 | | storing result in query cache | 0.000005 | | freeing items | 0.000012 | | closing tables | 0.000007 | | logging slow query | 0… data | 0.000024 | | end | 0.000007 | | query end | 0.000004 | | freeing items | 0.000012 | | closing tables | 0.000007 | | logging slow query | 0…

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

…_pool_stats\G *************************** 1. row *************************** POOL_ID: 0 POOL_SIZE: 8191 FREE_BUFFERS: 1024 DATABASE_PAGES: 7162 OLD_DATABASE_PAGES: 2623 MODIFIED… * POOL_ID: 0 POOL_SIZE: 8192 * POOL_SIZE: 8191 FREE_BUFFERS: 1024 * FREE_BUFFERS: 1024 DATABASE_PAGES: 7163 * DATABASE_PAGES: 7162 OLD….000000 | 0.000000 | 0 | 0 | 0 | 0 | 14 | 14 | | 16 | freeing items | 0.000049 | 0.000117 | 0.000000 | 0.001000 | 0 | 0…

Post: NDB tutorial at Percona Live London + Free TIcket Give Away

…. Be ready for a fast ramp-up on NDB! Among items covered: – Achitecture – Installation – Loading data – Administration (common procedures) – Node recovery… tutorials and conference schedules. For a chance to win a free ticket to Percona Live London simply watch our @Percona Twitter stream and retweet the contest to win a free ticket! One lucky winner will be picked every Friday up…

Post: Write contentions on the query cache

…                  | 0.000008 | | query end            | 0.000004 | | closing tables       | 0.000032 | | freeing items        | 0.000035 | | logging slow query   | 0.000004 | | cleaning up          | 0…

Post: How to convert MySQL's SHOW PROFILES into a real profile

… | 0.0000355000 | | starting | 0.000032 | 0.02 | 1 | 0.0000320000 | | freeing items | 0.000027 | 0.02 | 2 | 0.0000135000 | | preparing | 0.000025…