Thanks for your reply. Should we move this discussion to
[EMAIL PROTECTED]
Also, notice that unless your application is under _extreme_ load,
none
of these SET queries will are likely to have an impact on the
performance of your application.
I was hoping someone would reply saying that SET
Can you help set me straight?
I recently upgraded from coldfusion 5 to coldfusion mx 7. In the process
I also switched from odbc to jdbc connections to mysql
(4.0.21-nt-max-log).
From looking at the query log, I'm now getting...
SHOW VARIABLES
...once per connection
followed by...
, January 10, 2005 8:55 PM
To: Daniel Gaddis; mysql@lists.mysql.com
Subject: Re: does anyone know of a utility that will processes the query
log to rerun the queries?
Yes. The mysql client is good for this.
I used to restore from disasters this way, eg:
- full backup every night
- transaction log
does anyone know of a utility that will processes the query log to rerun
the queries?
The program would need to...
...strip the leading non query info from the line
...handle queries that span multiple lines
...change databases when appropriate before queries
...add the ; to the end of the
PROTECTED]
Sent: Sunday, January 02, 2005 3:58 AM
To: mysql@lists.mysql.com mysql@lists.mysql.com
Subject: Re: is there a utility like mysqlbinlog but instead processes
the query log?
On 30 Dec 2004, at 13:26, Daniel Gaddis wrote:
is there a utility like mysqlbinlog but instead processes the query
is there a utility like mysqlbinlog but instead processes the query log?
I would like to reprocess the queries from the query log.
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is there a utility like mysqlbinlog but instead processes the query log?
I would like to reprocess the queries from the query log.
additional features that would be nice would include:
listing unique queries
the number of times each unique query is executed
Thanks,
Daniel
--
MySQL
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
This error should be logged. Do you have a file called hostname.err
in your
directory?
Yes I have a file called hostname.err and that error is not in it.
From: Paul DuBois [mailto:[EMAIL PROTECTED]
The error log is for messages pertaining
From: Paul DuBois [mailto:[EMAIL PROTECTED]
I suppose you could consider it such, but on the other hand, it's not
the
sort of error that prevents the server from running or processing
other
queries. In any case, logging it to the error log isn't going to help
the client know what is going
From: Paul DuBois [mailto:[EMAIL PROTECTED]
I don't understand that second sentence, but you can submit
feature requests at http://bugs.mysql.com/
For example, I would like the error log to look something like...
MySQL: ready for connections.
Version: '4.0.18-max-nt-log' socket: '' port:
I copied the following from my coldfusion application.log
Error,2152,03/20/04,09:03:13,,ODBC Error Code = S1000 (General
error)P [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt-log]Incorrect
key file for table: 'referenceEntries'. Try to repair itPP SQL =
UPDATE referenceEntries
I'm running MySql 4.0.10-gamma-max-nt-log
I have 1 table like the one below...
++-+--+
| DAY| USERID | LIS_QUANTITY |
++-+--+
| 2003-01-02 | H0850A1 | 539 |
| 2003-01-02 | LBBSWJR |7 |
| 2003-01-02 |
I have 1 table with 3 fields: date, userid, and a number. I would like an sql query
result with the userid for the first column followed by 1 column for each date and all
corresponding numbers displayed for that userid for that date. Is there a way to do
this using just sql and not php or some
I downloaded MySQL 4.0.3beta on my XP system. I didn't find
mysql_fix_privilege_tables after installing. Am I suppose to pull it
from the unix download and do by hand?
Thanks,
Daniel
-
Before posting, please check:
14 matches
Mail list logo
