Re: Server just hanging (Copying to tmp table)

[Aziz Sasmaz]

I have the same problem. My site has a heavy traffic on which the students are taking exams and seeing their evaluation results. There are also measurement and evaluation statistics tables which has 2.000.000 rows. I store last login information on a table which has 3.000.000 rows. But queries are well optimized each with explain.

I tried both mysql 5.0 and 5.1.

mysqlreport says everything is okay. Every variables seem fine. But when the visitors came after we transfered exam results, traffic just increases and server load comes to %50 and %60 some queries say Copying to tmp table. I have 4 Xeon MP and 6 gb of ram in the box.

I am planning to buy new hardware A master for inserts, and at least 5 slaves for selects.

But I can't be sure if this problem occurs because of an insufficient hardware.