tag:blogger.com,1999:blog-6864099895737809960.post3636478186779315374..comments2010-03-19T23:44:40.294+01:00Comments on Shinguz' Blog: Reading other processes memoryShinguzhttp://www.blogger.com/profile/11195863756524022642noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6864099895737809960.post-53987531052422988732009-08-19T08:34:06.624+02:002009-08-19T08:34:06.624+02:00A colleague pointed out that I was missing some in...A colleague pointed out that I was missing some information:<br /><br />The operative worklog task is WL#2360 and its dependencies, WL#4034 is a raw-idea bin item of no current significance.<br /><br />The complete specification of the performance schema can be found here:<br /><br /><a href="http://forge.mysql.com/worklog/task.php?id=2333" rel="nofollow">WL#2333: SHOW ENGINE ... LOCK STATUS</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=2360" rel="nofollow">WL#2360: Performance Schema</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=2515" rel="nofollow">WL#2515: Performance statements</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=3249" rel="nofollow">WL#3249: SHOW PROCESSLIST should show memory</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=4674" rel="nofollow">WL#4674: PERFORMANCE_SCHEMA Setup For Actors</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=4678" rel="nofollow">WL#4678: PERFORMANCE_SCHEMA Instrumenting File IO</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=4813" rel="nofollow">WL#4813: PERFORMANCE_SCHEMA Instrumenting Stages</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=4816" rel="nofollow">WL#4816: PERFORMANCE_SCHEMA Summaries</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=4895" rel="nofollow">WL#4895: PERFORMANCE_SCHEMA Instrumenting Table IO</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=4878" rel="nofollow">WL#4878: PERFORMANCE_SCHEMA Trace</a><br /><a href="http://forge.mysql.com/worklog/task.php?id=4896" rel="nofollow">WL#4896: PERFORMANCE_SCHEMA Instrumenting Net IO</a><br /><br />There is an implementation of WL#2360 which was demonstrated 11 months ago at the MySQL developer conference:<br /><br /><a href="http://blogs.mysql.com/peterg/2009/02/05/mysql-performance-schema/" rel="nofollow">Blog post 1</a><br /><a href="http://blogs.mysql.com/peterg/2009/02/06/mysql-performance-schema-2/" rel="nofollow">Blog post 2</a><br /><a href="http://blogs.mysql.com/peterg/2009/02/09/mysql-performance-schema-3/" rel="nofollow">Blog post 3</a><br /><a href="http://blogs.mysql.com/peterg/2009/02/10/mysql-performance-schema-4/" rel="nofollow">Blog post 4</a><br /><a href="http://blogs.mysql.com/peterg/2009/02/11/mysql-performance-schema-5/" rel="nofollow">Blog post 5</a><br /><a href="http://blogs.mysql.com/peterg/2009/02/12/mysql-performance-schema-6/" rel="nofollow">Blog post 6</a><br /><a href="http://blogs.mysql.com/peterg/2009/02/13/todo-mysql-performance-schema-7/" rel="nofollow">Blog post 7</a><br /><br />The source code of the server including the Performance Schema is available for <a href="https://code.launchpad.net/~marc.alff/mysql-server/mysql-6.0-perfschema" rel="nofollow">download from lauchpad</a>.Shinguzhttps://www.blogger.com/profile/11195863756524022642noreply@blogger.comtag:blogger.com,1999:blog-6864099895737809960.post-54202673450472298532009-08-15T00:36:42.847+02:002009-08-15T00:36:42.847+02:00I just read what I wrote, sorry for not making sen...I just read what I wrote, sorry for not making sense. What I meant:<br /><br />The *default* INNODB STATUS method of showing statistics is for anywhere between 0 seconds to 60 seconds makes it difficult. 0-10 seconds is usually useless because it averages too much, and it's entirely unpredictable what interval InnoDB uses.<br /><br />Your script allows me to just get the current value (not an average). Brilliant!Morgan Tockerhttps://www.blogger.com/profile/07820955267400574921noreply@blogger.comtag:blogger.com,1999:blog-6864099895737809960.post-81631063653681554702009-08-14T19:32:11.644+02:002009-08-14T19:32:11.644+02:00Hi Morgan,
Do not get this. With the script read_...Hi Morgan,<br /><br />Do not get this. With the script <a href="http://www.shinguz.ch/MySQL/read_process_memory.sh" rel="nofollow">read_process_memory.sh</a> you can sample at a specific interval with a timestamp in the record and write a *.csv. That must be ideal for Cacti or any other monitoring/graphing tool, is it not? You could even extend it to write directly to a database...<br /><br />Please elaborate a bit more your concern.Shinguzhttps://www.blogger.com/profile/11195863756524022642noreply@blogger.comtag:blogger.com,1999:blog-6864099895737809960.post-40655464995069194982009-08-14T15:22:46.692+02:002009-08-14T15:22:46.692+02:00Very nice! I can see the real use with some of th...Very nice! I can see the real use with some of the InnoDB stats. The random sampling interval makes it very difficult to get good numbers to use for cacti/RRDTool graphs.Morgan Tockerhttps://www.blogger.com/profile/07820955267400574921noreply@blogger.com