Re: getting certain rows from a group by

On Wed, Sep 19, 2012 at 6:56 PM, Rick James rja...@yahoo-inc.com wrote: my counts are 3 times too much. Without studying the code, I would guess that there is a JOIN between he data that needs COUNTing and the GROUP BY for the COUNT. That is, it collects more 'joined' rows before counting.

RE: Making Myself Crazy

below.. -Original Message- From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Wednesday, September 19, 2012 8:59 PM To: mysql@lists.mysql.com Subject: Re: Making Myself Crazy Thanks for your help, Rick! Interspersed are some questions and rationales for you to shoot down...

Re: mysql is eating up lot of CPU and memory

Hey Simon, You just performed the classic, I have an issue, but I won't provide any info. Please elaborate on the issue. Provide hardware spec, config information. Tell us why you suspect the mysqld is consuming too much resource? We can attempt to assist with more info as there are no silver

RE: mysql is eating up lot of CPU and memory

High CPU -- Find the worst query and let's optimize it. SHOW CREATE TABLE SHOW TABLE STATUS EXPLAIN SELECT ... It may be as simple as adding a 'compound' index. Or rewriting a WHERE clause. There are literally hundreds of possible issues and answers. The 3 things above are probably

RE: InnoDB vs. other storage engines

2012/09/19 13:44 -0700, Rick James http://mysql.rjweb.org/doc.php/myisam2innodb Also, InnoDB enforces foreign-key constraints, MyISAM not. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql