InnoDB losing records, gaps appearing in autoincrement sequence

2003-01-14 Thread My Deja
InnoDB appears to be losing records. The version I am using is 3.32.53 in Windows 2000. Gaps are appearing in the autoincrement sequence when the application does not permit record deletions. Records disappear although they have been retrieved for printing earlier. Does anyone know how this

How does the MySQL shutdown process works.

2003-01-11 Thread My Deja
I'd like to know how MySQL shuts down. Where can I find more about the process, first with mysqladmin shutdown, and when it shuts down as a result of Windows shutting down, eirhter as a service or from the command line or a batch file? With InnoDb I always receive a message about recovering

Re: I need the full list of client options in my.cnf

2003-01-11 Thread My Deja
Where can I find the full list of options which go under the [client] section? ignore this part it is the spam filter bypass (sql,query,queries,smallint) --- [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To

Problems installing additional instances of mysql 4.0.x as a service

2003-01-11 Thread My Deja
I have been trying to install additional instances of mysqld 4.0.x as a service on Windows 2000, but it seems that only one set of parameters. eg. 'mysqld --install connectionname --port=3307 --datadir=c:\mysql\datadir2' does not work but mysqld --install connectionname --port=3307 and

Has anyone managed to get 4.0.8 Win32 working properly?

2003-01-11 Thread My Deja
Has anyone managed to get MySQL 4.0.8 Windows 2000 successfully? I am trying to run it as an additional service. It keeps crashing when I try to access data. sql, query __ Do You Yahoo!? Everything you'll ever need on one web page from News and

Is InnoDB delaying writes or is there a problem with transaction isolation?

2003-01-08 Thread My Deja
InnoDB seems to delaying writes for too long. After adding or deleting records in a table, viewing the results of a query from another application on the same workstation and other workstations does not reflect the changes. It is as though another connections are still being presented with old