server_status_monitor.php 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115
  1. <?php
  2. /* vim: set expandtab sw=4 ts=4 sts=4: */
  3. /**
  4. * Server status monitor feature
  5. *
  6. * @package PhpMyAdmin
  7. */
  8. require_once 'libraries/common.inc.php';
  9. require_once 'libraries/server_common.inc.php';
  10. require_once 'libraries/ServerStatusData.class.php';
  11. require_once 'libraries/server_status_monitor.lib.php';
  12. if (PMA_DRIZZLE) {
  13. $server_master_status = false;
  14. $server_slave_status = false;
  15. } else {
  16. include_once 'libraries/replication.inc.php';
  17. include_once 'libraries/replication_gui.lib.php';
  18. }
  19. /**
  20. * Ajax request
  21. */
  22. if (isset($_REQUEST['ajax_request']) && $_REQUEST['ajax_request'] == true) {
  23. // Send with correct charset
  24. header('Content-Type: text/html; charset=UTF-8');
  25. // real-time charting data
  26. if (isset($_REQUEST['chart_data'])) {
  27. switch($_REQUEST['type']) {
  28. case 'chartgrid': // Data for the monitor
  29. $ret = PMA_getJsonForChartingData();
  30. PMA_Response::getInstance()->addJSON('message', $ret);
  31. exit;
  32. }
  33. }
  34. if (isset($_REQUEST['log_data'])) {
  35. if (PMA_MYSQL_INT_VERSION < 50106) {
  36. // Table logging is only available since 5.1.6
  37. exit('""');
  38. }
  39. $start = intval($_REQUEST['time_start']);
  40. $end = intval($_REQUEST['time_end']);
  41. if ($_REQUEST['type'] == 'slow') {
  42. $return = PMA_getJsonForLogDataTypeSlow($start, $end);
  43. PMA_Response::getInstance()->addJSON('message', $return);
  44. exit;
  45. }
  46. if ($_REQUEST['type'] == 'general') {
  47. $return = PMA_getJsonForLogDataTypeGeneral($start, $end);
  48. PMA_Response::getInstance()->addJSON('message', $return);
  49. exit;
  50. }
  51. }
  52. if (isset($_REQUEST['logging_vars'])) {
  53. $loggingVars = PMA_getJsonForLoggingVars();
  54. PMA_Response::getInstance()->addJSON('message', $loggingVars);
  55. exit;
  56. }
  57. if (isset($_REQUEST['query_analyzer'])) {
  58. $return = PMA_getJsonForQueryAnalyzer();
  59. PMA_Response::getInstance()->addJSON('message', $return);
  60. exit;
  61. }
  62. }
  63. /**
  64. * JS Includes
  65. */
  66. $header = $response->getHeader();
  67. $scripts = $header->getScripts();
  68. $scripts->addFile('jquery/jquery.tablesorter.js');
  69. $scripts->addFile('jquery/jquery.sortableTable.js');
  70. $scripts->addFile('jquery/jquery-ui-timepicker-addon.js');
  71. /* < IE 9 doesn't support canvas natively */
  72. if (PMA_USR_BROWSER_AGENT == 'IE' && PMA_USR_BROWSER_VER < 9) {
  73. $scripts->addFile('jqplot/excanvas.js');
  74. }
  75. $scripts->addFile('canvg/canvg.js');
  76. // for charting
  77. $scripts->addFile('jqplot/jquery.jqplot.js');
  78. $scripts->addFile('jqplot/plugins/jqplot.pieRenderer.js');
  79. $scripts->addFile('jqplot/plugins/jqplot.canvasTextRenderer.js');
  80. $scripts->addFile('jqplot/plugins/jqplot.canvasAxisLabelRenderer.js');
  81. $scripts->addFile('jqplot/plugins/jqplot.dateAxisRenderer.js');
  82. $scripts->addFile('jqplot/plugins/jqplot.highlighter.js');
  83. $scripts->addFile('jqplot/plugins/jqplot.cursor.js');
  84. $scripts->addFile('jqplot/plugins/jqplot.byteFormatter.js');
  85. $scripts->addFile('server_status_monitor.js');
  86. $scripts->addFile('server_status_sorter.js');
  87. /**
  88. * start output
  89. */
  90. $ServerStatusData = new PMA_ServerStatusData();
  91. /**
  92. * Output
  93. */
  94. $response->addHTML('<div>');
  95. $response->addHTML($ServerStatusData->getMenuHtml());
  96. $response->addHTML(PMA_getHtmlForMonitor($ServerStatusData));
  97. $response->addHTML(PMA_getHtmlForClientSideDataAndLinks($ServerStatusData));
  98. $response->addHTML('</div>');
  99. exit;
  100. ?>