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`,
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
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
-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
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'
-
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
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
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
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
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 /
10 matches
Mail list logo