I have a huge table of around 5,000,000 subscribers. The table has one primary key which will be used to perform a search on any user.
What I am wondering is
- Will the number of threads connected to Mysql by my application have any performance impact, if yes then what should be the optimum value.
- I understand that the Key-Buffer)_size should be 40% of available memory?
- I am not using a query cache as i will be updating table as frequently as I will perform a select query.
- Which other attributes can be tweaked to get the maximum performance.
I really appreciate any advise.