MySQL Forums
Forum List  »  InnoDB

Slow Result Sets, Plenty of Idle CPU
Posted by: Ed D
Date: March 14, 2008 06:43PM

My queries are extremely building the result sets. The server shows 3-9% cpu usage and 80% memory consumption when the request is being made. And it just spins and spins. I can see that the memory for the mysql process is using the 3Gb I've allocated when the requests are made.

Here is some information in hopes someone can shed some light:

[server]
Gentoo Linux
AMD 2.5Ghz X2
4Gb RAM

[mysql]
Ver 14.12 Distrib 5.0.50, for pc-linux-gnu (x86_64)
17Gb Data
db engine = innodb
innodb_file_per_table
innodb_open_files=1024
innodb_buffer_pool_size = 3000M
innodb_additional_mem_pool_size = 256M
innodb_log_file_size = 128M
innodb_log_buffer_size = 16M

Options: ReplyQuote


Subject
Views
Written By
Posted
Slow Result Sets, Plenty of Idle CPU
2150
March 14, 2008 06:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.