RE: Is SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED applicable to MyISAM tables?

2005-07-14 Thread Daniel Gaddis
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

Is SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED applicable to MyISAM tables?

2005-07-07 Thread Daniel Gaddis
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...

RE: does anyone know of a utility that will processes the query log to rerun the queries?

2005-01-11 Thread Daniel Gaddis
onday, 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 - transactio

does anyone know of a utility that will processes the query log to rerun the queries?

2005-01-10 Thread Daniel Gaddis
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 query

RE: is there a utility like mysqlbinlog but instead processes the query log?

2005-01-03 Thread Daniel Gaddis
PROTECTED] Sent: Sunday, January 02, 2005 3:58 AM To: 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 > log? > I would like to repr

is there a utility like mysqlbinlog but instead processes the query log?

2004-12-30 Thread Daniel Gaddis
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?

2004-12-28 Thread Daniel Gaddis
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 Gen

RE: Should there be an entry in the mysql error log?

2004-03-24 Thread Daniel Gaddis
> 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

RE: Should there be an entry in the mysql error log?

2004-03-24 Thread Daniel Gaddis
> 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 go

RE: Should there be an entry in the mysql error log?

2004-03-24 Thread Daniel Gaddis
> From: Victor Pendleton [mailto:[EMAIL PROTECTED] > This error should be logged. Do you have a file called .err in your directory? Yes I have a file called .err and that error is not in it. > From: Paul DuBois [mailto:[EMAIL PROTECTED] > The error log is for messages pertaining to problems

Should there be an entry in the mysql error log?

2004-03-22 Thread Daniel Gaddis
I copied the following from my coldfusion application.log "Error","2152","03/20/04","09:03:13",,"ODBC Error Code = S1000 (General error) [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt-log]Incorrect key file for table: 'referenceEntries'. Try to repair it SQL = ""UPDATE referenceEntries

Paul, do you address this in any of your books?

2003-03-14 Thread DANIEL GADDIS
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 | O0

I want sql query result with userid 1st col followed by 1colum for each date & all corresp numbers

2003-03-13 Thread DANIEL GADDIS
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

MySQL 4.0.3beta on XP...didn't find mysql_fix_privilege_tablesafter install, pull unix download?

2002-09-23 Thread DANIEL GADDIS
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: http://