Once you have innodb_buffer_pool_size, set innodb_log_file_size to 25% of innodb_buffer_pool_size. If you have a mixture of InnoDB and MyISAM data, then strike a balance between these numbers and leave at least 25% of system RAM free for MacOS. This is suuuper helpful but I am on Mac which cannot run Oracle’s. Here is a screenshot of the feature I’m talking about. Obviously, if this number exceeds 3072M (3GB,75% of system RAM), then set innodb_buffer_pool_size to your liking with good judgment, as long as it's less than 3072M. I know there is a super handy query builder feature for Oracle’s SQL workshop that allows you to select items across multiple tables and columns then generates the corresponding SQL query. This will give you the proper size for innodb_buffer_pool_size given the amount of InnoDB data and indexes you have. Information_schema.tables WHERE engine = 'InnoDB' SELECT SUM(data_length+index_length) InnoDBDataAndIndexes FROM If the majority of your data in InnoDB do this SELECT CONCAT(CEILING(InnoDBDataAndIndexes/POWER(1024,2)),'M') KeyBufferSize Obviously, if this number exceeds 1024M (1GB,25% of system RAM), then set key_buffer_size to your liking with good judgment, as long as it's less than 1024M. This will give you the proper size for key_buffer_size given the amount of MyISAM data you have. WHERE table_schema NOT IN ('information_schema','mysql') If the majority of your data is MyISAM do this: SELECT CONCAT(CEILING(SumNDXs/POWER(1024,2)),'M') KeyBufferSize Once you copy my-medium.cnf to my.cnf, you could tune it as follows: If the Mac version of MySQL came with similar. The Windows version of MySQL came with my-medium.ini, my-small.ini, my-large.ini, my-huge.ini. I have never used MySQL on a Mac, but I have for Windows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |