Guest User

Untitled

a guest
Jan 16th, 2018
325
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.90 KB | None | 0 0
  1. [mysqld]
  2. sql_mode=""
  3. max_connections = 350
  4. innodb_file_per_table=ON
  5. default-storage-engine=MyISAM
  6. max_connect_errors = 50
  7. interactive_timeout = 1000
  8. wait_timeout = 1000
  9. open-files-limit=65535
  10. group_concat_max_len=50000
  11. myisam-recover-options=BACKUP,FORCE
  12. symbolic-links=0
  13. secure-file-priv=""
  14. skip-external-locking
  15. max_allowed_packet = 256M
  16. table_open_cache = 1024
  17. table_open_cache_instances = 8
  18. read_rnd_buffer_size = 16M
  19. sort_buffer_size = 16M
  20. read_buffer_size = 8M
  21. thread_cache_size = 32
  22. query_cache_type = 1
  23. query_cache_limit = 4M
  24. query_cache_size = 128M
  25. slow_query_log=1
  26.  
  27. +--------------------------------+-----------+
  28. | Variable_name | Value |
  29. +--------------------------------+-----------+
  30. | Binlog_cache_disk_use | 0 |
  31. | Binlog_cache_use | 0 |
  32. | Binlog_stmt_cache_disk_use | 0 |
  33. | Binlog_stmt_cache_use | 0 |
  34. | Com_assign_to_keycache | 0 |
  35. | Qcache_free_blocks | 6 |
  36. | Qcache_free_memory | 134061488 |
  37. | Qcache_hits | 62 |
  38. | Qcache_inserts | 100 |
  39. | Qcache_lowmem_prunes | 0 |
  40. | Qcache_not_cached | 16 |
  41. | Qcache_queries_in_cache | 73 |
  42. | Qcache_total_blocks | 166 |
  43. | Ssl_callback_cache_hits | 0 |
  44. | Ssl_session_cache_hits | 0 |
  45. | Ssl_session_cache_misses | 0 |
  46. | Ssl_session_cache_mode | SERVER |
  47. | Ssl_session_cache_overflows | 0 |
  48. | Ssl_session_cache_size | 128 |
  49. | Ssl_session_cache_timeouts | 0 |
  50. | Ssl_used_session_cache_entries | 0 |
  51. | Table_open_cache_hits | 13945 |
  52. | Table_open_cache_misses | 820 |
  53. | Table_open_cache_overflows | 191 |
  54. | Threads_cached | 3 |
  55. +--------------------------------+-----------+
Add Comment
Please, Sign In to add comment