MySQL 4.0.13-nt-log --Help

attempts to reconnect are unsuccessful; when I restart the computer, mysql starts fine. What could the problem? Is it to do with my program or mysql itself? 2) How do I find out when mysql stopped and the cause? where can I find the log file if there is? Thanks. Emmanuel

RE: Stop query on first match

ilesort order, which means > that multiple rows will be looked at unless your > between matches the first row inserted, except if you > have an appropriate index. Please see previous post. Justin, again, thank you for your asistance. Kind regrds Emmanuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Stop query on first match

Hello all, Thank you to everyone who assisted me. I'm wondering about my theory around the between as posted previously. Can anyone provide further insights regarding that theory? Kind regards Emmanuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

RE: Stop query on first match

ld help us help you if you at least posted the query and > the results > of EXPLAIN. It would probably also help if you told us more about the > tables, perhaps with SHOW CREATE TABLE. If above does not help you, I'll bring the whole lot to the post. Michael, again thank you for you assistance. Kind regards Emmanuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Stop query on first match

On Monday, June 07, 2004 07:54, Jeff Smelser wrote; > On Monday 07 June 2004 12:49 am, Emmanuel van der Meulen wrote: > > I've looked in several books and searched Google but cannot get a way of > > doing this. It seems Oracle has a 'FIRST' in their select >

RE: Production release of MySql 4.1

Daniel Kasak wrote on Tuesday, June 08, 2004 00:38; > Emmanuel van der Meulen wrote: > > >Hello all, > > > >Does anyone have an estimate of when MySql 4.1 will be released for > >production. > > > >MySql.cm says soon. > > > >Please advise,

Production release of MySql 4.1

Hello all, Does anyone have an estimate of when MySql 4.1 will be released for production. MySql.cm says soon. Please advise, would that likely be weeks/months? Kind regards Emmanuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Stop query on first match

It seems Oracle has a 'FIRST' in their select which they use for such a use case. But I do not see anything for MySql anywhere. Could someone please assist me. Kind regards Emmanuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

subqurey syntax error

gt; I am using MySQL version 4.0.17, on windows xp professional. Has anyone encountered this problem before? Please help. Emmanuel Ohannessian

Can't set timeout on MyODBC/MySQL from an ADO/ASP program on Windows XP?

dset.EOF = "+objRecordset.EOF+""); %> Nothing works... Has anybody ever tried this? Am I the only one with this problem? Is there any known solution to that problem? Note: I tried this on a Windows XP SP1 box as well as on a Windows 2000 Server SP3, with MySQL 4.0.12 and My

PB to retrieve ID

but I always got 0 for it. What's wrong ? Should I put a commit command i the code ? Thanks -- Cordialement ~~ Emmanuel POIZOT CNAM/INTECHMER B.P. 324 50103 CHERBOURG Cedex Tél : (33)(0)2 33 88 73 42 Fax : (33)(0)2 3

Warning message with MySQL++ API

: pasting "sql_COMPARE__0" and "(" does not give a valid preprocessing token etc Does anyboby have an idear of how to resolve this ? -- Cordialement. Emmanuel POIZOT CNAM/INTECHMER B.P. 324 50103 Cherbourg Cedex Tèl : 33 (0)2 33 88 73 42 Fax : 33 (0)

How to install MySql++ patch

Hi, I download a Mysql++ patch for MySQL 1.7 version to allows compiling with 3.* GNU compiler series. The problem is that I don't know how to install the patch file. Can anyone help me ? Thanks -- Emmanuel POIZOT CNAM/INTECHMER B.P. 324 50103 Cher

g++ 2.96 with Mysql++ 1.7.9

tried patch -pl < patchfile but asked me a strip count. What does it means and how can I use my compiler to compile my code ? Thanks -- ~~~~ Emmanuel POIZOT CNAM/INTECHMER B.P. 324 50103 Cherbourg Cedex Tèl : 33 (0)2 33 88 73 42 Fax : 3

Database not founded

