I have been performing a few MySQL upgrades from 5.5 to 5.6. It is general a straight forward process but I wanted to discuss MySQL 5.6 parameters changes.
Showing posts with label Mysql parameters. Show all posts
Showing posts with label Mysql parameters. Show all posts
MySQL Tuning Parameter
I haven't posted anything in a while. The holiday season has been busy and I have been complete upgrade projects. Before I start belated Happy New Year to you.
Whilst working on a small client database recently and made a list the MySQL parameters we used to tune the database. Hopefully it may give you some pointers into database tuning and parameters to look at. I should give you a couple of more details the database is fairly large about 3TB. It's a mix of online and archive data. It's main transaction types are insert and select. The database version is 5.5.11 (soon to be upgraded to 5.6.14). The databases within the instance are mainly innodb.
Whilst working on a small client database recently and made a list the MySQL parameters we used to tune the database. Hopefully it may give you some pointers into database tuning and parameters to look at. I should give you a couple of more details the database is fairly large about 3TB. It's a mix of online and archive data. It's main transaction types are insert and select. The database version is 5.5.11 (soon to be upgraded to 5.6.14). The databases within the instance are mainly innodb.
Subscribe to:
Posts (Atom)