{"id":131,"date":"2006-02-03T16:46:19","date_gmt":"2006-02-03T21:46:19","guid":{"rendered":"https:\/\/www.thehouse.net\/2006\/02\/03\/mysql-monitor-ajaxified\/"},"modified":"2006-08-15T14:16:51","modified_gmt":"2006-08-15T18:16:51","slug":"mysql-monitor-ajaxified","status":"publish","type":"post","link":"https:\/\/www.thehouse.net\/?p=131","title":{"rendered":"MySQL Monitor &#8211; Ajaxified"},"content":{"rendered":"<p><img decoding=\"async\" align=\"right\" alt=\"MySQL Logo\" id=\"image133\" src=\"https:\/\/i0.wp.com\/www.thehouse.net\/wp-content\/uploads\/2006\/02\/mysql_100x52-64.gif?ssl=1\" data-recalc-dims=\"1\" \/>I use a MySQL database in most, if not all, my website development projects. In some cases, especially with applications\/sites that tend to get a large number of hits (and as such, a greater number of interactions with the database), it&#8217;s nice to be able to see what the DB engine is doing, how many threads are running, etc. My tool of choice has been <a target=\"_blank\" title=\"MyTop - a top clone for MySQL\" href=\"http:\/\/jeremy.zawodny.com\/mysql\/mytop\/\">MyTop by Jeremy Zawodny<\/a> for a couple years now.  Recently, it looks like someone wanting to learn some Ajax has decided to port Jeremy&#8217;s great tool  over to an ajaxified webpage! No need to login to the database server and run mytop in a console anymore; now I can do it straight from a web browser!<\/p>\n<p>The project is called <a target=\"_blank\" title=\"ajaxMyTop Project\" href=\"http:\/\/sourceforge.net\/projects\/ajaxmytop\/\">ajaxMyTop and is hosted on Sourceforge<\/a>. Currently, there is no home page or details on the project website, but <a title=\"Ajaxian review of ajaxMyTop\" target=\"_blank\" href=\"http:\/\/ajaxian.com\/archives\/779\">Ajaxian has a good review of the application<\/a>.<\/p>\n<p>One note of caution; the application is written for PHP5. There is a <a target=\"_blank\" title=\"ajaxMyTop PHP4 patch\" href=\"http:\/\/sourceforge.net\/forum\/forum.php?thread_id=1431063&#038;forum_id=526557\">small modification available<\/a> which will enable the application to run under PHP4. It&#8217;s located in the ajaxMyTop forums:<\/p>\n<p><a target=\"_blank\" title=\"ajaxMyTop PHP4 Patch forum thread\" href=\"http:\/\/sourceforge.net\/forum\/forum.php?thread_id=1431063&#038;forum_id=526557\">http:\/\/sourceforge.net\/forum\/forum.php?thread_id=1431063&#038;forum_id=526557<\/a><\/p>\n<p>Sites mentioned:<\/p>\n<p><a target=\"_blank\" title=\"Ajaxian Review of ajaxMyTop\" href=\"http:\/\/ajaxian.com\/archives\/779\">http:\/\/ajaxian.com\/archives\/779<\/a> &#8211; Ajaxian Review of ajaxMyTop<br \/>\n<a target=\"_blank\" title=\"Jeremy Zawodny's original mytop webpage\" href=\"http:\/\/jeremy.zawodny.com\/mysql\/mytop\/\">http:\/\/jeremy.zawodny.com\/mysql\/mytop\/<\/a> &#8211; Jeremy Zawodny&#8217;s original mytop webpage<br \/>\n<a target=\"_blank\" title=\"ajaxMyTop Project Website\" href=\"http:\/\/sourceforge.net\/projects\/ajaxmytop\/\">http:\/\/sourceforge.net\/projects\/ajaxmytop\/<\/a> &#8211; ajaxMyTop Project Website<!-- ckey=\"47AFAFB5\" --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I use a MySQL database in most, if not all, my website development projects. In some cases, especially with applications\/sites that tend to get a large number of hits (and as such, a greater number of interactions with the database), it&#8217;s nice to be able to see what the DB engine is doing, how many [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":""},"categories":[4,7,6,5],"tags":[],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-bookmarks","category-geek-stuff","category-linux","category-reviews"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pA6RZ-27","_links":{"self":[{"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=131"}],"version-history":[{"count":0,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.thehouse.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}