Re: Slow query using string functions

2010-05-27 Thread Joerg Bruehe
Hi! Jerry Schwartz wrote: I have a pretty simple query that seems to take a lot longer than it ought to (over 2 minutes). [[...]] SELECT feed_new.new_title AS `New Title FROM Feed`, prod.prod_pub_prod_id AS `Lib Code FROM DB`, prod.prod_title AS `Title FROM DB`,

Re: slave-net-timeout

2010-05-27 Thread Johan De Meersman
On Thu, May 27, 2010 at 1:43 AM, Jesper Wisborg Krogh jes...@noggin.com.auwrote: E.g. setting slave_net_timeout to 180 seconds, then an event that takes 240 seconds to transfer will never make it through. The replication will make it 75% through and then start all over. Without bothering to

Re: Slow query using string functions

2010-05-27 Thread Baron Schwartz
Jerry, On Wed, May 26, 2010 at 5:13 PM, Jerry Schwartz je...@gii.co.jp wrote: I have a pretty simple query that seems to take a lot longer than it ought to (over 2 minutes). I suspect that if you watch Handler_ stats, you'll find that the EXPLAIN estimate is wrong for some reason and it's

RE: Slow query using string functions

2010-05-27 Thread Jerry Schwartz
-Original Message- From: Gavin Towey [mailto:gto...@ffn.com] Sent: Wednesday, May 26, 2010 7:39 PM To: je...@gii.co.jp; mysql@lists.mysql.com Subject: RE: Slow query using string functions Jerry, Are you sure this is really your explain plan for this query? That's not at all what I

Verify User Privileges

2010-05-27 Thread Carlos Mennens
I would like to know how I can verify what privileges have been granted to a specific user on MySQL. I don't remember if my user 'carlos' has specific privileges on 'mydb' database. I am sure I could simply re-run the following command: GRANT ALL PRIVILEGES ON mydb.* TO 'carlos'@'localhost' -

Re: Verify User Privileges

2010-05-27 Thread Carlos Mennens
On Thu, May 27, 2010 at 12:26 PM, win.a win@gmail.com wrote: Maybe phpmyadmin is a choice No I am only allowed to have MySQL installed. No GUI for DBA. I am sure there is a way to verify the privileges via CLI, I just can't locate it on the site / documentation. -- MySQL General Mailing

RE: Verify User Privileges

2010-05-27 Thread Rolando Edwards
SHOW GRANTS FOR 'carlos'@'localhost'; Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original

Re: Verify User Privileges

2010-05-27 Thread Maurice
On Thu, May 27, 2010 at 7:30 PM, Carlos Mennens carlosw...@gmail.comwrote: On Thu, May 27, 2010 at 12:26 PM, win.a win@gmail.com wrote: Maybe phpmyadmin is a choice No I am only allowed to have MySQL installed. No GUI for DBA. I am sure there is a way to verify the privileges via CLI, I

RE: Verify User Privileges

2010-05-27 Thread Rolando Edwards
If you do not have certain rights, then just do SHOW GRANTS; Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards

RE: Slow query using string functions

2010-05-27 Thread Jerry Schwartz
I haven't had a chance to try that, and this might be totally useless information, but to create a clone of the bigger table (CREATE LIKE and INSERT INTO) takes about 12 seconds. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 /