You neglected to say how much memory your system has.
I am a newbie, but one of the first things I learned about mysql, is
that it needs a lot of memory to handle any kind of load. If you do
not have at least 500meg, add some.
On 26 Feb 2001, at 13:22, Joseph Bueno wrote:
Hi list,
I have
Hi list,
I have some trouble trying to optimise SELECT queries
that use ORDER BY condition.
I have found out that each time the server is busy
(100% CPU usage), it is due to queries that show
up in 'mysqladmin processlist' report with 'Sorting result'
state in 'Command' column.
I am trying to