Tags: tmpfs

Oct 31

Speed up ORDER BY queries in MySQL

Linux, Fedora, MySQL Send feedback »
One of the reasons MySQL is popping up in top or is eating up to much processor time... or nowdays is eating up too many processors are ORDER BY clauses. Many ORDER BY clauses will translate in temporary tables stored to disk. If you are using GROUP BY c… more »

Tags: fstab, mysql eating processor, mysql optimization, order by, os optimization, temporary tables, tmpdir, tmpfs, top

Contact. ©2012 by Gabriel PREDA. b2 / web hosting / monetizing.
Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.
Entries RSS Comments RSS Log in