Hello,
I have a big query that uses SQL_CALC_FOUND_ROWS, count, sum, GROUP BY multiple columns and ORDER BY multimple columns. The query runs accross 24 tables with a total of 3 million rows.
Unfortunately I can't post the query in plain text here.
Here is an EXPLAIN:
http://img189.imageshack.us/img189/8892/mysqlexplain1.gif
The machine is:
4 x KVR1066D3N7/4G 4GB 1066MHz DDR3 Non-ECC CL7 DIMM
1 x Intel Xeon E5645 2400MHz
2 x 120GB Kingston SDD Drive HyperX SSD SATA 3 2.5
The query takes about 40s and I really need to reduce this time.
Please give me some solutions.
- buy more hardware? ram? cpu?
- add another machine + mysql cluster?
- optimise query more?
- what em I doing wrong?
