MySQL Performance: MySQL => Query cache not working

Members

Help

Help

Register

Login

Home

Home » Performance » MySQL » Query cache not working

Show: Today's Messages :: Show Polls :: Message Navigator

Switch to threaded view of this topic

Create a new topic

Submit Reply

Query cache not working [message #123]

Wed, 30 August 2006 19:40

Himalian is currently offline

Himalian
Messages: 4
Registered: August 2006

Junior Member

Hi,
since my server goes very slow under a bit of load I tried to enable the query cache. I'm just running WordPress (PHP 5.1) + MySQL 4.1.10a and it's a VPS (Virtual Private Server) on Virtuozzu with Suse Linux 9.3

Below are the MySQL server variables:

have query cache   	 	YES  	 YES
query cache limit   	 	1048576  1048576
query cache min res unit 	4096 	4096
query cache size 		0 	0
query cache type 		ON 	ON
query cache wlock invalidate 	OFF 	OFF
query prealloc size 		8192 	8192

but the current status information just show:

Qcache free blocks   	 0 
 Qcache free memory  	 0 
 Qcache hits  	 	 0 
 Qcache inserts  	 0 
 Qcache lowmem prunes  	 0 
 Qcache not cached  	 0 
 Qcache queries in cache 0 
 Qcache total blocks  	 0

Did I miss a configuration value? There should be a lot of cacheable queries because the wordpress tables are rarely updated.

Best regards,

Himalian

Report message to a moderator

Send a private message to this user

Re: Query cache not working [message #124 is a reply to message #123 ]

Thu, 31 August 2006 04:22

Himalian is currently offline

Himalian
Messages: 4
Registered: August 2006

Junior Member

Oh, I'm sorry... I thought "query cache size" was the actual used size of the cache, not the maximum size. Works now Smile

Smile

Report message to a moderator

Send a private message to this user

Re: Query cache not working [message #127 is a reply to message #124 ]

Thu, 31 August 2006 07:45

Peter is currently offline

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

Ok, Good you've found the problem Smile

Smile

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Send a private message to this user

Re: Query cache not working [message #130 is a reply to message #123 ]

Thu, 31 August 2006 19:03

Himalian is currently offline

Himalian
Messages: 4
Registered: August 2006

Junior Member

Yes, sometimes it's better to read the manual again instead of directly posting to a forum Embarassed

Embarassed

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

Previous Topic:	Optimizer Woes
Next Topic:	General query log performance

Goto Forum:

-=] Back to Top [=-

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

]

Current Time: Sun Jul 5 22:33:30 EDT 2009

Total time taken to generate the page: 0.01221 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.