Not the answer you need?
Register and ask your own question!

How to Set best performance parameters

michaelkmichaelk EntrantInactive User Role Participant
Please help me to configure MYSQL server over below details.

1) 30 tables- 15 InnoDB / 15 MyISAM
2) 2 important InnoDB tables handles more than 1.5 million records in each table per month. data types are mostly strings and integers.
these two tables will join with serveral other table to provide more than 40 reports to the management daily not only that all the transactions are done on these two tables daily.

3) more than 80 users handle transactions daily.
4) 2008 Windows Server / 8 GB Ram / 40 GB in C and 500 GB in D drive to hadle all images and other billing docs.

How to set InnoDB parameters and MyISAM parameters to suit the best performance and traffic .


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.