tag:blogger.com,1999:blog-3080615211468083537.post4200376738042881610..comments2023-09-27T11:36:08.392+03:00Comments on Blog of (former?) MySQL Entomologist: Fun with Bugs #24 - PERFORMANCE_SCHEMAValerii Kravchukhttp://www.blogger.com/profile/13158916419325454260noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-3080615211468083537.post-27462325448546047732013-10-01T09:48:25.846+03:002013-10-01T09:48:25.846+03:00Thank you for clarification, Peter. I'd call y...Thank you for clarification, Peter. I'd call you a "godmather" of PERFORMANCE_SCHEMA, but it seems I should just shut up if I do not want to be misinterpreted again.<br /><br />Surely PERFORMANCE_SCHEMA is useful "as is", and I've used it myself more than once. It's just painful to type the name every time and table names in it are also too verbose. I am spoiled by spending too much time with V$SQL and V$WAIT_EVENT in my life before MySQL...Valerii Kravchukhttps://www.blogger.com/profile/13158916419325454260noreply@blogger.comtag:blogger.com,1999:blog-3080615211468083537.post-44150625073439651452013-10-01T01:04:41.429+03:002013-10-01T01:04:41.429+03:00Hi,
The name isn't from any SQL standard. As ...Hi,<br /><br />The name isn't from any SQL standard. As the worklog task description says:<br />"Proposals for the schema name were DYNAMIC (but that is a reserved word in standard SQL), PERFORMANCE_SCHEMA (Jim Winstead's suggestion), PERFORMANCE (Peter's preference), and DBTrace because it sounds like DTrace. There was a vote (see dev-private thread "WL#2360 Vote: schema name and table name"). The winner was PERFORMANCE_SCHEMA."<br />http://dev.mysql.com/worklog/task/?id=2360<br />I was responsible for writing that and all related worklog tasks at the time, but if you want to blame a godfather, try Jim.<br /><br />Peter Gulutzan<br />ocelot.ca/blog<br /><br />Anonymoushttps://www.blogger.com/profile/02616590943660523003noreply@blogger.comtag:blogger.com,1999:blog-3080615211468083537.post-44932717267663023242013-09-30T22:25:09.011+03:002013-09-30T22:25:09.011+03:00> Before that it seems that the only sane way t...> Before that it seems that the only sane way to use P_S on a regular basis in interactive command line client is via ps_helper, created by the godfather of P_S, Mark Leith. <br /><br />PS_HELPER is great, but P_S in 5.6 can be used even without it. You should read Marc Allf's blog or, if you prefer Russian language, download slides from my seminar at Devconf 2013 (See my LJ user info). You will find a lot of examples there.svetasmirnovahttps://www.blogger.com/profile/04519424198114048451noreply@blogger.comtag:blogger.com,1999:blog-3080615211468083537.post-24654992423274801372013-09-30T12:09:34.634+03:002013-09-30T12:09:34.634+03:00English is not my native language, but I think tha...English is not my native language, but I think that "godfather" is correct term to define the role of Mark Leith in the process. I never claimed that he is the author of PERFORMANCE_SCHEMA.Valerii Kravchukhttps://www.blogger.com/profile/13158916419325454260noreply@blogger.comtag:blogger.com,1999:blog-3080615211468083537.post-11071856865117952592013-09-29T05:45:50.345+03:002013-09-29T05:45:50.345+03:00A godfather isn't a parent. You are the fathe...A godfather isn't a parent. You are the father Marc. A godfather is a beloved friend that helps with upbringing.Justin Swanharthttps://www.blogger.com/profile/08193089637089861226noreply@blogger.comtag:blogger.com,1999:blog-3080615211468083537.post-37867012129978040332013-09-28T22:37:52.878+03:002013-09-28T22:37:52.878+03:00The author of 'ps_helper' is Mark Leith.
...The author of 'ps_helper' is Mark Leith.<br /><br />The author of the PERFORMANCE_SCHEMA itself, is Marc Alff (myself).<br /><br />I am sure you have your own opinions on bugs themselves, but at the very minimum I would expect credits to be attributed correctly.<br /><br />-- Marc Alff<br />Marc Alffhttps://www.blogger.com/profile/10657419226323022344noreply@blogger.comtag:blogger.com,1999:blog-3080615211468083537.post-60517842890380344832013-09-28T20:29:09.376+03:002013-09-28T20:29:09.376+03:00Cool nugget of information in one of those posts t...Cool nugget of information in one of those posts that shows something that I would never have though to try in a million years:<br /><br />SHOW ENGINE PERFORMANCE_SCHEMA STATUSJustin Swanharthttps://www.blogger.com/profile/08193089637089861226noreply@blogger.com