123 reputation
6
bio website twitter.com/ddrager
location Coatesville, PA
age 34
visits member for 2 years, 2 months
seen Nov 5 '12 at 16:25

CTO of XDA Developers.

Linux systems are my specialty. As with any good system administrator, I dabble in networking, storage, virtualization, Android, and more.

LOPSA since 2008

I enjoy spending time with my family, social media, gaming and going backpacking. I have also blogged professionally for MakeUseOf, Lifehacker, and my own personal blog about system adminstration.


Feb
20
awarded  Popular Question
Nov
3
comment Simple Slow Query Not Using Indexes
Thanks for the info - this is helpful. I also thought that perhaps it is because I am using parentid, however if I eliminate that part of the WHERE clause from the query entirely, I would think that the idx_ksours index would hold all of the values it needs, but I still get a FILESORT. How would I create an index that would be used properly by this query?
Nov
3
asked Simple Slow Query Not Using Indexes
Jul
20
comment Optimizing DELETE Query on MySQL MEMORY Table
Seems inefficient for larg(er) tables. Thank you for the explanation.
Jul
20
revised Optimizing DELETE Query on MySQL MEMORY Table
added 313 characters in body
Jul
20
awarded  Scholar
Jul
20
awarded  Supporter
Jul
20
accepted Optimizing DELETE Query on MySQL MEMORY Table
Jul
20
comment Optimizing DELETE Query on MySQL MEMORY Table
It is run every 5 minutes, so unfortunately this does not work for us. But thank you for your detailed answer and definitely an alternative if you need to use a memory table (for example, if your disk i/o is slow - in our case we are on a RAID SSD array).
Jul
19
awarded  Student
Jul
19
comment Optimizing DELETE Query on MySQL MEMORY Table
I would think for the time period that these commands are running, it would make the site unusable since the sessions table wouldn't be available. Sort of the same issue we are facing right now.
Jul
19
revised Optimizing DELETE Query on MySQL MEMORY Table
added 112 characters in body
Jul
19
awarded  Editor
Jul
19
revised Optimizing DELETE Query on MySQL MEMORY Table
added 165 characters in body
Jul
19
comment Optimizing DELETE Query on MySQL MEMORY Table
query_cache_limit=1M query_cache_size= 32M query_cache_type = 0 (It is turned off)
Jul
19
awarded  Autobiographer
Jul
19
asked Optimizing DELETE Query on MySQL MEMORY Table