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.
Subject
Views
Written By
Posted
4565
April 06, 2009 02:28PM
2452
April 07, 2009 07:32AM
Re: MySQL Performance - multiple concurrent processes
2702
April 07, 2009 07:01PM
3489
April 08, 2009 10:15AM
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.