InnoDB losing records, gaps appearing in autoincrement sequence
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 problem can be fixed? I am checking the application code to see if records can be deleted, either deliberately or accidentally. Has anyone come across such a problem? (sql,query,database,odbc - spam block bypass) __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Has anyone managed to get 4.0.8 Win32 working properly?
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 Sport to Email and Music Charts http://uk.my.yahoo.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems installing additional instances of mysql 4.0.x as a service
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 mysqld --install connectionname --datadir=c:\mysql\datadir2 Is this a bug? I am going to pass a customised options file --defaults-file=c:/mydefaults to see if that will work. However I would prefer most of it to be on the command line. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I need the full list of client options in my.cnf
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 bypass the filter > you must include > one of the following words in your message: > > sql,query,queries,smallint > > If you just reply to this message, and include the > entire text of it in the > reply, your reply will go through. However, you > should > first review the text of the message to make sure it > has something to do > with MySQL. Just typing the word MySQL once will be > sufficient, for example. > > You have written the following: > > > Where can I find the full list of options which go > under the [client] section? > > __ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How does the MySQL shutdown process works.
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 when InnoDB starts. This is from a batch file in the Start Menu and it seems that MySQL does not shutdown properly when Windows is shutdown. Is there a mechanism for getting MySQL to shutdown properly when Windows is shutdown, besides using mysqladmin shutdown? I am now running MySQL as a service on Win2000, are there errors on shutdown I do not see, or does the service method shutdown smoothly? __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is InnoDB delaying writes or is there a problem with transaction isolation?
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 snapshots. Even restarting the other applications, thus creating new connections does not show the updates. The connections are all set to autocommit. They show up eventually, but the time delay which in some cases has been over 15 minutes which is too much. I have checked the application code to ensure that data refreshes actually close and reopen the queries. I am using MySQL 3.23.51 on Windows 2000 and the library is ZeosLib MySQL components. Is there a way to force writes to make them immediately visible to other connections? __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php