MySQL Forums
Forum List  »  MyISAM

Re: MySQL Performance - multiple concurrent processes
Posted by: Rick James
Date: April 07, 2009 07:01PM

Turn off the query cache.
SET @@global.query_cache_type=0;

Puzzles...
* You have objectid in both tables, so you don't really need filename, filesize, hash in the files table.
* You have no indexes on files; will you never query it?
* VARCHAR(256) - just over the limit for using 1 byte length; perhaps you meant 255.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Performance - multiple concurrent processes
2702
April 07, 2009 07:01PM


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.