mysql> show variables\G *************************** 1. row *************************** Variable_name: back_log Value: 50 *************************** 2. row *************************** Variable_name: basedir Value: /usr/ *************************** 3. row *************************** Variable_name: binlog_cache_size Value: 1048576 *************************** 4. row *************************** Variable_name: bulk_insert_buffer_size Value: 8388608 *************************** 5. row *************************** Variable_name: character_set_client Value: latin1 *************************** 6. row *************************** Variable_name: character_set_connection Value: latin1 *************************** 7. row *************************** Variable_name: character_set_database Value: latin1 *************************** 8. row *************************** Variable_name: character_set_results Value: latin1 *************************** 9. row *************************** Variable_name: character_set_server Value: latin1 *************************** 10. row *************************** Variable_name: character_set_system Value: utf8 *************************** 11. row *************************** Variable_name: character_sets_dir Value: /usr/share/mysql/charsets/ *************************** 12. row *************************** Variable_name: collation_connection Value: latin1_swedish_ci *************************** 13. row *************************** Variable_name: collation_database Value: latin1_swedish_ci *************************** 14. row *************************** Variable_name: collation_server Value: latin1_swedish_ci *************************** 15. row *************************** Variable_name: concurrent_insert Value: ON *************************** 16. row *************************** Variable_name: connect_timeout Value: 5 *************************** 17. row *************************** Variable_name: datadir Value: /var/lib/mysql/ *************************** 18. row *************************** Variable_name: date_format Value: %Y-%m-%d *************************** 19. row *************************** Variable_name: datetime_format Value: %Y-%m-%d %H:%i:%s *************************** 20. row *************************** Variable_name: default_week_format Value: 0 *************************** 21. row *************************** Variable_name: delay_key_write Value: ON *************************** 22. row *************************** Variable_name: delayed_insert_limit Value: 100 *************************** 23. row *************************** Variable_name: delayed_insert_timeout Value: 300 *************************** 24. row *************************** Variable_name: delayed_queue_size Value: 1000 *************************** 25. row *************************** Variable_name: expire_logs_days Value: 1 *************************** 26. row *************************** Variable_name: flush Value: OFF *************************** 27. row *************************** Variable_name: flush_time Value: 0 *************************** 28. row *************************** Variable_name: ft_boolean_syntax Value: + -><()~*:""&| *************************** 29. row *************************** Variable_name: ft_max_word_len Value: 84 *************************** 30. row *************************** Variable_name: ft_min_word_len Value: 4 *************************** 31. row *************************** Variable_name: ft_query_expansion_limit Value: 20 *************************** 32. row *************************** Variable_name: ft_stopword_file Value: (built-in) *************************** 33. row *************************** Variable_name: group_concat_max_len Value: 1024 *************************** 34. row *************************** Variable_name: have_archive Value: NO *************************** 35. row *************************** Variable_name: have_bdb Value: NO *************************** 36. row *************************** Variable_name: have_blackhole_engine Value: NO *************************** 37. row *************************** Variable_name: have_compress Value: YES *************************** 38. row *************************** Variable_name: have_crypt Value: YES *************************** 39. row *************************** Variable_name: have_csv Value: NO *************************** 40. row *************************** Variable_name: have_example_engine Value: NO *************************** 41. row *************************** Variable_name: have_geometry Value: NO *************************** 42. row *************************** Variable_name: have_innodb Value: YES *************************** 43. row *************************** Variable_name: have_isam Value: NO *************************** 44. row *************************** Variable_name: have_ndbcluster Value: NO *************************** 45. row *************************** Variable_name: have_openssl Value: YES *************************** 46. row *************************** Variable_name: have_query_cache Value: YES *************************** 47. row *************************** Variable_name: have_raid Value: YES *************************** 48. row *************************** Variable_name: have_rtree_keys Value: NO *************************** 49. row *************************** Variable_name: have_symlink Value: YES *************************** 50. row *************************** Variable_name: init_connect Value: *************************** 51. row *************************** Variable_name: init_file Value: *************************** 52. row *************************** Variable_name: init_slave Value: *************************** 53. row *************************** Variable_name: innodb_additional_mem_pool_size Value: 33554432 *************************** 54. row *************************** Variable_name: innodb_autoextend_increment Value: 8 *************************** 55. row *************************** Variable_name: innodb_buffer_pool_awe_mem_mb Value: 0 *************************** 56. row *************************** Variable_name: innodb_buffer_pool_size Value: 1073741824 *************************** 57. row *************************** Variable_name: innodb_data_file_path Value: ibdata1:10M:autoextend *************************** 58. row *************************** Variable_name: innodb_data_home_dir Value: *************************** 59. row *************************** Variable_name: innodb_fast_shutdown Value: ON *************************** 60. row *************************** Variable_name: innodb_file_io_threads Value: 4 *************************** 61. row *************************** Variable_name: innodb_file_per_table Value: ON *************************** 62. row *************************** Variable_name: innodb_flush_log_at_trx_commit Value: 1 *************************** 63. row *************************** Variable_name: innodb_flush_method Value: *************************** 64. row *************************** Variable_name: innodb_force_recovery Value: 0 *************************** 65. row *************************** Variable_name: innodb_lock_wait_timeout Value: 50 *************************** 66. row *************************** Variable_name: innodb_locks_unsafe_for_binlog Value: OFF *************************** 67. row *************************** Variable_name: innodb_log_arch_dir Value: *************************** 68. row *************************** Variable_name: innodb_log_archive Value: OFF *************************** 69. row *************************** Variable_name: innodb_log_buffer_size Value: 33554432 *************************** 70. row *************************** Variable_name: innodb_log_file_size Value: 1073741824 *************************** 71. row *************************** Variable_name: innodb_log_files_in_group Value: 2 *************************** 72. row *************************** Variable_name: innodb_log_group_home_dir Value: ./ *************************** 73. row *************************** Variable_name: innodb_max_dirty_pages_pct Value: 90 *************************** 74. row *************************** Variable_name: innodb_max_purge_lag Value: 0 *************************** 75. row *************************** Variable_name: innodb_mirrored_log_groups Value: 1 *************************** 76. row *************************** Variable_name: innodb_open_files Value: 300 *************************** 77. row *************************** Variable_name: innodb_table_locks Value: ON *************************** 78. row *************************** Variable_name: innodb_thread_concurrency Value: 8 *************************** 79. row *************************** Variable_name: interactive_timeout Value: 28800 *************************** 80. row *************************** Variable_name: join_buffer_size Value: 8384512 *************************** 81. row *************************** Variable_name: key_buffer_size Value: 1073741824 *************************** 82. row *************************** Variable_name: key_cache_age_threshold Value: 300 *************************** 83. row *************************** Variable_name: key_cache_block_size Value: 1024 *************************** 84. row *************************** Variable_name: key_cache_division_limit Value: 100 *************************** 85. row *************************** Variable_name: language Value: /usr/share/mysql/english/ *************************** 86. row *************************** Variable_name: large_files_support Value: ON *************************** 87. row *************************** Variable_name: license Value: GPL *************************** 88. row *************************** Variable_name: local_infile Value: ON *************************** 89. row *************************** Variable_name: locked_in_memory Value: OFF *************************** 90. row *************************** Variable_name: log Value: OFF *************************** 91. row *************************** Variable_name: log_bin Value: ON *************************** 92. row *************************** Variable_name: log_error Value: /var/log/mysql/mysqld.err *************************** 93. row *************************** Variable_name: log_slave_updates Value: OFF *************************** 94. row *************************** Variable_name: log_slow_queries Value: ON *************************** 95. row *************************** Variable_name: log_update Value: OFF *************************** 96. row *************************** Variable_name: log_warnings Value: 1 *************************** 97. row *************************** Variable_name: long_query_time Value: 10 *************************** 98. row *************************** Variable_name: low_priority_updates Value: OFF *************************** 99. row *************************** Variable_name: lower_case_file_system Value: OFF *************************** 100. row *************************** Variable_name: lower_case_table_names Value: 0 *************************** 101. row *************************** Variable_name: max_allowed_packet Value: 1047552 *************************** 102. row *************************** Variable_name: max_binlog_cache_size Value: 18446744073709551615 *************************** 103. row *************************** Variable_name: max_binlog_size Value: 1073741824 *************************** 104. row *************************** Variable_name: max_connect_errors Value: 10 *************************** 105. row *************************** Variable_name: max_connections Value: 256 *************************** 106. row *************************** Variable_name: max_delayed_threads Value: 20 *************************** 107. row *************************** Variable_name: max_error_count Value: 64 *************************** 108. row *************************** Variable_name: max_heap_table_size Value: 16777216 *************************** 109. row *************************** Variable_name: max_insert_delayed_threads Value: 20 *************************** 110. row *************************** Variable_name: max_join_size Value: 18446744073709551615 *************************** 111. row *************************** Variable_name: max_length_for_sort_data Value: 1024 *************************** 112. row *************************** Variable_name: max_relay_log_size Value: 0 *************************** 113. row *************************** Variable_name: max_seeks_for_key Value: 18446744073709551615 *************************** 114. row *************************** Variable_name: max_sort_length Value: 1024 *************************** 115. row *************************** Variable_name: max_tmp_tables Value: 32 *************************** 116. row *************************** Variable_name: max_user_connections Value: 0 *************************** 117. row *************************** Variable_name: max_write_lock_count Value: 18446744073709551615 *************************** 118. row *************************** Variable_name: myisam_data_pointer_size Value: 6 *************************** 119. row *************************** Variable_name: myisam_max_extra_sort_file_size Value: 2147483648 *************************** 120. row *************************** Variable_name: myisam_max_sort_file_size Value: 9223372036854775807 *************************** 121. row *************************** Variable_name: myisam_recover_options Value: OFF *************************** 122. row *************************** Variable_name: myisam_repair_threads Value: 1 *************************** 123. row *************************** Variable_name: myisam_sort_buffer_size Value: 8388608 *************************** 124. row *************************** Variable_name: net_buffer_length Value: 65536 *************************** 125. row *************************** Variable_name: net_read_timeout Value: 30 *************************** 126. row *************************** Variable_name: net_retry_count Value: 10 *************************** 127. row *************************** Variable_name: net_write_timeout Value: 60 *************************** 128. row *************************** Variable_name: new Value: OFF *************************** 129. row *************************** Variable_name: old_passwords Value: OFF *************************** 130. row *************************** Variable_name: open_files_limit Value: 3378 *************************** 131. row *************************** Variable_name: pid_file Value: /var/run/mysqld/mysqld.pid *************************** 132. row *************************** Variable_name: port Value: 3306 *************************** 133. row *************************** Variable_name: preload_buffer_size Value: 32768 *************************** 134. row *************************** Variable_name: protocol_version Value: 10 *************************** 135. row *************************** Variable_name: query_alloc_block_size Value: 8192 *************************** 136. row *************************** Variable_name: query_cache_limit Value: 1048576 *************************** 137. row *************************** Variable_name: query_cache_min_res_unit Value: 4096 *************************** 138. row *************************** Variable_name: query_cache_size Value: 67108864 *************************** 139. row *************************** Variable_name: query_cache_type Value: ON *************************** 140. row *************************** Variable_name: query_cache_wlock_invalidate Value: OFF *************************** 141. row *************************** Variable_name: query_prealloc_size Value: 8192 *************************** 142. row *************************** Variable_name: range_alloc_block_size Value: 2048 *************************** 143. row *************************** Variable_name: read_buffer_size Value: 4190208 *************************** 144. row *************************** Variable_name: read_only Value: OFF *************************** 145. row *************************** Variable_name: read_rnd_buffer_size Value: 1044480 *************************** 146. row *************************** Variable_name: relay_log_purge Value: ON *************************** 147. row *************************** Variable_name: relay_log_space_limit Value: 0 *************************** 148. row *************************** Variable_name: rpl_recovery_rank Value: 0 *************************** 149. row *************************** Variable_name: secure_auth Value: OFF *************************** 150. row *************************** Variable_name: server_id Value: 1 *************************** 151. row *************************** Variable_name: skip_external_locking Value: ON *************************** 152. row *************************** Variable_name: skip_networking Value: OFF *************************** 153. row *************************** Variable_name: skip_show_database Value: OFF *************************** 154. row *************************** Variable_name: slave_net_timeout Value: 3600 *************************** 155. row *************************** Variable_name: slave_transaction_retries Value: 0 *************************** 156. row *************************** Variable_name: slow_launch_time Value: 2 *************************** 157. row *************************** Variable_name: socket Value: /var/run/mysqld/mysqld.sock *************************** 158. row *************************** Variable_name: sort_buffer_size Value: 8388600 *************************** 159. row *************************** Variable_name: sql_mode Value: *************************** 160. row *************************** Variable_name: storage_engine Value: MyISAM *************************** 161. row *************************** Variable_name: sql_notes Value: ON *************************** 162. row *************************** Variable_name: sql_warnings Value: ON *************************** 163. row *************************** Variable_name: sync_binlog Value: 0 *************************** 164. row *************************** Variable_name: sync_replication Value: 0 *************************** 165. row *************************** Variable_name: sync_replication_slave_id Value: 0 *************************** 166. row *************************** Variable_name: sync_replication_timeout Value: 0 *************************** 167. row *************************** Variable_name: sync_frm Value: ON *************************** 168. row *************************** Variable_name: system_time_zone Value: PDT *************************** 169. row *************************** Variable_name: table_cache Value: 1556 *************************** 170. row *************************** Variable_name: table_type Value: MyISAM *************************** 171. row *************************** Variable_name: thread_cache_size Value: 0 *************************** 172. row *************************** Variable_name: thread_stack Value: 196608 *************************** 173. row *************************** Variable_name: time_format Value: %H:%i:%s *************************** 174. row *************************** Variable_name: time_zone Value: SYSTEM *************************** 175. row *************************** Variable_name: tmp_table_size Value: 67108864 *************************** 176. row *************************** Variable_name: tmpdir Value: /tmp/ *************************** 177. row *************************** Variable_name: transaction_alloc_block_size Value: 8192 *************************** 178. row *************************** Variable_name: transaction_prealloc_size Value: 4096 *************************** 179. row *************************** Variable_name: tx_isolation Value: REPEATABLE-READ *************************** 180. row *************************** Variable_name: version Value: 4.1.14-log *************************** 181. row *************************** Variable_name: version_comment Value: Gentoo Linux mysql-4.1.14 *************************** 182. row *************************** Variable_name: version_compile_machine Value: x86_64 *************************** 183. row *************************** Variable_name: version_compile_os Value: pc-linux-gnu *************************** 184. row *************************** Variable_name: wait_timeout Value: 28800 mysql> show status\G *************************** 1. row *************************** Variable_name: Aborted_clients Value: 30 *************************** 2. row *************************** Variable_name: Aborted_connects Value: 0 *************************** 3. row *************************** Variable_name: Binlog_cache_disk_use Value: 0 *************************** 4. row *************************** Variable_name: Binlog_cache_use Value: 20893 *************************** 5. row *************************** Variable_name: Bytes_received Value: 632640648 *************************** 6. row *************************** Variable_name: Bytes_sent Value: 776354514 *************************** 7. row *************************** Variable_name: Com_admin_commands Value: 786752 *************************** 8. row *************************** Variable_name: Com_alter_db Value: 0 *************************** 9. row *************************** Variable_name: Com_alter_table Value: 0 *************************** 10. row *************************** Variable_name: Com_analyze Value: 0 *************************** 11. row *************************** Variable_name: Com_backup_table Value: 0 *************************** 12. row *************************** Variable_name: Com_begin Value: 666 *************************** 13. row *************************** Variable_name: Com_change_db Value: 0 *************************** 14. row *************************** Variable_name: Com_change_master Value: 0 *************************** 15. row *************************** Variable_name: Com_check Value: 0 *************************** 16. row *************************** Variable_name: Com_checksum Value: 0 *************************** 17. row *************************** Variable_name: Com_commit Value: 7919 *************************** 18. row *************************** Variable_name: Com_create_db Value: 0 *************************** 19. row *************************** Variable_name: Com_create_function Value: 0 *************************** 20. row *************************** Variable_name: Com_create_index Value: 0 *************************** 21. row *************************** Variable_name: Com_create_table Value: 2 *************************** 22. row *************************** Variable_name: Com_dealloc_sql Value: 0 *************************** 23. row *************************** Variable_name: Com_delete Value: 228 *************************** 24. row *************************** Variable_name: Com_delete_multi Value: 11 *************************** 25. row *************************** Variable_name: Com_do Value: 0 *************************** 26. row *************************** Variable_name: Com_drop_db Value: 0 *************************** 27. row *************************** Variable_name: Com_drop_function Value: 0 *************************** 28. row *************************** Variable_name: Com_drop_index Value: 0 *************************** 29. row *************************** Variable_name: Com_drop_table Value: 1 *************************** 30. row *************************** Variable_name: Com_drop_user Value: 0 *************************** 31. row *************************** Variable_name: Com_execute_sql Value: 0 *************************** 32. row *************************** Variable_name: Com_flush Value: 0 *************************** 33. row *************************** Variable_name: Com_grant Value: 0 *************************** 34. row *************************** Variable_name: Com_ha_close Value: 0 *************************** 35. row *************************** Variable_name: Com_ha_open Value: 0 *************************** 36. row *************************** Variable_name: Com_ha_read Value: 0 *************************** 37. row *************************** Variable_name: Com_help Value: 0 *************************** 38. row *************************** Variable_name: Com_insert Value: 460287 *************************** 39. row *************************** Variable_name: Com_insert_select Value: 6 *************************** 40. row *************************** Variable_name: Com_kill Value: 0 *************************** 41. row *************************** Variable_name: Com_load Value: 0 *************************** 42. row *************************** Variable_name: Com_load_master_data Value: 0 *************************** 43. row *************************** Variable_name: Com_load_master_table Value: 0 *************************** 44. row *************************** Variable_name: Com_lock_tables Value: 0 *************************** 45. row *************************** Variable_name: Com_optimize Value: 0 *************************** 46. row *************************** Variable_name: Com_preload_keys Value: 0 *************************** 47. row *************************** Variable_name: Com_prepare_sql Value: 0 *************************** 48. row *************************** Variable_name: Com_purge Value: 0 *************************** 49. row *************************** Variable_name: Com_purge_before_date Value: 0 *************************** 50. row *************************** Variable_name: Com_rename_table Value: 0 *************************** 51. row *************************** Variable_name: Com_repair Value: 0 *************************** 52. row *************************** Variable_name: Com_replace Value: 0 *************************** 53. row *************************** Variable_name: Com_replace_select Value: 0 *************************** 54. row *************************** Variable_name: Com_reset Value: 0 *************************** 55. row *************************** Variable_name: Com_restore_table Value: 0 *************************** 56. row *************************** Variable_name: Com_revoke Value: 0 *************************** 57. row *************************** Variable_name: Com_revoke_all Value: 0 *************************** 58. row *************************** Variable_name: Com_rollback Value: 0 *************************** 59. row *************************** Variable_name: Com_savepoint Value: 0 *************************** 60. row *************************** Variable_name: Com_select Value: 4541968 *************************** 61. row *************************** Variable_name: Com_set_option Value: 41761 *************************** 62. row *************************** Variable_name: Com_show_binlog_events Value: 0 *************************** 63. row *************************** Variable_name: Com_show_binlogs Value: 0 *************************** 64. row *************************** Variable_name: Com_show_charsets Value: 0 *************************** 65. row *************************** Variable_name: Com_show_collations Value: 0 *************************** 66. row *************************** Variable_name: Com_show_column_types Value: 0 *************************** 67. row *************************** Variable_name: Com_show_create_db Value: 0 *************************** 68. row *************************** Variable_name: Com_show_create_table Value: 3 *************************** 69. row *************************** Variable_name: Com_show_databases Value: 6 *************************** 70. row *************************** Variable_name: Com_show_errors Value: 0 *************************** 71. row *************************** Variable_name: Com_show_fields Value: 604 *************************** 72. row *************************** Variable_name: Com_show_grants Value: 0 *************************** 73. row *************************** Variable_name: Com_show_innodb_status Value: 0 *************************** 74. row *************************** Variable_name: Com_show_keys Value: 0 *************************** 75. row *************************** Variable_name: Com_show_logs Value: 0 *************************** 76. row *************************** Variable_name: Com_show_master_status Value: 0 *************************** 77. row *************************** Variable_name: Com_show_new_master Value: 0 *************************** 78. row *************************** Variable_name: Com_show_open_tables Value: 0 *************************** 79. row *************************** Variable_name: Com_show_privileges Value: 0 *************************** 80. row *************************** Variable_name: Com_show_processlist Value: 6 *************************** 81. row *************************** Variable_name: Com_show_slave_hosts Value: 0 *************************** 82. row *************************** Variable_name: Com_show_slave_status Value: 0 *************************** 83. row *************************** Variable_name: Com_show_status Value: 32 *************************** 84. row *************************** Variable_name: Com_show_storage_engines Value: 0 *************************** 85. row *************************** Variable_name: Com_show_tables Value: 7 *************************** 86. row *************************** Variable_name: Com_show_variables Value: 2 *************************** 87. row *************************** Variable_name: Com_show_warnings Value: 0 *************************** 88. row *************************** Variable_name: Com_slave_start Value: 0 *************************** 89. row *************************** Variable_name: Com_slave_stop Value: 0 *************************** 90. row *************************** Variable_name: Com_stmt_prepare Value: 0 *************************** 91. row *************************** Variable_name: Com_stmt_execute Value: 0 *************************** 92. row *************************** Variable_name: Com_stmt_send_long_data Value: 0 *************************** 93. row *************************** Variable_name: Com_stmt_reset Value: 0 *************************** 94. row *************************** Variable_name: Com_stmt_close Value: 0 *************************** 95. row *************************** Variable_name: Com_truncate Value: 0 *************************** 96. row *************************** Variable_name: Com_unlock_tables Value: 0 *************************** 97. row *************************** Variable_name: Com_update Value: 4311293 *************************** 98. row *************************** Variable_name: Com_update_multi Value: 0 *************************** 99. row *************************** Variable_name: Connections Value: 415 *************************** 100. row *************************** Variable_name: Created_tmp_disk_tables Value: 614 *************************** 101. row *************************** Variable_name: Created_tmp_files Value: 6 *************************** 102. row *************************** Variable_name: Created_tmp_tables Value: 5261 *************************** 103. row *************************** Variable_name: Delayed_errors Value: 0 *************************** 104. row *************************** Variable_name: Delayed_insert_threads Value: 0 *************************** 105. row *************************** Variable_name: Delayed_writes Value: 0 *************************** 106. row *************************** Variable_name: Flush_commands Value: 1 *************************** 107. row *************************** Variable_name: Handler_commit Value: 28597 *************************** 108. row *************************** Variable_name: Handler_delete Value: 10087 *************************** 109. row *************************** Variable_name: Handler_discover Value: 0 *************************** 110. row *************************** Variable_name: Handler_read_first Value: 593 *************************** 111. row *************************** Variable_name: Handler_read_key Value: 45269361 *************************** 112. row *************************** Variable_name: Handler_read_next Value: 130901408 *************************** 113. row *************************** Variable_name: Handler_read_prev Value: 43015 *************************** 114. row *************************** Variable_name: Handler_read_rnd Value: 50337 *************************** 115. row *************************** Variable_name: Handler_read_rnd_next Value: 118701679 *************************** 116. row *************************** Variable_name: Handler_rollback Value: 267 *************************** 117. row *************************** Variable_name: Handler_update Value: 17190622 *************************** 118. row *************************** Variable_name: Handler_write Value: 6623420 *************************** 119. row *************************** Variable_name: Key_blocks_not_flushed Value: 0 *************************** 120. row *************************** Variable_name: Key_blocks_unused Value: 711735 *************************** 121. row *************************** Variable_name: Key_blocks_used Value: 145633 *************************** 122. row *************************** Variable_name: Key_read_requests Value: 14216555 *************************** 123. row *************************** Variable_name: Key_reads Value: 149892 *************************** 124. row *************************** Variable_name: Key_write_requests Value: 2513802 *************************** 125. row *************************** Variable_name: Key_writes Value: 1306167 *************************** 126. row *************************** Variable_name: Max_used_connections Value: 118 *************************** 127. row *************************** Variable_name: Not_flushed_delayed_rows Value: 0 *************************** 128. row *************************** Variable_name: Open_files Value: 289 *************************** 129. row *************************** Variable_name: Open_streams Value: 0 *************************** 130. row *************************** Variable_name: Open_tables Value: 442 *************************** 131. row *************************** Variable_name: Opened_tables Value: 456 *************************** 132. row *************************** Variable_name: Qcache_free_blocks Value: 1652 *************************** 133. row *************************** Variable_name: Qcache_free_memory Value: 63645672 *************************** 134. row *************************** Variable_name: Qcache_hits Value: 128571 *************************** 135. row *************************** Variable_name: Qcache_inserts Value: 4450929 *************************** 136. row *************************** Variable_name: Qcache_lowmem_prunes Value: 0 *************************** 137. row *************************** Variable_name: Qcache_not_cached Value: 91040 *************************** 138. row *************************** Variable_name: Qcache_queries_in_cache Value: 2680 *************************** 139. row *************************** Variable_name: Qcache_total_blocks Value: 7053 *************************** 140. row *************************** Variable_name: Questions Value: 9493632 *************************** 141. row *************************** Variable_name: Rpl_status Value: NULL *************************** 142. row *************************** Variable_name: Select_full_join Value: 66 *************************** 143. row *************************** Variable_name: Select_full_range_join Value: 0 *************************** 144. row *************************** Variable_name: Select_range Value: 855 *************************** 145. row *************************** Variable_name: Select_range_check Value: 0 *************************** 146. row *************************** Variable_name: Select_scan Value: 1213 *************************** 147. row *************************** Variable_name: Slave_open_temp_tables Value: 0 *************************** 148. row *************************** Variable_name: Slave_running Value: OFF *************************** 149. row *************************** Variable_name: Slave_retried_transactions Value: 0 *************************** 150. row *************************** Variable_name: Slow_launch_threads Value: 0 *************************** 151. row *************************** Variable_name: Slow_queries Value: 24 *************************** 152. row *************************** Variable_name: Sort_merge_passes Value: 0 *************************** 153. row *************************** Variable_name: Sort_range Value: 161 *************************** 154. row *************************** Variable_name: Sort_rows Value: 23775 *************************** 155. row *************************** Variable_name: Sort_scan Value: 5205 *************************** 156. row *************************** Variable_name: Ssl_accept_renegotiates Value: 0 *************************** 157. row *************************** Variable_name: Ssl_accepts Value: 0 *************************** 158. row *************************** Variable_name: Ssl_callback_cache_hits Value: 0 *************************** 159. row *************************** Variable_name: Ssl_cipher Value: *************************** 160. row *************************** Variable_name: Ssl_cipher_list Value: *************************** 161. row *************************** Variable_name: Ssl_client_connects Value: 0 *************************** 162. row *************************** Variable_name: Ssl_connect_renegotiates Value: 0 *************************** 163. row *************************** Variable_name: Ssl_ctx_verify_depth Value: 0 *************************** 164. row *************************** Variable_name: Ssl_ctx_verify_mode Value: 0 *************************** 165. row *************************** Variable_name: Ssl_default_timeout Value: 0 *************************** 166. row *************************** Variable_name: Ssl_finished_accepts Value: 0 *************************** 167. row *************************** Variable_name: Ssl_finished_connects Value: 0 *************************** 168. row *************************** Variable_name: Ssl_session_cache_hits Value: 0 *************************** 169. row *************************** Variable_name: Ssl_session_cache_misses Value: 0 *************************** 170. row *************************** Variable_name: Ssl_session_cache_mode Value: NONE *************************** 171. row *************************** Variable_name: Ssl_session_cache_overflows Value: 0 *************************** 172. row *************************** Variable_name: Ssl_session_cache_size Value: 0 *************************** 173. row *************************** Variable_name: Ssl_session_cache_timeouts Value: 0 *************************** 174. row *************************** Variable_name: Ssl_sessions_reused Value: 0 *************************** 175. row *************************** Variable_name: Ssl_used_session_cache_entries Value: 0 *************************** 176. row *************************** Variable_name: Ssl_verify_depth Value: 0 *************************** 177. row *************************** Variable_name: Ssl_verify_mode Value: 0 *************************** 178. row *************************** Variable_name: Ssl_version Value: *************************** 179. row *************************** Variable_name: Table_locks_immediate Value: 8789998 *************************** 180. row *************************** Variable_name: Table_locks_waited Value: 535138 *************************** 181. row *************************** Variable_name: Threads_cached Value: 0 *************************** 182. row *************************** Variable_name: Threads_connected Value: 113 *************************** 183. row *************************** Variable_name: Threads_created Value: 414 *************************** 184. row *************************** Variable_name: Threads_running Value: 19 *************************** 185. row *************************** Variable_name: Uptime Value: 1946 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
I forgot to include the output of show variables and show status in the
last message :(
- Re: daemon crash when shutting down large databases Gleb Paharenko
- Re: daemon crash when shutting down large databases David Sparks
- Re: daemon crash when shutting down large database... David Sparks
- Re: daemon crash when shutting down large database... Gleb Paharenko
- Re: daemon crash when shutting down large databases David Sparks
- Re: daemon crash when shutting down large databases Heikki Tuuri