{"id":481,"date":"2007-03-03T12:53:39","date_gmt":"2007-03-03T17:53:39","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/03\/03\/mysql-with-show-profile-and-updated-information_schema-built-from-the-community-tree"},"modified":"2007-03-03T12:54:43","modified_gmt":"2007-03-03T17:54:43","slug":"mysql-with-show-profile-and-updated-information_schema-built-from-the-community-tree","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/03\/03\/mysql-with-show-profile-and-updated-information_schema-built-from-the-community-tree","title":{"rendered":"MySQL, with SHOW PROFILE and updated INFORMATION_SCHEMA, built from the Community tree"},"content":{"rendered":"

I just built mysql-5.0-community, on my T7200 with 2GB of RAM (on Fedora Core 6), and it only took a mere:<\/p>\n

real    7m51.127s\n\nuser    3m13.836s\n\nsys     2m19.803s\n<\/pre>\n
The obligatory make test<\/code> was run, and that was also pretty quick:<\/p>\n
All 455 tests were successful.\n\nThe servers were restarted 109 times\n\nSpent 1134.052 seconds actually executing testcases\n\n<\/pre>\n
Maybe we could have a competition to see how fast MySQL builds (under 8 minutes) and tests (under 19 minutes), something similar to the 7-second Linux kernel compile<\/a>. With that it looks like 5.0.37 might make its way to the surface really soon now, since 5.0.35 was pending a release, before we canned that.<\/p>\n
Why is MySQL Community Server 5.0.37 significant? Because it contains Jeremy Cole’s SHOW PROFILE feature. Notice how thats not just a patch any longer, its a feature, from the community, that’s been implemented in the MySQL Community Server release. Chad Miller (in Community Engineering) also extended the then patch further, and now you can also get said information via the INFORMATION_SCHEMA (look at the PROFILING table in the INFORMATION_SCHEMA).<\/p>\n
Profiling isn’t enabled by default (check via: show variables like 'profiling';<\/tt>), so you’d do well to set profiling='on';<\/tt>. Once that is done, you can just execute SHOW PROFILE; to be greeted by the feature. Using the INFORMATION_SCHEMA database, and something like: select duration,source_function,source_file from profiling;<\/tt> I can see how much time MySQL takes to execute a function like the mysql_select or how long it takes to do open_tables – best of all, I can see which source file I might want to edit if need be.<\/p>\n
I’m told this does not work on Windows, or Solaris (?), because they don’t have the getrusage() syscall, but it should probably work just fine on OS X based MySQL servers.<\/p>\n
Technorati Tags: mysql<\/a>, SHOW PROFILE<\/a>, profiling<\/a>, mysql community<\/a>, mysql 5.0.37<\/a>, timing builds<\/a><\/p>\n
Share this:<\/h3>