ySQL process is up, but it seems to don't have database any more. Does anybody had this kind of problem ? Do you see a solution ? (I don't have any error in the mysql.log nor in the system log) Thanks a lot. Emmanuel --

RE: Understanding throughput with JDBC

Hello Monty, With your help I'm getting the understanding I was looking for, thank you. On 27 January 2002 23:23, Michael Widenius wrote; > Hi! > > >>>>> "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]> writes: > > > > >>

RE: MySQL 3.23.46 -> 4.01

Hello all, Oops, I overlooked to change the my.cnf. All is working 100% Thank you. However, please advise whether I can run 3.23 and 4.0.1 interchanging on same data without putting the data at risk? BTW, I use InnoDb. Kind regards Emmanuel > -Original Message- > From: Em

RE: Understanding throughput with JDBC

127.0.0.1 | +--+-+---+-- -+-- --+--+--+---+--- ---+ -+-+---+---+ +--+--+---+---++---+ 1 row in set (16.95 sec) mysql> Please advise? Kind rega

MySQL 3.23.46 -> 4.01

C until I have 4.0.1 working. Seems I can't. Did I have to first uninstall 3.23.46 before installing 4.0.1? Thank you for any assistance. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.p

Manuals status

downloaded pdf manual relates to one another? Kind reagrds Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

Overwhelmed with MySQL & People

Hello all, I've been with MySQL for approx. a month now and have asked assistance with several things, and; I'm overwhelmed and acknowledge MySQl and the people of the mailing lists. Thank you. Kind regards Emmanuel --

RE: Understanding throughput with JDBC

ind / work out how to use it with JDBC. It would be great to do only one query, which means the processing would be reduced from approx. 25 to 4 seconds. I'd say, that is a great reduction. Kind regards Emmanuel > -Original Message- > From: Michael Widenius [mailto:[EMAIL P

RE: Understanding throughput with JDBC

Hello Dave, Thank you. This works. Kind regards Emmanuel > -Original Message- > From: Adrian Monea [mailto:[EMAIL PROTECTED]] > Sent: 20 January 2002 15:08 > To: 'Emmanuel van der Meulen' > Cc: [EMAIL PROTECTED] > Subject: RE: Understanding throughput with

RE: [OT] Re: Understanding throughput with JDBC

Hello Nick, Does ROWNUM exist in MySQL? Kind reagrds Emmanuel > -Original Message- > From: Nick [mailto:[EMAIL PROTECTED]] > Sent: 19 January 2002 20:41 > To: Shankar Unni > Cc: [EMAIL PROTECTED] > Subject: [OT] Re: Understanding throughput with JDBC > > >

RE: Understanding throughput with JDBC

ACKING ORDER BY ACTIVITYTIMESTAMP DESC) thus get all the rows, ordered desc on timestamp and then I have the most recent 50 inserts. If anyone could assist me with this, I'd use other means, rather than retrieving the full resultset. Kind regards Emmanuel > -Original Message- > From:

RE: Understanding throughput with JDBC

ACKING ORDER BY ACTIVITYTIMESTAMP DESC) thus get all the rows, ordered desc on timestamp and then I have the most recent 50 inserts. If anyone could assist me with this, I'd use other means, rather than retrieving the full resultset. Kind regards Emmanuel > -Original Message- > F

RE: Version 4 Schedule RE: Roadmap

Hello Jeremy, Thank you for keeping correspondence. Kind regards Emmanuel > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: 20 January 2002 08:22 > To: Emmanuel van der Meulen > Cc: [EMAIL PROTECTED] > Subject: Re: Version 4 Schedule RE

Understanding throughput with JDBC

ram gets control back, to create the resultset, takes 23-25 seconds; I ran program several times. Please advise whether this is to be expected, or whether I could alter anything to get comparable results via JDBC as with MySQL 'commandline'? Kind regards Emmanuel --

RE: Version 4 Schedule RE: Roadmap

Hello all, On 19 January 2002 09:28, Jeremy Zawodny wrote; > > On Sat, Jan 19, 2002 at 09:22:38AM +0200, Emmanuel van der Meulen wrote: > > Hello all, > > > > To both above topics there have been answers, thank you, but these > > answers are not clear at all. &g

