first: Sorry for my poor english I’ll give my best that you all understand my questions
I have a debian 5.0 System with percona 5.5 as deb-package.
Before i had mysql 5.5. i have switched to the percona server, because i have a big database. this contains a table with 5 mio. rows in innoDB. When i do a select with sort and while on this table, it take about 5-10 seconds to show me the result.
For the innoDB buffer pool size i have granted 17.000 MB.
The data-files of the sqlserver are on a fast SSD-Drive.
What can i do to get a faster query? The indexes are correct.
Thank you for help