Hi guys, My database size is growing larger and larger each day and I assume this will have an impact on the website performance sooner or later. What are the best tools available to test MYSQL performance and how can I scale the database further without having any impact on performance? Any ideas? Thanks guys. Cheers,
I use slow queries log to find "bottle necks". Scale database - upgrade memory and processor. Actually what kind of tool are looking for? To check number of queries per second? Each testing will stress your database and it looks lke not a good idea to perfomance testing at the live db.