Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » innodb_thread_concurrency / cpu usage
innodb_thread_concurrency / cpu usage [message #362] Fri, 17 November 2006 16:35 Go to previous message
mmoeller is currently offline mmoeller
Messages: 2
Registered: November 2006
Junior Member
Hi,

we have a 4-way dualcore xeon server running mysql 5.0.27 with bufferpool-mutex-patch.

the load is entirely cpu/memory bound, no noticable disk activity.

If i set innodb_thread_concurrency to 16 or 32 and simulate a lot of load, i see that the system is overloaded but cpu usage is only at 20%.
If i set it to unlimited (0), i see cpu is going to 100%, but actually *less* queries are performed per second.

If i use SHOW MUTEX STATUS, the only mutex heavily used is the main bufferpool mutex, so I guess the concurrency problem is not entirely solved by the patch?
Report message to a moderator
[Message index]

Read Message
Read Message
Read Message
Read Message
Previous Topic:InnoDB data layout
Next Topic:How To know Table/Record changed, best performance?
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Thu Jul 9 21:14:51 EDT 2009

Total time taken to generate the page: 0.02081 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.