… helper Debug Storage Procedure which will log some information in MySQL table but it is not convenient enough. Bad Parser Error… road blocks even before you start fighting with debugging. No Profiling tools If you’re interested in Performance you need a… same thing using direct statements. This allows to debug and profile most of the things comfortably and works pretty well especially…
Post: Using flow control functions for performance monitoring queries
May 24, 2008 By 12 Comments
… track types of pages because they often have different performance profile. mysql> select count(*) cnt, avg(wtime) avw, sum(if(wtime>0… | search | | 25843 | 1.1290003426468 | 0.9114 | 0.4267 | 0.0081 | profile | … | 4393 | 0.63011296296095 | 0.5852 | 0.1689 | 0.0052 | rss… “search” page responds within 1 second in about 95% while profile page in less than 60% – It is very important to…
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
… contributions accepted into community version. The great question however why MySQL did not announce the split just now when it really… following: Are the more cool features to follow ? Jeremy’s PROFILE patches are great but I hope the patches will be… as profiling patches in it I guess many big web guys will use community version too. This is of course if MySQL…
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 14 Comments
… how you can profile queries to see what exactly happens during query execution – very helpful for MySQL Performance optimization: mysql> flush status; Query OK, 0 rows affected (0.00 sec) mysql> SELECT sql_no_cache…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Overview Profiling, analyzing and then fixing queries is likely the most oft-… enable logging atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise we might… next part of the output produced by pt-query-digest. # Profile # Rank Query ID Response time Calls R/Call Apdx V…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…caption id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far… 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default… row in set (0.00 sec) Finally, I collected SHOW PROFILES information for the faster join direction (fact -> dimension) select p1…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… The MyISAM table recording the space ids of the tables mysql> show create table test.tablesG *************************** 1. row *************************** Table: tables Create… id in a .ibd file. #root@domU:/mnt/tables# hexdump profile_data.ibd -C | head -4 #00000000 62 bd c3 19…_TABLENAME.ibd /var/lib/mysql/recover/ chown mysql.mysql /var/lib/mysql/recover/$CURRENT_TABLENAME.ibd sleep 1 echo “importing tablespace” mysql -u root -e…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… from MySQL 5.4 and merry it with unique Percona patches (adaptive checkpoints, additional undo slots, profiling, etc) and integrate it with MySQL…, like XtraDB there are 3 innodb versions around. There is MySQL 5.0 version which did not get significant changes for… set of Innodb changes. Why not to include plugin in MySQL 5.4 with relevant performance changes instead ? This would highlight…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
… seen some claims by others in the MySQL community that MySQL 5.1 runs faster than MySQL 5.0. Guess what? They’re… kind of changes in MySQL 5.0 result in this behavior. It also would be good to run profiling for these results to see where these few percent are lost for MySQL 5.0 to see…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1… patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just… waiting by spinning on the spinlock wasting CPU cycles. Detailed profiling tells which one.