RE: Version 4 Schedule RE: Roadmap

t; > As Monty recently mentioned: if you mean "stable" as "well tested > and suitable for production uses" - this is true for almost every > MySQL version, even for alpha > ones. :-) Again this talks about the stability and approach, not the timing. ---

Roadmap

Hello all, Is there a roadmap for MySQL releases, and in particular when it the eta for 4.1? Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: Jeremy's MySQL Book

Hello all, Please advise location of the toc. Kind reagrds Emmanuel > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: 10 January 2002 16:59 > To: Rick Emery > Cc: '[EMAIL PROTECTED]' > Subject: Re: Jeremy's MySQL Book &g

Re: Java Related Sites for MySQL

Hello all, www.infinitehost.com Kind regards Emmanuel > Same Here! Bryan! Do let me know if you find one. > > > - Original Message - > From: "Aravind N V Gorthy" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, January 11, 2002

RE: Multiples instances of MySQL

Hello Martin, Yes, in the meantime, this has been confirmed as a problem with Windows/MySQL. I'm enquiring about a remedy. BTW, I removed the socket option, but still same anomaly. Kind regards Emmanuel > -Original Message- > From: Martin Waite [mailto:[EMAIL PROTECTED]]

RE: Multiples instances of MySQL

--- Can you maybe see something causing the shutdown anomaly? Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Multiples instances of MySQL

of -P, but still the first instance shuts down. I'm running on Win2K Pro. Is there a different way for Windows? Please advise any further pointers? Kind regards and all the best for 2002! Emmanuel - Before posting, plea

Re: Multiples instances of MySQL

ly for any assistance. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL P

RE: General database questions

Hello Roger; [snip] > * Emmanuel van der Meulen > > I'm certain InnoDB is 100% safe. My concern is probably > related to being > > unfamiliar with MySQL/InnoDB. However, I take Heikki's point of > > the access impact of DEV on PROD - never thought of tha

Re: Multiples instances of MySQL

elpful that you gave me that pointer. Either way thank you again for an excellent feature and also for your clear assistance. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the

RE: General database questions

So all is exactly as per my requirements. Until another time. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To r

RE: General database questions

your clear assistance. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

Re: Multiples instances of MySQL

27;m going wrong; is this possibly a version 4.0.1 option. I'm using, 3.23.46-max. I also looked at 4.7.3, cannot figure out where and how to use mysqld# outside the my.cnf options file. Tony, could you please point m

RE: General database questions

x27; (or multiple, > possibly spanning multiple disks) sharing multiple databases, and one (or > more) disks with separate databases in separate files. The database > partition can be seen as a kind of filesystem... [snip-

Multiples instances of MySQL

Hello all, Could someone please advise, what is the procedure to start and run more than one instance of MySQL? Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: General database questions

Hello Roger, Thank you for your note and feedback. With your assistance and reading up on InnoDB, I'm getting closer. Further inline; On 29 December 2001 22:21, Roger Baklund wrote; [snip-1] > I think you would need to restart the mysqld server daemon, but > this is very > fast, and can be

RE: General database questions

Hello Roger, Thank you for your note and replies. Please see my further points inline; On 29 December 2001 16:21, Roger Baklund wrote; > * Emmanuel van der Meulen > > 1. Assuming the website grows very large with high volumes and > a database > > exceeds disk space, please

General database questions

tables or the innodb files? 4. Please advise, with different databases do they all share one set of innodb files - thus if this is the case, how is data for different databases backed up separately? Over to you. Kind regards Emmanuel ---

Several general questions

tables or the innodb files? 4. Please advise, with different databases do they all share one set of innodb files - thus if this is the case, how is data for different databases backed up separately? Over to you. Kind regards Emmanuel ---

Installing mysql-3.23.40 on Solaris 2.6

ins : what has to be replaced in the mysql directory ? Only the executables un mysql/bin or more ? Many thanks for your help. -- Emmanuel. - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht