Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- local-infile=0
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- user=mysql
- # Disabling symbolic-links is recommended to prevent assorted security risks
- symbolic-links=0
- bind-address=127.0.0.1
- # What I added below
- key_buffer_size=512M
- #sort_buffer_size=4M <-- I commented this, it seems better now
- #read_buffer_size=4M <-- I commented this, it seems better now
- innodb_thread_concurrency=0
- innodb_buffer_pool_size=9G
- tmp_table_size=128M
- max_heap_table_size=128M
- skip-name-resolve
- query_cache_size=64M
- SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM
- (SELECT SUM(data_length+index_length) Total_InnoDB_Bytes
- FROM information_schema.tables WHERE engine='InnoDB') A;
- +-------+
- | RIBPS |
- +-------+
- | 9 |
- +-------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement