API tools faq
paste
Guest User

Untitled

a guest
Sep 23rd, 2010
220
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.15 KB | None | 0 0
raw download clone embed print report
  1. mysql> SELECT CONCAT(ROUND(SUM(index_length)/(1024*1024*1024), 2), ' GB') AS 'Total Index Size' FROM information_schema.TABLES WHERE table_schema LIKE 'podmoskovie_info';
  2. +------------------+
  3. | Total Index Size |
  4. +------------------+
  5. | 0.01 GB |
  6. +------------------+
  7. 1 row in set (0.03 sec)
  8.  
  9. mysql> SELECT CONCAT(ROUND(SUM(data_length)/(1024*1024*1024), 2), ' GB') AS 'Total Data Size'
  10. -> FROM information_schema.TABLES
  11. -> WHERE table_schema LIKE 'podmoskovie_info';
  12. +-----------------+
  13. | Total Data Size |
  14. +-----------------+
  15. | 0.05 GB |
  16. +-----------------+
  17. 1 row in set (0.01 sec)
  18.  
  19. mysql> SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', CONCAT(ROUND(table_rows/1000000,2),'M') AS 'Number of Rows',
  20. -> CONCAT(ROUND(data_length/(1024*1024*1024),2),'G') AS 'Data Size',
  21. -> CONCAT(ROUND(index_length/(1024*1024*1024),2),'G') AS 'Index Size' ,
  22. -> CONCAT(ROUND((data_length+index_length)/(1024*1024*1024),2),'G') AS'Total'
  23. -> FROM information_schema.TABLES
  24. -> WHERE table_schema LIKE 'podmoskovie_info';
  25. +-------------------------------------------------------+----------------+-----------+------------+-------+
  26. | Table Name | Number of Rows | Data Size | Index Size | Total |
  27. +-------------------------------------------------------+----------------+-----------+------------+-------+
  28. | podmoskovie_info.access | 0.00M | 0.00G | 0.00G | 0.00G |
  29. | podmoskovie_info.actions | 0.00M | 0.00G | 0.00G | 0.00G |
  30. | podmoskovie_info.actions_aid | 0.00M | 0.00G | 0.00G | 0.00G |
  31. | podmoskovie_info.ad_clicks | 0.00M | 0.00G | 0.00G | 0.00G |
  32. | podmoskovie_info.ad_hosts | 0.00M | 0.00G | 0.00G | 0.00G |
  33. | podmoskovie_info.ad_owners | 0.00M | 0.00G | 0.00G | 0.00G |
  34. | podmoskovie_info.ad_permissions | 0.00M | 0.00G | 0.00G | 0.00G |
  35. | podmoskovie_info.ad_statistics | 0.00M | 0.00G | 0.00G | 0.00G |
  36. | podmoskovie_info.ads | 0.00M | 0.00G | 0.00G | 0.00G |
  37. | podmoskovie_info.authmap | 0.00M | 0.00G | 0.00G | 0.00G |
  38. | podmoskovie_info.batch | 0.00M | 0.00G | 0.00G | 0.00G |
  39. | podmoskovie_info.blocks | 0.00M | 0.00G | 0.00G | 0.00G |
  40. | podmoskovie_info.blocks_roles | 0.00M | 0.00G | 0.00G | 0.00G |
  41. | podmoskovie_info.boxes | 0.00M | 0.00G | 0.00G | 0.00G |
  42. | podmoskovie_info.cache | 0.00M | 0.00G | 0.00G | 0.00G |
  43. | podmoskovie_info.cache_block | 0.00M | 0.00G | 0.00G | 0.00G |
  44. | podmoskovie_info.cache_content | 0.00M | 0.00G | 0.00G | 0.00G |
  45. | podmoskovie_info.cache_filter | 0.00M | 0.00G | 0.00G | 0.00G |
  46. | podmoskovie_info.cache_form | 0.00M | 0.00G | 0.00G | 0.00G |
  47. | podmoskovie_info.cache_location | 0.00M | 0.00G | 0.00G | 0.00G |
  48. | podmoskovie_info.cache_menu | 0.00M | 0.01G | 0.00G | 0.01G |
  49. | podmoskovie_info.cache_nodewords | 0.00M | 0.00G | 0.00G | 0.00G |
  50. | podmoskovie_info.cache_page | 0.00M | 0.00G | 0.00G | 0.00G |
  51. | podmoskovie_info.cache_update | 0.00M | 0.00G | 0.00G | 0.00G |
  52. | podmoskovie_info.cache_views | 0.00M | 0.00G | 0.00G | 0.00G |
  53. | podmoskovie_info.cache_views_data | 0.00M | 0.00G | 0.00G | 0.00G |
  54. | podmoskovie_info.comments | 0.00M | 0.00G | 0.00G | 0.00G |
  55. | podmoskovie_info.content_field_accommodation | 0.00M | 0.00G | 0.00G | 0.00G |
  56. | podmoskovie_info.content_field_animals | 0.00M | 0.00G | 0.00G | 0.00G |
  57. | podmoskovie_info.content_field_area | 0.00M | 0.00G | 0.00G | 0.00G |
  58. | podmoskovie_info.content_field_audience | 0.00M | 0.00G | 0.00G | 0.00G |
  59. | podmoskovie_info.content_field_child_infrastructure | 0.00M | 0.00G | 0.00G | 0.00G |
  60. | podmoskovie_info.content_field_corporate_capacity | 0.00M | 0.00G | 0.00G | 0.00G |
  61. | podmoskovie_info.content_field_corporate_one_day | 0.00M | 0.00G | 0.00G | 0.00G |
  62. | podmoskovie_info.content_field_cottage_capacity | 0.00M | 0.00G | 0.00G | 0.00G |
  63. | podmoskovie_info.content_field_cottage_infrastructure | 0.00M | 0.00G | 0.00G | 0.00G |
  64. | podmoskovie_info.content_field_easy_reach | 0.00M | 0.00G | 0.00G | 0.00G |
  65. | podmoskovie_info.content_field_excursions | 0.00M | 0.00G | 0.00G | 0.00G |
  66. | podmoskovie_info.content_field_grade | 0.00M | 0.00G | 0.00G | 0.00G |
  67. | podmoskovie_info.content_field_internet | 0.00M | 0.00G | 0.00G | 0.00G |
  68. | podmoskovie_info.content_field_meals | 0.00M | 0.00G | 0.00G | 0.00G |
  69. | podmoskovie_info.content_field_medical_infrastructure | 0.00M | 0.00G | 0.00G | 0.00G |
  70. | podmoskovie_info.content_field_medical_programs | 0.00M | 0.00G | 0.00G | 0.00G |
  71. | podmoskovie_info.content_field_object | 0.00M | 0.00G | 0.00G | 0.00G |
  72. | podmoskovie_info.content_field_openair | 0.00M | 0.00G | 0.00G | 0.00G |
  73. | podmoskovie_info.content_field_optpic | 0.00M | 0.00G | 0.00G | 0.00G |
  74. | podmoskovie_info.content_field_orientation | 0.00M | 0.00G | 0.00G | 0.00G |
  75. | podmoskovie_info.content_field_pic | 0.00M | 0.00G | 0.00G | 0.00G |
  76. | podmoskovie_info.content_field_pool | 0.00M | 0.00G | 0.00G | 0.00G |
  77. | podmoskovie_info.content_field_price | 0.00M | 0.00G | 0.00G | 0.00G |
  78. | podmoskovie_info.content_field_relax | 0.00M | 0.00G | 0.00G | 0.00G |
  79. | podmoskovie_info.content_field_rent | 0.00M | 0.00G | 0.00G | 0.00G |
  80. | podmoskovie_info.content_field_room_infrastructure | 0.00M | 0.00G | 0.00G | 0.00G |
  81. | podmoskovie_info.content_field_sports | 0.00M | 0.00G | 0.00G | 0.00G |
  82. | podmoskovie_info.content_field_transit_time | 0.00M | 0.00G | 0.00G | 0.00G |
  83. | podmoskovie_info.content_field_treatment | 0.00M | 0.00G | 0.00G | 0.00G |
  84. | podmoskovie_info.content_field_type | 0.00M | 0.00G | 0.00G | 0.00G |
  85. | podmoskovie_info.content_group | 0.00M | 0.00G | 0.00G | 0.00G |
  86. | podmoskovie_info.content_group_fields | 0.00M | 0.00G | 0.00G | 0.00G |
  87. | podmoskovie_info.content_node_field | 0.00M | 0.00G | 0.00G | 0.00G |
  88. | podmoskovie_info.content_node_field_instance | 0.00M | 0.00G | 0.00G | 0.00G |
  89. | podmoskovie_info.content_type_miniportal | 0.00M | 0.00G | 0.00G | 0.00G |
  90. | podmoskovie_info.content_type_news | 0.00M | 0.00G | 0.00G | 0.00G |
  91. | podmoskovie_info.content_type_object | 0.00M | 0.00G | 0.00G | 0.00G |
  92. | podmoskovie_info.content_type_object_desc | 0.00M | 0.00G | 0.00G | 0.00G |
  93. | podmoskovie_info.content_type_object_photos | 0.00M | 0.00G | 0.00G | 0.00G |
  94. | podmoskovie_info.content_type_object_type_descr | 0.00M | 0.00G | 0.00G | 0.00G |
  95. | podmoskovie_info.content_type_price | 0.00M | 0.00G | 0.00G | 0.00G |
  96. | podmoskovie_info.content_type_promo | 0.00M | 0.00G | 0.00G | 0.00G |
  97. | podmoskovie_info.date_format_locale | 0.00M | 0.00G | 0.00G | 0.00G |
  98. | podmoskovie_info.date_format_types | 0.00M | 0.00G | 0.00G | 0.00G |
  99. | podmoskovie_info.date_formats | 0.00M | 0.00G | 0.00G | 0.00G |
  100. | podmoskovie_info.devel_queries | 0.00M | 0.00G | 0.00G | 0.00G |
  101. | podmoskovie_info.devel_times | 0.00M | 0.00G | 0.00G | 0.00G |
  102. | podmoskovie_info.expert_answer | 0.00M | 0.00G | 0.00G | 0.00G |
  103. | podmoskovie_info.expert_branch | 0.00M | 0.00G | 0.00G | 0.00G |
  104. | podmoskovie_info.expert_node | 0.00M | 0.00G | 0.00G | 0.00G |
  105. | podmoskovie_info.expert_question | 0.00M | 0.00G | 0.00G | 0.00G |
  106. | podmoskovie_info.fckeditor_role | 0.00M | 0.00G | 0.00G | 0.00G |
  107. | podmoskovie_info.fckeditor_settings | 0.00M | 0.00G | 0.00G | 0.00G |
  108. | podmoskovie_info.files | 0.00M | 0.00G | 0.00G | 0.00G |
  109. | podmoskovie_info.filter_formats | 0.00M | 0.00G | 0.00G | 0.00G |
  110. | podmoskovie_info.filters | 0.00M | 0.00G | 0.00G | 0.00G |
  111. | podmoskovie_info.flood | 0.00M | 0.00G | 0.00G | 0.00G |
  112. | podmoskovie_info.history | 0.00M | 0.00G | 0.00G | 0.00G |
  113. | podmoskovie_info.imagecache_action | 0.00M | 0.00G | 0.00G | 0.00G |
  114. | podmoskovie_info.imagecache_preset | 0.00M | 0.00G | 0.00G | 0.00G |
  115. | podmoskovie_info.languages | 0.00M | 0.00G | 0.00G | 0.00G |
  116. | podmoskovie_info.locales_source | 0.00M | 0.00G | 0.00G | 0.00G |
  117. | podmoskovie_info.locales_target | 0.00M | 0.00G | 0.00G | 0.00G |
  118. | podmoskovie_info.location | 0.00M | 0.00G | 0.00G | 0.00G |
  119. | podmoskovie_info.location_instance | 0.00M | 0.00G | 0.00G | 0.00G |
  120. | podmoskovie_info.menu_custom | 0.00M | 0.00G | 0.00G | 0.00G |
  121. | podmoskovie_info.menu_links | 0.00M | 0.00G | 0.00G | 0.00G |
  122. | podmoskovie_info.menu_router | 0.00M | 0.00G | 0.00G | 0.00G |
  123. | podmoskovie_info.node | 0.00M | 0.00G | 0.00G | 0.00G |
  124. | podmoskovie_info.node_access | 0.00M | 0.00G | 0.00G | 0.00G |
  125. | podmoskovie_info.node_comment_statistics | 0.00M | 0.00G | 0.00G | 0.00G |
  126. | podmoskovie_info.node_counter | 0.00M | 0.00G | 0.00G | 0.00G |
  127. | podmoskovie_info.node_revisions | 0.00M | 0.00G | 0.00G | 0.00G |
  128. | podmoskovie_info.node_type | 0.00M | 0.00G | 0.00G | 0.00G |
  129. | podmoskovie_info.nodequeue_nodes | 0.00M | 0.00G | 0.00G | 0.00G |
  130. | podmoskovie_info.nodequeue_queue | 0.00M | 0.00G | 0.00G | 0.00G |
  131. | podmoskovie_info.nodequeue_roles | 0.00M | 0.00G | 0.00G | 0.00G |
  132. | podmoskovie_info.nodequeue_subqueue | 0.00M | 0.00G | 0.00G | 0.00G |
  133. | podmoskovie_info.nodequeue_types | 0.00M | 0.00G | 0.00G | 0.00G |
  134. | podmoskovie_info.nodewords | 0.00M | 0.00G | 0.00G | 0.00G |
  135. | podmoskovie_info.nodewords_custom | 0.00M | 0.00G | 0.00G | 0.00G |
  136. | podmoskovie_info.object_features_branch | 0.00M | 0.00G | 0.00G | 0.00G |
  137. | podmoskovie_info.object_features_node | 0.00M | 0.00G | 0.00G | 0.00G |
  138. | podmoskovie_info.page_title | 0.00M | 0.00G | 0.00G | 0.00G |
  139. | podmoskovie_info.page_title_old | 0.00M | 0.00G | 0.00G | 0.00G |
  140. | podmoskovie_info.panels_display | 0.00M | 0.00G | 0.00G | 0.00G |
  141. | podmoskovie_info.panels_node | 0.00M | 0.00G | 0.00G | 0.00G |
  142. | podmoskovie_info.panels_page | 0.00M | 0.00G | 0.00G | 0.00G |
  143. | podmoskovie_info.panels_page_router_store | 0.00M | 0.00G | 0.00G | 0.00G |
  144. | podmoskovie_info.panels_pane | 0.00M | 0.00G | 0.00G | 0.00G |
  145. | podmoskovie_info.path_redirect | 0.00M | 0.00G | 0.00G | 0.00G |
  146. | podmoskovie_info.performance_detail | 0.00M | 0.00G | 0.00G | 0.00G |
  147. | podmoskovie_info.performance_summary | 0.00M | 0.00G | 0.00G | 0.00G |
  148. | podmoskovie_info.permission | 0.00M | 0.00G | 0.00G | 0.00G |
  149. | podmoskovie_info.role | 0.00M | 0.00G | 0.00G | 0.00G |
  150. | podmoskovie_info.semaphore | 0.00M | 0.00G | 0.00G | 0.00G |
  151. | podmoskovie_info.sessions | 0.00M | 0.00G | 0.00G | 0.00G |
  152. | podmoskovie_info.system | 0.00M | 0.00G | 0.00G | 0.00G |
  153. | podmoskovie_info.term_data | 0.00M | 0.00G | 0.00G | 0.00G |
  154. | podmoskovie_info.term_hierarchy | 0.00M | 0.00G | 0.00G | 0.00G |
  155. | podmoskovie_info.term_node | 0.00M | 0.00G | 0.00G | 0.00G |
  156. | podmoskovie_info.term_relation | 0.00M | 0.00G | 0.00G | 0.00G |
  157. | podmoskovie_info.term_synonym | 0.00M | 0.00G | 0.00G | 0.00G |
  158. | podmoskovie_info.url_alias | 0.00M | 0.00G | 0.00G | 0.00G |
  159. | podmoskovie_info.users | 0.00M | 0.00G | 0.00G | 0.00G |
  160. | podmoskovie_info.users_roles | 0.00M | 0.00G | 0.00G | 0.00G |
  161. | podmoskovie_info.variable | 0.00M | 0.00G | 0.00G | 0.00G |
  162. | podmoskovie_info.views_display | 0.00M | 0.00G | 0.00G | 0.00G |
  163. | podmoskovie_info.views_object_cache | 0.00M | 0.00G | 0.00G | 0.00G |
  164. | podmoskovie_info.views_view | 0.00M | 0.00G | 0.00G | 0.00G |
  165. | podmoskovie_info.vocabulary | 0.00M | 0.00G | 0.00G | 0.00G |
  166. | podmoskovie_info.vocabulary_node_types | 0.00M | 0.00G | 0.00G | 0.00G |
  167. | podmoskovie_info.watchdog | 0.00M | 0.03G | 0.00G | 0.03G |
  168. | podmoskovie_info.webform | 0.00M | 0.00G | 0.00G | 0.00G |
  169. | podmoskovie_info.webform_component | 0.00M | 0.00G | 0.00G | 0.00G |
  170. | podmoskovie_info.webform_emails | 0.00M | 0.00G | 0.00G | 0.00G |
  171. | podmoskovie_info.webform_roles | 0.00M | 0.00G | 0.00G | 0.00G |
  172. | podmoskovie_info.webform_submissions | 0.01M | 0.00G | 0.00G | 0.00G |
  173. | podmoskovie_info.webform_submitted_data | 0.03M | 0.00G | 0.00G | 0.00G |
  174. | podmoskovie_info.zipcodes | 0.00M | 0.00G | 0.00G | 0.00G |
  175. +-------------------------------------------------------+----------------+-----------+------------+-------+
  176. 147 rows in set (0.01 sec)
  177.  
  178.  
  179. SHOW VARIABLES:
  180.  
  181. Variable_name Value
  182. auto_increment_increment 1
  183. auto_increment_offset 1
  184. autocommit ON
  185. automatic_sp_privileges ON
  186. back_log 50
  187. basedir /usr/
  188. big_tables OFF
  189. binlog_cache_size 32768
  190. binlog_format STATEMENT
  191. bulk_insert_buffer_size 8388608
  192. character_set_client latin1
  193. character_set_connection latin1
  194. character_set_database utf8
  195. character_set_filesystem binary
  196. character_set_results latin1
  197. character_set_server utf8
  198. character_set_system utf8
  199. character_sets_dir /usr/share/mysql/charsets/
  200. collation_connection latin1_swedish_ci
  201. collation_database utf8_general_ci
  202. collation_server utf8_general_ci
  203. completion_type 0
  204. concurrent_insert 1
  205. connect_timeout 10
  206. datadir /var/lib/mysql/
  207. date_format %Y-%m-%d
  208. datetime_format %Y-%m-%d %H:%i:%s
  209. default_week_format 0
  210. delay_key_write ON
  211. delayed_insert_limit 100
  212. delayed_insert_timeout 300
  213. delayed_queue_size 1000
  214. div_precision_increment 4
  215. engine_condition_pushdown ON
  216. error_count 0
  217. event_scheduler OFF
  218. expire_logs_days 10
  219. flush OFF
  220. flush_time 0
  221. foreign_key_checks ON
  222. ft_boolean_syntax + -><()~*:""&|
  223. ft_max_word_len 84
  224. ft_min_word_len 4
  225. ft_query_expansion_limit 20
  226. ft_stopword_file (built-in)
  227. general_log OFF
  228. general_log_file /var/lib/mysql/zksrv02mos.log
  229. group_concat_max_len 1024
  230. have_community_features YES
  231. have_compress YES
  232. have_crypt YES
  233. have_csv YES
  234. have_dynamic_loading YES
  235. have_geometry YES
  236. have_innodb YES
  237. have_ndbcluster NO
  238. have_openssl DISABLED
  239. have_partitioning YES
  240. have_query_cache YES
  241. have_rtree_keys YES
  242. have_ssl DISABLED
  243. have_symlink YES
  244. hostname zksrv02mos
  245. identity 0
  246. ignore_builtin_innodb OFF
  247. init_connect
  248. init_file
  249. init_slave
  250. innodb_adaptive_hash_index ON
  251. innodb_additional_mem_pool_size 1048576
  252. innodb_autoextend_increment 8
  253. innodb_autoinc_lock_mode 1
  254. innodb_buffer_pool_size 268435456
  255. innodb_checksums ON
  256. innodb_commit_concurrency 0
  257. innodb_concurrency_tickets 500
  258. innodb_data_file_path ibdata1:10M:autoextend
  259. innodb_data_home_dir
  260. innodb_doublewrite ON
  261. innodb_fast_shutdown 1
  262. innodb_file_io_threads 4
  263. innodb_file_per_table ON
  264. innodb_flush_log_at_trx_commit 0
  265. innodb_flush_method O_DIRECT
  266. innodb_force_recovery 0
  267. innodb_lock_wait_timeout 50
  268. innodb_locks_unsafe_for_binlog OFF
  269. innodb_log_buffer_size 1048576
  270. innodb_log_file_size 1073741824
  271. innodb_log_files_in_group 2
  272. innodb_log_group_home_dir ./
  273. innodb_max_dirty_pages_pct 90
  274. innodb_max_purge_lag 0
  275. innodb_mirrored_log_groups 1
  276. innodb_open_files 300
  277. innodb_rollback_on_timeout OFF
  278. innodb_stats_on_metadata ON
  279. innodb_support_xa ON
  280. innodb_sync_spin_loops 20
  281. innodb_table_locks ON
  282. innodb_thread_concurrency 8
  283. innodb_thread_sleep_delay 10000
  284. innodb_use_legacy_cardinality_algorithm ON
  285. insert_id 0
  286. interactive_timeout 28800
  287. join_buffer_size 1048576
  288. keep_files_on_create OFF
  289. key_buffer_size 20971520
  290. key_cache_age_threshold 300
  291. key_cache_block_size 1024
  292. key_cache_division_limit 100
  293. language /usr/share/mysql/english/
  294. large_files_support ON
  295. large_page_size 0
  296. large_pages OFF
  297. last_insert_id 0
  298. lc_time_names en_US
  299. license GPL
  300. local_infile ON
  301. locked_in_memory OFF
  302. log OFF
  303. log_bin OFF
  304. log_bin_trust_function_creators OFF
  305. log_bin_trust_routine_creators OFF
  306. log_error /var/log/mysql/error.log
  307. log_output FILE
  308. log_queries_not_using_indexes ON
  309. log_slave_updates OFF
  310. log_slow_queries ON
  311. log_warnings 1
  312. long_query_time 1.000000
  313. low_priority_updates OFF
  314. lower_case_file_system OFF
  315. lower_case_table_names 0
  316. max_allowed_packet 16777216
  317. max_binlog_cache_size 18446744073709547520
  318. max_binlog_size 104857600
  319. max_connect_errors 10
  320. max_connections 50
  321. max_delayed_threads 20
  322. max_error_count 64
  323. max_heap_table_size 67108864
  324. max_insert_delayed_threads 20
  325. max_join_size 18446744073709551615
  326. max_length_for_sort_data 1024
  327. max_prepared_stmt_count 16382
  328. max_relay_log_size 0
  329. max_seeks_for_key 18446744073709551615
  330. max_sort_length 1024
  331. max_sp_recursion_depth 0
  332. max_tmp_tables 32
  333. max_user_connections 0
  334. max_write_lock_count 18446744073709551615
  335. min_examined_row_limit 0
  336. multi_range_count 256
  337. myisam_data_pointer_size 6
  338. myisam_max_sort_file_size 9223372036853727232
  339. myisam_recover_options BACKUP
  340. myisam_repair_threads 1
  341. myisam_sort_buffer_size 8388608
  342. myisam_stats_method nulls_unequal
  343. myisam_use_mmap OFF
  344. net_buffer_length 16384
  345. net_read_timeout 30
  346. net_retry_count 10
  347. net_write_timeout 60
  348. new OFF
  349. old OFF
  350. old_alter_table OFF
  351. old_passwords OFF
  352. open_files_limit 16444
  353. optimizer_prune_level 1
  354. optimizer_search_depth 62
  355. optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on
  356. pid_file /var/lib/mysql/zksrv02mos.pid
  357. plugin_dir /usr/lib/mysql/plugin
  358. port 3306
  359. preload_buffer_size 32768
  360. profiling OFF
  361. profiling_history_size 15
  362. protocol_version 10
  363. pseudo_thread_id 3272
  364. query_alloc_block_size 8192
  365. query_cache_limit 33554432
  366. query_cache_min_res_unit 4096
  367. query_cache_size 268435456
  368. query_cache_type ON
  369. query_cache_wlock_invalidate OFF
  370. query_prealloc_size 8192
  371. rand_seed1
  372. rand_seed2
  373. range_alloc_block_size 4096
  374. read_buffer_size 204800
  375. read_only OFF
  376. read_rnd_buffer_size 262144
  377. relay_log
  378. relay_log_index
  379. relay_log_info_file relay-log.info
  380. relay_log_purge ON
  381. relay_log_space_limit 0
  382. report_host
  383. report_password
  384. report_port 3306
  385. report_user
  386. rpl_recovery_rank 0
  387. secure_auth OFF
  388. secure_file_priv
  389. server_id 0
  390. skip_external_locking ON
  391. skip_networking OFF
  392. skip_show_database OFF
  393. slave_compressed_protocol OFF
  394. slave_exec_mode STRICT
  395. slave_load_tmpdir /tmp
  396. slave_net_timeout 3600
  397. slave_skip_errors OFF
  398. slave_transaction_retries 10
  399. slow_launch_time 2
  400. slow_query_log ON
  401. slow_query_log_file /var/log/mysql/mysql-slow.log
  402. socket /var/run/mysqld/mysqld.sock
  403. sort_buffer_size 8388608
  404. sql_auto_is_null ON
  405. sql_big_selects ON
  406. sql_big_tables OFF
  407. sql_buffer_result OFF
  408. sql_log_bin ON
  409. sql_log_off OFF
  410. sql_log_update ON
  411. sql_low_priority_updates OFF
  412. sql_max_join_size 18446744073709551615
  413. sql_mode
  414. sql_notes ON
  415. sql_quote_show_create ON
  416. sql_safe_updates OFF
  417. sql_select_limit 18446744073709551615
  418. sql_slave_skip_counter
  419. sql_warnings OFF
  420. ssl_ca
  421. ssl_capath
  422. ssl_cert
  423. ssl_cipher
  424. ssl_key
  425. storage_engine InnoDB
  426. sync_binlog 0
  427. sync_frm ON
  428. system_time_zone MSD
  429. table_definition_cache 256
  430. table_lock_wait_timeout 50
  431. table_open_cache 8192
  432. table_type InnoDB
  433. thread_cache_size 8
  434. thread_handling one-thread-per-connection
  435. thread_stack 196608
  436. time_format %H:%i:%s
  437. time_zone SYSTEM
  438. timed_mutexes OFF
  439. timestamp 1285227747
  440. tmp_table_size 67108864
  441. tmpdir /tmp
  442. transaction_alloc_block_size 8192
  443. transaction_prealloc_size 4096
  444. tx_isolation REPEATABLE-READ
  445. unique_checks ON
  446. updatable_views_with_limit YES
  447. version 5.1.41-3ubuntu12.6-log
  448. version_comment (Ubuntu)
  449. version_compile_machine x86_64
  450. version_compile_os debian-linux-gnu
  451. wait_timeout 28800
  452. warning_count 0
  453.  
  454. my.cnf:
  455.  
  456. #
  457. # The MySQL database server configuration file.
  458. #
  459. # You can copy this to one of:
  460. # - "/etc/mysql/my.cnf" to set global options,
  461. # - "~/.my.cnf" to set user-specific options.
  462. #
  463. # One can use all long options that the program supports.
  464. # Run program with --help to get a list of available options and with
  465. # --print-defaults to see which it would actually understand and use.
  466. #
  467. # For explanations see
  468. # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  469.  
  470. # This will be passed to all mysql clients
  471. # It has been reported that passwords should be enclosed with ticks/quotes
  472. # escpecially if they contain "#" chars...
  473. # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
  474. [client]
  475. port = 3306
  476. socket = /var/run/mysqld/mysqld.sock
  477.  
  478. # Here is entries for some specific programs
  479. # The following values assume you have at least 32M ram
  480.  
  481. # This was formally known as [safe_mysqld]. Both versions are currently parsed.
  482. [mysqld_safe]
  483. socket = /var/run/mysqld/mysqld.sock
  484. nice = 0
  485.  
  486. [mysqld]
  487. #
  488. # * Basic Settings
  489. #
  490.  
  491. #
  492. # * IMPORTANT
  493. # If you make changes to these settings and your system uses apparmor, you may
  494. # also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
  495. #
  496.  
  497. user = mysql
  498. socket = /var/run/mysqld/mysqld.sock
  499. port = 3306
  500. basedir = /usr
  501. datadir = /var/lib/mysql
  502. tmpdir = /tmp
  503. skip-external-locking
  504. #
  505. # Instead of skip-networking the default is now to listen only on
  506. # localhost which is more compatible and is not less secure.
  507. bind-address = 127.0.0.1
  508. #
  509. # * Fine Tuning
  510. #
  511. key_buffer = 20M
  512. max_allowed_packet = 16M
  513. thread_stack = 192K
  514. thread_cache_size = 8
  515. sort_buffer_size = 8M
  516. read_buffer_size = 200K
  517. join_buffer_size = 1M
  518. bulk_insert_buffer_size = 8M
  519. tmp_table_size = 64M
  520. max_heap_table_size = 64M
  521.  
  522. # This replaces the startup script and checks MyISAM tables if needed
  523. # the first time they are touched
  524. myisam-recover = BACKUP
  525. max_connections = 50
  526. table_cache = 8192
  527. #thread_concurrency = 10
  528. #
  529. # * Query Cache Configuration
  530. #
  531. query_cache_limit = 32M
  532. query_cache_size = 256M
  533. query_cache_type = 1
  534. #
  535. # * Logging and Replication
  536. #
  537. # Both location gets rotated by the cronjob.
  538. # Be aware that this log type is a performance killer.
  539. # As of 5.1 you can enable the log at runtime!
  540. #general_log_file = /var/log/mysql/mysql.log
  541. #general_log = 1
  542.  
  543. log_error = /var/log/mysql/error.log
  544.  
  545. # Here you can see queries with especially long duration
  546. log_slow_queries = /var/log/mysql/mysql-slow.log
  547. long_query_time = 1
  548. log-queries-not-using-indexes
  549. #
  550. # The following can be used as easy to replay backup logs or for replication.
  551. # note: if you are setting up a replication slave, see README.Debian about
  552. # other settings you may need to change.
  553. #server-id = 1
  554. #log_bin = /var/log/mysql/mysql-bin.log
  555. expire_logs_days = 10
  556. max_binlog_size = 100M
  557. #binlog_do_db = include_database_name
  558. #binlog_ignore_db = include_database_name
  559. #
  560. # * InnoDB
  561. #
  562. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  563. # Read the manual for more InnoDB related options. There are many!
  564. #
  565. # * Security Features
  566. #
  567. # Read the manual, too, if you want chroot!
  568. # chroot = /var/lib/mysql/
  569. #
  570. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  571. #
  572. # ssl-ca=/etc/mysql/cacert.pem
  573. # ssl-cert=/etc/mysql/server-cert.pem
  574. # ssl-key=/etc/mysql/server-key.pem
  575. default_storage_engine = InnoDB
  576. innodb_buffer_pool_size = 256M
  577. innodb_log_file_size = 1G
  578. innodb_flush_log_at_trx_commit = 0
  579. innodb_flush_method = O_DIRECT
  580. innodb_file_per_table = 1
  581. default_character_set = utf8
  582. collation_server = utf8_general_ci
  583. character_set_server = utf8
  584.  
  585.  
  586.  
  587. [mysqldump]
  588. quick
  589. quote-names
  590. max_allowed_packet = 16M
  591.  
  592. [mysql]
  593. #no-auto-rehash # faster start of mysql but no tab completition
  594.  
  595. [isamchk]
  596. key_buffer = 16M
  597.  
  598. #
  599. # * IMPORTANT: Additional settings that can override those from this file!
  600. # The files must end with '.cnf', otherwise they'll be ignored.
  601. #
  602. !includedir /etc/mysql/conf.d/
  603.  
  604. SHOW STATUS:
  605.  
  606. Variable_name Value
  607. Aborted_clients 0
  608. Aborted_connects 0
  609. Binlog_cache_disk_use 0
  610. Binlog_cache_use 0
  611. Bytes_received 132
  612. Bytes_sent 162
  613. Com_admin_commands 0
  614. Com_assign_to_keycache 0
  615. Com_alter_db 0
  616. Com_alter_db_upgrade 0
  617. Com_alter_event 0
  618. Com_alter_function 0
  619. Com_alter_procedure 0
  620. Com_alter_server 0
  621. Com_alter_table 0
  622. Com_alter_tablespace 0
  623. Com_analyze 0
  624. Com_backup_table 0
  625. Com_begin 0
  626. Com_binlog 0
  627. Com_call_procedure 0
  628. Com_change_db 0
  629. Com_change_master 0
  630. Com_check 0
  631. Com_checksum 0
  632. Com_commit 0
  633. Com_create_db 0
  634. Com_create_event 0
  635. Com_create_function 0
  636. Com_create_index 0
  637. Com_create_procedure 0
  638. Com_create_server 0
  639. Com_create_table 0
  640. Com_create_trigger 0
  641. Com_create_udf 0
  642. Com_create_user 0
  643. Com_create_view 0
  644. Com_dealloc_sql 0
  645. Com_delete 0
  646. Com_delete_multi 0
  647. Com_do 0
  648. Com_drop_db 0
  649. Com_drop_event 0
  650. Com_drop_function 0
  651. Com_drop_index 0
  652. Com_drop_procedure 0
  653. Com_drop_server 0
  654. Com_drop_table 0
  655. Com_drop_trigger 0
  656. Com_drop_user 0
  657. Com_drop_view 0
  658. Com_empty_query 0
  659. Com_execute_sql 0
  660. Com_flush 0
  661. Com_grant 0
  662. Com_ha_close 0
  663. Com_ha_open 0
  664. Com_ha_read 0
  665. Com_help 0
  666. Com_insert 0
  667. Com_insert_select 0
  668. Com_install_plugin 0
  669. Com_kill 0
  670. Com_load 0
  671. Com_load_master_data 0
  672. Com_load_master_table 0
  673. Com_lock_tables 0
  674. Com_optimize 0
  675. Com_preload_keys 0
  676. Com_prepare_sql 0
  677. Com_purge 0
  678. Com_purge_before_date 0
  679. Com_release_savepoint 0
  680. Com_rename_table 0
  681. Com_rename_user 0
  682. Com_repair 0
  683. Com_replace 0
  684. Com_replace_select 0
  685. Com_reset 0
  686. Com_restore_table 0
  687. Com_revoke 0
  688. Com_revoke_all 0
  689. Com_rollback 0
  690. Com_rollback_to_savepoint 0
  691. Com_savepoint 0
  692. Com_select 1
  693. Com_set_option 0
  694. Com_show_authors 0
  695. Com_show_binlog_events 0
  696. Com_show_binlogs 0
  697. Com_show_charsets 0
  698. Com_show_collations 0
  699. Com_show_column_types 0
  700. Com_show_contributors 0
  701. Com_show_create_db 0
  702. Com_show_create_event 0
  703. Com_show_create_func 0
  704. Com_show_create_proc 0
  705. Com_show_create_table 0
  706. Com_show_create_trigger 0
  707. Com_show_databases 0
  708. Com_show_engine_logs 0
  709. Com_show_engine_mutex 0
  710. Com_show_engine_status 0
  711. Com_show_events 0
  712. Com_show_errors 0
  713. Com_show_fields 0
  714. Com_show_function_status 0
  715. Com_show_grants 0
  716. Com_show_keys 0
  717. Com_show_master_status 0
  718. Com_show_new_master 0
  719. Com_show_open_tables 0
  720. Com_show_plugins 0
  721. Com_show_privileges 0
  722. Com_show_procedure_status 0
  723. Com_show_processlist 0
  724. Com_show_profile 0
  725. Com_show_profiles 0
  726. Com_show_slave_hosts 0
  727. Com_show_slave_status 0
  728. Com_show_status 1
  729. Com_show_storage_engines 0
  730. Com_show_table_status 0
  731. Com_show_tables 0
  732. Com_show_triggers 0
  733. Com_show_variables 0
  734. Com_show_warnings 0
  735. Com_slave_start 0
  736. Com_slave_stop 0
  737. Com_stmt_close 0
  738. Com_stmt_execute 0
  739. Com_stmt_fetch 0
  740. Com_stmt_prepare 0
  741. Com_stmt_reprepare 0
  742. Com_stmt_reset 0
  743. Com_stmt_send_long_data 0
  744. Com_truncate 0
  745. Com_uninstall_plugin 0
  746. Com_unlock_tables 0
  747. Com_update 0
  748. Com_update_multi 0
  749. Com_xa_commit 0
  750. Com_xa_end 0
  751. Com_xa_prepare 0
  752. Com_xa_recover 0
  753. Com_xa_rollback 0
  754. Com_xa_start 0
  755. Compression OFF
  756. Connections 3298
  757. Created_tmp_disk_tables 0
  758. Created_tmp_files 5
  759. Created_tmp_tables 0
  760. Delayed_errors 0
  761. Delayed_insert_threads 0
  762. Delayed_writes 0
  763. Flush_commands 1
  764. Handler_commit 0
  765. Handler_delete 0
  766. Handler_discover 0
  767. Handler_prepare 0
  768. Handler_read_first 0
  769. Handler_read_key 0
  770. Handler_read_next 0
  771. Handler_read_prev 0
  772. Handler_read_rnd 0
  773. Handler_read_rnd_next 0
  774. Handler_rollback 0
  775. Handler_savepoint 0
  776. Handler_savepoint_rollback 0
  777. Handler_update 0
  778. Handler_write 0
  779. Innodb_buffer_pool_pages_data 1713
  780. Innodb_buffer_pool_pages_dirty 0
  781. Innodb_buffer_pool_pages_flushed 301
  782. Innodb_buffer_pool_pages_free 14653
  783. Innodb_buffer_pool_pages_misc 18
  784. Innodb_buffer_pool_pages_total 16384
  785. Innodb_buffer_pool_read_ahead_rnd 4
  786. Innodb_buffer_pool_read_ahead_seq 0
  787. Innodb_buffer_pool_read_requests 161198
  788. Innodb_buffer_pool_reads 1542
  789. Innodb_buffer_pool_wait_free 0
  790. Innodb_buffer_pool_write_requests 1550
  791. Innodb_data_fsyncs 184
  792. Innodb_data_pending_fsyncs 0
  793. Innodb_data_pending_reads 0
  794. Innodb_data_pending_writes 0
  795. Innodb_data_read 29855744
  796. Innodb_data_reads 1738
  797. Innodb_data_writes 316
  798. Innodb_data_written 10537472
  799. Innodb_dblwr_pages_written 301
  800. Innodb_dblwr_writes 42
  801. Innodb_log_waits 0
  802. Innodb_log_write_requests 1822
  803. Innodb_log_writes 48
  804. Innodb_os_log_fsyncs 76
  805. Innodb_os_log_pending_fsyncs 0
  806. Innodb_os_log_pending_writes 0
  807. Innodb_os_log_written 659968
  808. Innodb_page_size 16384
  809. Innodb_pages_created 24
  810. Innodb_pages_read 1689
  811. Innodb_pages_written 301
  812. Innodb_row_lock_current_waits 0
  813. Innodb_row_lock_time 0
  814. Innodb_row_lock_time_avg 0
  815. Innodb_row_lock_time_max 0
  816. Innodb_row_lock_waits 0
  817. Innodb_rows_deleted 19
  818. Innodb_rows_inserted 24
  819. Innodb_rows_read 80483
  820. Innodb_rows_updated 77
  821. Key_blocks_not_flushed 0
  822. Key_blocks_unused 13891
  823. Key_blocks_used 2681
  824. Key_read_requests 418178
  825. Key_reads 2624
  826. Key_write_requests 39110
  827. Key_writes 38310
  828. Last_query_cost 0.000000
  829. Max_used_connections 6
  830. Not_flushed_delayed_rows 0
  831. Open_files 4292
  832. Open_streams 0
  833. Open_table_definitions 2292
  834. Open_tables 2313
  835. Opened_files 14783
  836. Opened_table_definitions 0
  837. Opened_tables 0
  838. Prepared_stmt_count 0
  839. Qcache_free_blocks 136
  840. Qcache_free_memory 232500992
  841. Qcache_hits 195682
  842. Qcache_inserts 26575
  843. Qcache_lowmem_prunes 0
  844. Qcache_not_cached 4384
  845. Qcache_queries_in_cache 14809
  846. Qcache_total_blocks 30430
  847. Queries 241702
  848. Questions 2
  849. Rpl_status NULL
  850. Select_full_join 0
  851. Select_full_range_join 0
  852. Select_range 0
  853. Select_range_check 0
  854. Select_scan 0
  855. Slave_open_temp_tables 0
  856. Slave_retried_transactions 0
  857. Slave_running OFF
  858. Slow_launch_threads 0
  859. Slow_queries 0
  860. Sort_merge_passes 0
  861. Sort_range 0
  862. Sort_rows 0
  863. Sort_scan 0
  864. Ssl_accept_renegotiates 0
  865. Ssl_accepts 0
  866. Ssl_callback_cache_hits 0
  867. Ssl_cipher
  868. Ssl_cipher_list
  869. Ssl_client_connects 0
  870. Ssl_connect_renegotiates 0
  871. Ssl_ctx_verify_depth 0
  872. Ssl_ctx_verify_mode 0
  873. Ssl_default_timeout 0
  874. Ssl_finished_accepts 0
  875. Ssl_finished_connects 0
  876. Ssl_session_cache_hits 0
  877. Ssl_session_cache_misses 0
  878. Ssl_session_cache_mode NONE
  879. Ssl_session_cache_overflows 0
  880. Ssl_session_cache_size 0
  881. Ssl_session_cache_timeouts 0
  882. Ssl_sessions_reused 0
  883. Ssl_used_session_cache_entries 0
  884. Ssl_verify_depth 0
  885. Ssl_verify_mode 0
  886. Ssl_version
  887. Table_locks_immediate 43722
  888. Table_locks_waited 13
  889. Tc_log_max_pages_used 0
  890. Tc_log_page_size 0
  891. Tc_log_page_waits 0
  892. Threads_cached 5
  893. Threads_connected 1
  894. Threads_created 6
  895. Threads_running 1
  896. Uptime 4908
  897. Uptime_since_flush_status 4908
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!