MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Real weird slow down with select count(distinct x) and high max_heap_table_size
Posted by: Ventsislav Alexandriyski
Date: April 02, 2010 06:25AM

How many ram you have?
Maybe if ram is not enough new memory tables created by running applications are using more ram and there is not enough ram for indexing

-------------------------------Signature-----------------------------------------
http://www.nezavisim.com
I need job so if in your company there is need for optimizing and improving I am the man.
I can work from home via internet. Results are always best

I can complete all tasks from idea to final product, handling hardware desing, programming, installing and configuring all required hadrware and software.
And what can you?

Forum Moderators delete my posts so I cannot write delailed explanations, becaue this will be waste of time when my post is deleted by motherators

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.