API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 10th, 2019
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.51 KB | None | 0 0
raw download clone embed print report
  1. # Example MySQL config file for medium systems.
  2. #
  3. # This is for a system with little memory (32M - 64M) where MySQL plays
  4. # an important part, or systems up to 128M where MySQL is used together with
  5. # other programs (such as a web server)
  6. #
  7. # MySQL programs look for option files in a set of
  8. # locations which depend on the deployment platform.
  9. # You can copy this option file to one of those
  10. # locations. For information about these locations, see:
  11. # http://dev.mysql.com/doc/mysql/en/option-files.html
  12. #
  13. # In this file, you can use all long options that a program supports.
  14. # If you want to know which options a program supports, run the program
  15. # with the "--help" option.
  16.  
  17. # The following options will be passed to all MySQL clients
  18. [client]
  19. #password = your_password
  20. port = 3306
  21. socket = /tmp/mysql.sock
  22.  
  23. # Here follows entries for some specific programs
  24.  
  25. # The MySQL server
  26. [mysqld]
  27. port = 3306
  28. socket = /tmp/mysql.sock
  29. datadir = /usr/local/mysql/var
  30. default-storage-engine=MyISAM
  31. loose-skip-innodb
  32. skip-external-locking
  33. max_connections = 1000
  34. key_buffer_size = 16M
  35. max_allowed_packet = 1M
  36. table_open_cache = 64
  37. sort_buffer_size = 512K
  38. net_buffer_length = 8K
  39. read_buffer_size = 256K
  40. read_rnd_buffer_size = 512K
  41. myisam_sort_buffer_size = 8M
  42.  
  43. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  44. # if all processes that need to connect to mysqld run on the same host.
  45. # All interaction with mysqld must be made via Unix sockets or named pipes.
  46. # Note that using this option without enabling named pipes on Windows
  47. # (via the "enable-named-pipe" option) will render mysqld useless!
  48. #
  49. #skip-networking
  50.  
  51. # Replication Master Server (default)
  52. # binary logging is required for replication
  53. log-bin=mysql-bin
  54.  
  55. # binary logging format - mixed recommended
  56. binlog_format=mixed
  57.  
  58. # required unique id between 1 and 2^32 - 1
  59. # defaults to 1 if master-host is not set
  60. # but will not function as a master if omitted
  61. server-id = 1
  62.  
  63. # Replication Slave (comment out master section to use this)
  64. #
  65. # To configure this host as a replication slave, you can choose between
  66. # two methods :
  67. #
  68. # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
  69. # the syntax is:
  70. #
  71. # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
  72. # MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
  73. #
  74. # where you replace <host>, <user>, <password> by quoted strings and
  75. # <port> by the master's port number (3306 by default).
  76. #
  77. # Example:
  78. #
  79. # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
  80. # MASTER_USER='joe', MASTER_PASSWORD='secret';
  81. #
  82. # OR
  83. #
  84. # 2) Set the variables below. However, in case you choose this method, then
  85. # start replication for the first time (even unsuccessfully, for example
  86. # if you mistyped the password in master-password and the slave fails to
  87. # connect), the slave will create a master.info file, and any later
  88. # change in this file to the variables' values below will be ignored and
  89. # overridden by the content of the master.info file, unless you shutdown
  90. # the slave server, delete master.info and restart the slaver server.
  91. # For that reason, you may want to leave the lines below untouched
  92. # (commented) and instead use CHANGE MASTER TO (see above)
  93. #
  94. # required unique id between 2 and 2^32 - 1
  95. # (and different from the master)
  96. # defaults to 2 if master-host is set
  97. # but will not function as a slave if omitted
  98. #server-id = 2
  99. #
  100. # The replication master for this slave - required
  101. #master-host = <hostname>
  102. #
  103. # The username the slave will use for authentication when connecting
  104. # to the master - required
  105. #master-user = <username>
  106. #
  107. # The password the slave will authenticate with when connecting to
  108. # the master - required
  109. #master-password = <password>
  110. #
  111. # The port the master is listening on.
  112. # optional - defaults to 3306
  113. #master-port = <port>
  114. #
  115. # binary logging - not required for slaves, but recommended
  116. #log-bin=mysql-bin
  117.  
  118. # Uncomment the following if you are using InnoDB tables
  119. #innodb_data_home_dir = /usr/local/mysql/data
  120. #innodb_data_file_path = ibdata1:10M:autoextend
  121. #innodb_log_group_home_dir = /usr/local/mysql/data
  122. # You can set .._buffer_pool_size up to 50 - 80 %
  123. # of RAM but beware of setting memory usage too high
  124. #innodb_buffer_pool_size = 16M
  125. #innodb_additional_mem_pool_size = 2M
  126. # Set .._log_file_size to 25 % of buffer pool size
  127. #innodb_log_file_size = 5M
  128. #innodb_log_buffer_size = 8M
  129. #innodb_flush_log_at_trx_commit = 1
  130. #innodb_lock_wait_timeout = 50
  131.  
  132. [mysqldump]
  133. quick
  134. max_allowed_packet = 16M
  135.  
  136. [mysql]
  137. no-auto-rehash
  138. # Remove the next comment character if you are not familiar with SQL
  139. #safe-updates
  140.  
  141. [myisamchk]
  142. key_buffer_size = 20M
  143. sort_buffer_size = 20M
  144. read_buffer = 2M
  145. write_buffer = 2M
  146.  
  147. [mysqlhotcopy]
  148. interactive-timeout
  149.  
  150. expire_logs_days = 10
  151.  
  152. +------------------------------------------+--------------+
  153. | Variable_name | Value |
  154. +------------------------------------------+--------------+
  155. | Aborted_clients | 10087 |
  156. | Aborted_connects | 8197 |
  157. | Binlog_cache_disk_use | 0 |
  158. | Binlog_cache_use | 0 |
  159. | Binlog_stmt_cache_disk_use | 0 |
  160. | Binlog_stmt_cache_use | 12493469 |
  161. | Bytes_received | 3687291574 |
  162. | Bytes_sent | 291880589948 |
  163. | Com_admin_commands | 0 |
  164. | Com_assign_to_keycache | 0 |
  165. | Com_alter_db | 0 |
  166. | Com_alter_db_upgrade | 0 |
  167. | Com_alter_event | 0 |
  168. | Com_alter_function | 0 |
  169. | Com_alter_procedure | 0 |
  170. | Com_alter_server | 0 |
  171. | Com_alter_table | 0 |
  172. | Com_alter_tablespace | 0 |
  173. | Com_analyze | 0 |
  174. | Com_begin | 0 |
  175. | Com_binlog | 0 |
  176. | Com_call_procedure | 0 |
  177. | Com_change_db | 184 |
  178. | Com_change_master | 0 |
  179. | Com_check | 0 |
  180. | Com_checksum | 0 |
  181. | Com_commit | 0 |
  182. | Com_create_db | 0 |
  183. | Com_create_event | 0 |
  184. | Com_create_function | 0 |
  185. | Com_create_index | 0 |
  186. | Com_create_procedure | 0 |
  187. | Com_create_server | 0 |
  188. | Com_create_table | 0 |
  189. | Com_create_trigger | 0 |
  190. | Com_create_udf | 0 |
  191. | Com_create_user | 0 |
  192. | Com_create_view | 0 |
  193. | Com_dealloc_sql | 0 |
  194. | Com_delete | 12473855 |
  195. | Com_delete_multi | 0 |
  196. | Com_do | 0 |
  197. | Com_drop_db | 0 |
  198. | Com_drop_event | 0 |
  199. | Com_drop_function | 0 |
  200. | Com_drop_index | 0 |
  201. | Com_drop_procedure | 0 |
  202. | Com_drop_server | 0 |
  203. | Com_drop_table | 0 |
  204. | Com_drop_trigger | 0 |
  205. | Com_drop_user | 0 |
  206. | Com_drop_view | 0 |
  207. | Com_empty_query | 0 |
  208. | Com_execute_sql | 0 |
  209. | Com_flush | 0 |
  210. | Com_grant | 0 |
  211. | Com_ha_close | 0 |
  212. | Com_ha_open | 0 |
  213. | Com_ha_read | 0 |
  214. | Com_help | 0 |
  215. | Com_insert | 5770 |
  216. | Com_insert_select | 0 |
  217. | Com_install_plugin | 0 |
  218. | Com_kill | 0 |
  219. | Com_load | 0 |
  220. | Com_lock_tables | 0 |
  221. | Com_optimize | 43 |
  222. | Com_preload_keys | 0 |
  223. | Com_prepare_sql | 0 |
  224. | Com_purge | 0 |
  225. | Com_purge_before_date | 0 |
  226. | Com_release_savepoint | 0 |
  227. | Com_rename_table | 0 |
  228. | Com_rename_user | 0 |
  229. | Com_repair | 1 |
  230. | Com_replace | 0 |
  231. | Com_replace_select | 0 |
  232. | Com_reset | 0 |
  233. | Com_resignal | 0 |
  234. | Com_revoke | 0 |
  235. | Com_revoke_all | 0 |
  236. | Com_rollback | 0 |
  237. | Com_rollback_to_savepoint | 0 |
  238. | Com_savepoint | 0 |
  239. | Com_select | 19889272 |
  240. | Com_set_option | 3310596 |
  241. | Com_signal | 0 |
  242. | Com_show_authors | 0 |
  243. | Com_show_binlog_events | 0 |
  244. | Com_show_binlogs | 20 |
  245. | Com_show_charsets | 0 |
  246. | Com_show_collations | 0 |
  247. | Com_show_contributors | 0 |
  248. | Com_show_create_db | 0 |
  249. | Com_show_create_event | 0 |
  250. | Com_show_create_func | 0 |
  251. | Com_show_create_proc | 0 |
  252. | Com_show_create_table | 3 |
  253. | Com_show_create_trigger | 0 |
  254. | Com_show_databases | 0 |
  255. | Com_show_engine_logs | 0 |
  256. | Com_show_engine_mutex | 0 |
  257. | Com_show_engine_status | 0 |
  258. | Com_show_events | 0 |
  259. | Com_show_errors | 0 |
  260. | Com_show_fields | 8 |
  261. | Com_show_function_status | 0 |
  262. | Com_show_grants | 22 |
  263. | Com_show_keys | 11 |
  264. | Com_show_master_status | 101 |
  265. | Com_show_open_tables | 0 |
  266. | Com_show_plugins | 0 |
  267. | Com_show_privileges | 0 |
  268. | Com_show_procedure_status | 0 |
  269. | Com_show_processlist | 1 |
  270. | Com_show_profile | 0 |
  271. | Com_show_profiles | 0 |
  272. | Com_show_relaylog_events | 0 |
  273. | Com_show_slave_hosts | 0 |
  274. | Com_show_slave_status | 101 |
  275. | Com_show_status | 1 |
  276. | Com_show_storage_engines | 0 |
  277. | Com_show_table_status | 15 |
  278. | Com_show_tables | 397 |
  279. | Com_show_triggers | 0 |
  280. | Com_show_variables | 253 |
  281. | Com_show_warnings | 0 |
  282. | Com_slave_start | 0 |
  283. | Com_slave_stop | 0 |
  284. | Com_stmt_close | 0 |
  285. | Com_stmt_execute | 0 |
  286. | Com_stmt_fetch | 0 |
  287. | Com_stmt_prepare | 0 |
  288. | Com_stmt_reprepare | 0 |
  289. | Com_stmt_reset | 0 |
  290. | Com_stmt_send_long_data | 0 |
  291. | Com_truncate | 9344502 |
  292. | Com_uninstall_plugin | 0 |
  293. | Com_unlock_tables | 0 |
  294. | Com_update | 13844 |
  295. | Com_update_multi | 0 |
  296. | Com_xa_commit | 0 |
  297. | Com_xa_end | 0 |
  298. | Com_xa_prepare | 0 |
  299. | Com_xa_recover | 0 |
  300. | Com_xa_rollback | 0 |
  301. | Com_xa_start | 0 |
  302. | Compression | OFF |
  303. | Connections | 3318559 |
  304. | Created_tmp_disk_tables | 310 |
  305. | Created_tmp_files | 1322455 |
  306. | Created_tmp_tables | 3335 |
  307. | Delayed_errors | 0 |
  308. | Delayed_insert_threads | 0 |
  309. | Delayed_writes | 0 |
  310. | Flush_commands | 1 |
  311. | Handler_commit | 12493469 |
  312. | Handler_delete | 209513 |
  313. | Handler_discover | 0 |
  314. | Handler_prepare | 0 |
  315. | Handler_read_first | 9376341 |
  316. | Handler_read_key | 20693044015 |
  317. | Handler_read_last | 86997 |
  318. | Handler_read_next | 538711336998 |
  319. | Handler_read_prev | 653669508 |
  320. | Handler_read_rnd | 12570686526 |
  321. | Handler_read_rnd_next | 14972265938 |
  322. | Handler_rollback | 0 |
  323. | Handler_savepoint | 0 |
  324. | Handler_savepoint_rollback | 0 |
  325. | Handler_update | 268066 |
  326. | Handler_write | 98490 |
  327. | Key_blocks_not_flushed | 0 |
  328. | Key_blocks_unused | 5412 |
  329. | Key_blocks_used | 13396 |
  330. | Key_read_requests | 79033846207 |
  331. | Key_reads | 40930847 |
  332. | Key_write_requests | 4910177 |
  333. | Key_writes | 775187 |
  334. | Last_query_cost | 0.000000 |
  335. | Max_used_connections | 24 |
  336. | Not_flushed_delayed_rows | 0 |
  337. | Open_files | 104 |
  338. | Open_streams | 0 |
  339. | Open_table_definitions | 76 |
  340. | Open_tables | 62 |
  341. | Opened_files | 39150754 |
  342. | Opened_table_definitions | 9346435 |
  343. | Opened_tables | 3937 |
  344. | Performance_schema_cond_classes_lost | 0 |
  345. | Performance_schema_cond_instances_lost | 0 |
  346. | Performance_schema_file_classes_lost | 0 |
  347. | Performance_schema_file_handles_lost | 0 |
  348. | Performance_schema_file_instances_lost | 0 |
  349. | Performance_schema_locker_lost | 0 |
  350. | Performance_schema_mutex_classes_lost | 0 |
  351. | Performance_schema_mutex_instances_lost | 0 |
  352. | Performance_schema_rwlock_classes_lost | 0 |
  353. | Performance_schema_rwlock_instances_lost | 0 |
  354. | Performance_schema_table_handles_lost | 0 |
  355. | Performance_schema_table_instances_lost | 0 |
  356. | Performance_schema_thread_classes_lost | 0 |
  357. | Performance_schema_thread_instances_lost | 0 |
  358. | Prepared_stmt_count | 0 |
  359. | Qcache_free_blocks | 0 |
  360. | Qcache_free_memory | 0 |
  361. | Qcache_hits | 0 |
  362. | Qcache_inserts | 0 |
  363. | Qcache_lowmem_prunes | 0 |
  364. | Qcache_not_cached | 0 |
  365. | Qcache_queries_in_cache | 0 |
  366. | Qcache_total_blocks | 0 |
  367. | Queries | 48339408 |
  368. | Questions | 48339407 |
  369. | Rpl_status | AUTH_MASTER |
  370. | Select_full_join | 67 |
  371. | Select_full_range_join | 0 |
  372. | Select_range | 712513 |
  373. | Select_range_check | 0 |
  374. | Select_scan | 7294346 |
  375. | Slave_heartbeat_period | 0.000 |
  376. | Slave_open_temp_tables | 0 |
  377. | Slave_received_heartbeats | 0 |
  378. | Slave_retried_transactions | 0 |
  379. | Slave_running | OFF |
  380. | Slow_launch_threads | 86 |
  381. | Slow_queries | 33625 |
  382. | Sort_merge_passes | 4291823 |
  383. | Sort_range | 589090 |
  384. | Sort_rows | 178804795472 |
  385. | Sort_scan | 4174418 |
  386. | Ssl_accept_renegotiates | 0 |
  387. | Ssl_accepts | 0 |
  388. | Ssl_callback_cache_hits | 0 |
  389. | Ssl_cipher | |
  390. | Ssl_cipher_list | |
  391. | Ssl_client_connects | 0 |
  392. | Ssl_connect_renegotiates | 0 |
  393. | Ssl_ctx_verify_depth | 0 |
  394. | Ssl_ctx_verify_mode | 0 |
  395. | Ssl_default_timeout | 0 |
  396. | Ssl_finished_accepts | 0 |
  397. | Ssl_finished_connects | 0 |
  398. | Ssl_session_cache_hits | 0 |
  399. | Ssl_session_cache_misses | 0 |
  400. | Ssl_session_cache_mode | NONE |
  401. | Ssl_session_cache_overflows | 0 |
  402. | Ssl_session_cache_size | 0 |
  403. | Ssl_session_cache_timeouts | 0 |
  404. | Ssl_sessions_reused | 0 |
  405. | Ssl_used_session_cache_entries | 0 |
  406. | Ssl_verify_depth | 0 |
  407. | Ssl_verify_mode | 0 |
  408. | Ssl_version | |
  409. | Table_locks_immediate | 36358222 |
  410. | Table_locks_waited | 31331 |
  411. | Tc_log_max_pages_used | 0 |
  412. | Tc_log_page_size | 0 |
  413. | Tc_log_page_waits | 0 |
  414. | Threads_cached | 0 |
  415. | Threads_connected | 1 |
  416. | Threads_created | 3318558 |
  417. | Threads_running | 1 |
  418. | Uptime | 1292100 |
  419. | Uptime_since_flush_status | 1292100 |
  420. +------------------------------------------+--------------+
  421. 265 rows in set (0.04 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!