Timeline for How to optimize the my.cnf of a MySQL server that mixes InnoDB and MyISAM tablespaces?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Jan 13, 2012 at 18:00 | comment | added | user5793 | Thank you Rolando, but how it would look the my.cnf? could please show me an example, sorry but I'm in a hurry... | |
| Jan 13, 2012 at 17:59 | comment | added | RolandoMySQLDBA | You can set the option for both. However, keep in mind that the limiting factor is the actual amount of RAM for your DB Server. As a rule of thumb, make sure the sum of the key_buffer_size and innodb_buffer_pool_size does not exceed 75% of your Installed RAM. If you are running other services on the DB server (such as apache, memcached, monyog, nagios), then you will need to do one of two things: 1) use 25% of the installed RAM for the sum of the key_buffer_size and innodb_buffer_pool_size, or 2) get a separate DB server where you can apply the 75% rule or even upgrade the amount of RAM. | |
| Jan 13, 2012 at 17:49 | comment | added | user5793 | But how can I specify on the same cnf some tables with myisam and some with innodb? | |
| Jan 13, 2012 at 16:31 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |