statistics statement in general log

Hi guys, anyone knows what's the meaning of "statistics" in general log ? thanks. ... 100908  9:40:11 21513 Statistics 100908  9:40:14 21518 Statistics 100908  9:40:19 21518 Statistics 100908  9:40:21 21513 Statistics 100908  9:40:24 21518 Statistics 100908  9:40:29 21518 Statistics 100908  9:40:31

Re: Does putting a LIMIT on a DELETE clause make any difference?

Vincent, Since the column is indexed, it would use the index during the delete. regards anandkl On Thu, Sep 9, 2010 at 5:47 AM, Daevid Vincent wrote: > I am curious about something. > > I have a "glue" or "hanging" table like so: > > CREATE TABLE `fault_impact_has_fault_system_impact` ( > `id

Does putting a LIMIT on a DELETE clause make any difference?

I am curious about something. I have a "glue" or "hanging" table like so: CREATE TABLE `fault_impact_has_fault_system_impact` ( `id_fault_impact` int(10) unsigned NOT NULL, `id_fault_system_impact` smallint(5) unsigned NOT NULL, KEY `fault_impact_key` (`id_fault_impact`,`id_fault_system_imp

Re: Replaying the mysqld.log file from production onto QA???

Try using a mysqldump. - Reply message - From: "ext Nunzio Daveri" Date: Wed, Sep 8, 2010 19:25 Subject: Replaying the mysqld.log file from production onto QA??? To: "mysql@lists.mysql.com" Hello all, I am trying to "REPLAY" the mysqld.log file from a production 5.1.4 server onto a QA s

Replaying the mysqld.log file from production onto QA???

Hello all, I am trying to "REPLAY" the mysqld.log file from a production 5.1.4 server onto a QA server with 5.5 running and was wondering if there is an easy way of replaying the mysqld.log file? Just want to make sure all of the kinds of inserts, updates, selects and deletes work just as well

Query SUM help

Hi I've the following query : SELECT total_team_rating, my_teams_id FROM (SELECT players.teams_id AS my_teams_id, SUM(players_master.rating) AS total_team_rating FROM players INNER JOIN players_master ON players.players_id = players_master.players_id WHERE players.worlds_id = 1 AND players.red_ca

Re: mysqldump error 1064 for database Use command

I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the dump remotely from a Linux box. Regards, Nitin From: Manasi Save To: win.a Cc: "mysql@lists.mysql.com" Sent: Wed, September 8, 2010 3:57:40 PM Subject: Re: mysqldump error 1064 fo

Re: mysqldump error 1064 for database Use command

Hi win.a,   I tried with another user the problem still persists. I am getting same error for another user as well. -- Regards, Manasi Save On Tue, 7 Sep 2010 11:41:35 0800, "win.a" wrote: use another user and dump the data ,eg the root . > mysqldump -uroot -p --al-databases >AllNew_Databa