Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
455
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. [mysqld]
  2. local-infile=0
  3. datadir=/var/lib/mysql
  4. socket=/var/lib/mysql/mysql.sock
  5. user=mysql
  6. # Disabling symbolic-links is recommended to prevent assorted security risks
  7. symbolic-links=0
  8. bind-address=127.0.0.1
  9.  
  10. # What I added below
  11. key_buffer_size=512M
  12. #sort_buffer_size=4M <-- I commented this, it seems better now
  13. #read_buffer_size=4M <-- I commented this, it seems better now
  14. innodb_thread_concurrency=0
  15. innodb_buffer_pool_size=9G
  16. tmp_table_size=128M
  17. max_heap_table_size=128M
  18. skip-name-resolve
  19. query_cache_size=64M
  20.  
  21. SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM
  22. (SELECT SUM(data_length+index_length) Total_InnoDB_Bytes
  23. FROM information_schema.tables WHERE engine='InnoDB') A;
  24. +-------+
  25. | RIBPS |
  26. +-------+
  27. | 9 |
  28. +-------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement