function acquia_spi_get_platform_mysql_data in Acquia Connector 7.2
Same name and namespace in other branches
- 6.2 acquia_spi/acquia_spi.module \acquia_spi_get_platform_mysql_data()
1 call to acquia_spi_get_platform_mysql_data()
- acquia_spi_get_platform in acquia_spi/
acquia_spi.module - Gather platform specific information.
File
- acquia_spi/
acquia_spi.module, line 1389 - Send site profile information (NSPI) and system data to Acquia Insight.
Code
function acquia_spi_get_platform_mysql_data() {
$connection = Database::getConnection('default');
// Backup and restore PDO::ATTR_CASE. Prior to Drupal 7.14 this is
// PDO::CASE_LOWER. Afterwards it is PDO::CASE_NATURAL.
$orig = $connection
->getAttribute(PDO::ATTR_CASE);
$connection
->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);
$result = $connection
->query("SHOW GLOBAL STATUS", array(), array());
// Restore the attribute.
$connection
->setAttribute(PDO::ATTR_CASE, $orig);
$ret = array();
if (empty($result)) {
return $ret;
}
foreach ($result as $record) {
if (!isset($record->variable_name)) {
continue;
}
switch ($record->variable_name) {
case 'Table_locks_waited':
$ret['Table_locks_waited'] = $record->value;
break;
case 'Slow_queries':
$ret['Slow_queries'] = $record->value;
break;
case 'Qcache_hits':
$ret['Qcache_hits'] = $record->value;
break;
case 'Qcache_inserts':
$ret['Qcache_inserts'] = $record->value;
break;
case 'Qcache_queries_in_cache':
$ret['Qcache_queries_in_cache'] = $record->value;
break;
case 'Qcache_lowmem_prunes':
$ret['Qcache_lowmem_prunes'] = $record->value;
break;
case 'Open_tables':
$ret['Open_tables'] = $record->value;
break;
case 'Opened_tables':
$ret['Opened_tables'] = $record->value;
break;
case 'Select_scan':
$ret['Select_scan'] = $record->value;
break;
case 'Select_full_join':
$ret['Select_full_join'] = $record->value;
break;
case 'Select_range_check':
$ret['Select_range_check'] = $record->value;
break;
case 'Created_tmp_disk_tables':
$ret['Created_tmp_disk_tables'] = $record->value;
break;
case 'Created_tmp_tables':
$ret['Created_tmp_tables'] = $record->value;
break;
case 'Handler_read_rnd_next':
$ret['Handler_read_rnd_next'] = $record->value;
break;
case 'Sort_merge_passes':
$ret['Sort_merge_passes'] = $record->value;
break;
case 'Qcache_not_cached':
$ret['Qcache_not_cached'] = $record->value;
break;
}
}
return $ret;
}