My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
ExamplePerformanceLogTable  
DDL for a table to store the entries from the performance log
Featured, Phase-Deploy
Updated May 6, 2010 by greenlion@gmail.com

You can use LOAD DATA INFILE to populate the table

  CREATE TABLE performance_log (
   access_time datetime DEFAULT NULL,
   remote_address varchar(25) DEFAULT NULL,
   bytes_in bigint(20) unsigned DEFAULT NULL,
   bytes_out bigint(20) unsigned DEFAULT NULL,
   service_time bigint(20) DEFAULT NULL,
   file varchar(100) DEFAULT NULL,
   protocol char(10) DEFAULT NULL,
   action char(10) DEFAULT NULL,
   query_string text,
   status smallint(5) unsigned DEFAULT NULL,
   virtualhost varchar(50) DEFAULT NULL,
   total_cpu_time float DEFAULT NULL,
   cpu_user float DEFAULT NULL,
   cpu_system float DEFAULT NULL,
   memory_usage int(10) unsigned DEFAULT NULL,
   request_id char(40) DEFAULT NULL,
   SESSION_uname varchar(25) DEFAULT NULL,
   session_id char(32) DEFAULT NULL,
   mysql_query_count mediumint(9) DEFAULT NULL,
   mysql_prepare_count mediumint(9) DEFAULT NULL,
   mysql_prepare_time float DEFAULT NULL,
   mysql_connection_count mediumint(9) DEFAULT NULL,
   mysql_query_exec_time float DEFAULT NULL,
   mysql_connect_time float DEFAULT NULL,
   mysql_deadlock_count mediumint(9) DEFAULT NULL,
   memcache_connection_count mediumint(9) DEFAULT NULL,
   memcache_connect_time mediumint(9) DEFAULT NULL,
   memcache_delete_count mediumint(9) DEFAULT NULL,
   memcache_delete_time float DEFAULT NULL,
   memcache_miss_count mediumint(9) DEFAULT NULL,
   memcache_get_count mediumint(9) DEFAULT NULL,
   memcache_get_time float DEFAULT NULL,
   memcache_set_count mediumint(9) DEFAULT NULL,
   memcache_set_time float DEFAULT NULL,
   memcache_add_count mediumint(9) DEFAULT NULL,
   memcache_add_time float DEFAULT NULL,
   memcache_replace_count mediumint(9) DEFAULT NULL,
   memcache_replace_time float DEFAULT NULL,
   memcache_increment_count mediumint(9) DEFAULT NULL,
   memcache_increment_time float DEFAULT NULL,
   memcache_decrement_count mediumint(9) DEFAULT NULL,
   memcache_decrement_time float DEFAULT NULL
 )

Powered by Google Project Hosting