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 / FAX

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: Verify User Privileges

2010-05-27 Thread Maurice
On Thu, May 27, 2010 at 7:30 PM, Carlos Mennens wrote: > On Thu, May 27, 2010 at 12:26 PM, win.a 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 s

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 Message---

Re: Verify User Privileges

2010-05-27 Thread Carlos Mennens
On Thu, May 27, 2010 at 12:26 PM, win.a 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 List For list archi

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: 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 w

Re: Slow query using string functions

2010-05-27 Thread Baron Schwartz
Jerry, On Wed, May 26, 2010 at 5:13 PM, Jerry Schwartz 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 accessing many m

Re: slave-net-timeout

2010-05-27 Thread Johan De Meersman
On Thu, May 27, 2010 at 1:43 AM, Jesper Wisborg Krogh wrote: > 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 read or test, I

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