Innodb buffer pool allocation on Window 2000
I have a Windows 2000 host with 3.5 G of ram. I have configured MySQL 4.1.14 with innodb_buffer_pool = 1024M, when I start mysqld I get the following error: 051013 16:46:00 InnoDB: Error: cannot allocate 1073758208 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 16975556 bytes. Operating system errno: 8 InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We keep retrying the allocation for 60 seconds... InnoDB: Fatal error: cannot allocate the memory for the buffer pool 051013 16:47:00 [ERROR] Can't init databases 051013 16:47:00 [ERROR] Aborting 051013 16:47:01 [Note] C:\Program Files\MySQL\bin\mysqld: Shutdown complete If I lower the value to 512M it comes up ok. Not being an in depth Windows admin, What do I look for in the registry or elsewhere to allow MySQL to have a 1024M innodb_buffer_pool? Thanks, Jo
Innodb open files issue
Hi, I have mysql 4.1.14 on solaris 9 and have just switched to using the innodb_file_per_table option. Previously I was using MyISAM tables and created about 700 tables. The rlim_fd_cur and rlim_fd_max kernel paramteres are set to 256. I'm getting an error from innodb that it is running out of file descriptors. I did not get this when using MyISAM tables. Does the innodb not use the table cache when innodb_file_per_table is set? Where is this documented? thanks, Jo
RE: Lock wait timeout exceeded
Thanks for the help. I finally got to the bottom of the problem. It seems that on Windows, by default, if the network cable is momentarily disconnected, Windows shuts down all TCP connection within the box and basically disables the the network interface. However the MySQL server running on another host (or any other server for that matter) is blissfully unaware that this has happened so the MySQL Server end of the connection continues to hold the X lock on the record (remember I'm using innodb tables). When the network cable gets reinserted the interface comes back up. However when you rerun the application it will get 1205 errors when it tries to do the same work as the orphaned MySQL server connection is still holding the X lock. The only way out of this is to kill the orphaned session. The issue with windows is described here: http://www.support.microsoft.com/default.aspx?scid=kb;en-us;239924 However similar problems will occur if a client host crashed (loss of power etc). Any suggestions as to how to mitigate this? Jo -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 04, 2005 1:33 AM To: mysql@lists.mysql.com Subject: Re: Lock wait timeout exceeded Hello. Any ideas where to go with this? How can I find out which session is holding the lock and what lock it is? SHOW INNODB STATUS and, probably, SHOW PROCESSLIST can give you some additional information about what's going on. Use: show variables like 'tx_isolation'; to find out the transaction isolation level. See: http://dev.mysql.com/doc/mysql/en/InnoDB_Monitor.html http://dev.mysql.com/doc/mysql/en/show-processlist.html Jonathan Stockley [EMAIL PROTECTED] wrote: Hi, We're having a problem with lock wait timeout exceeded errors. We are exclusively using innodb tables apart from the mysql database. The problem seems to be with the way we are simulating sequences. There is a table called SEQUENCES defined as follows: CREATE TABLE IF NOT EXISTS Sequences ( tableName VARCHAR(64) NOT NULL PRIMARY KEY, id INTEGER UNSIGNED NOT NULL ) We then generate the next number for a given table as follows: UPDATE Sequences SET id=LAST_INSERT_ID(id+1) WHERE tableName = 'THE_TABLE_NAME' There are several hundred rows in the Sequences table. The general flow is that for each row or set of rows to be inserted we do the following: (AUTOCOMMIT is turned OFF). 1. begin transaction 2. get next sequence number for given target table using above UPDATE statement. 3. insert row into target table 4. if more rows to insert go to step 2 5. commit transaction We are not using LOCK TABLE anywhere and we are using the default transaction isolation level which I believe is READ-COMMITED. Every so often we get the 1205 error lock wait timeout exceeded. Any ideas where to go with this? How can I find out which session is holding the lock and what lock it is? Thanks, J -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lock wait timeout exceeded
Hi, We're having a problem with lock wait timeout exceeded errors. We are exclusively using innodb tables apart from the mysql database. The problem seems to be with the way we are simulating sequences. There is a table called SEQUENCES defined as follows: CREATE TABLE IF NOT EXISTS Sequences ( tableName VARCHAR(64) NOT NULL PRIMARY KEY, id INTEGER UNSIGNED NOT NULL ) We then generate the next number for a given table as follows: UPDATE Sequences SET id=LAST_INSERT_ID(id+1) WHERE tableName = 'THE_TABLE_NAME' There are several hundred rows in the Sequences table. The general flow is that for each row or set of rows to be inserted we do the following: (AUTOCOMMIT is turned OFF). 1. begin transaction 2. get next sequence number for given target table using above UPDATE statement. 3. insert row into target table 4. if more rows to insert go to step 2 5. commit transaction We are not using LOCK TABLE anywhere and we are using the default transaction isolation level which I believe is READ-COMMITED. Every so often we get the 1205 error lock wait timeout exceeded. Any ideas where to go with this? How can I find out which session is holding the lock and what lock it is? Thanks, Jo
4.1.10a packaging for Solaris
I just downloaded the 4.1.10a release for Solaris 8 and 9 (32bit). It seems that it is no longer in a tar archive. Was this change intentional? I cant find any mention of it on the web site. How do I unpack the new format into a given directory? Thanks, Jo
Build of HPUX-11 client library with +z
Hi, I have a change request. Could you add the +z (or +Z) flag to the compile flags of the standard static mysql client library (libmysqlclient.a) on HPUX. I am building a shared library in my application and it links with libmysqlclient.a. However, on HPUX I have to build my own version of libmysqlclient.a with the +z flag so that it has position independent code (PIC). Note, I'm not requesting a shared mysql client library, just that you add this one flag to the build of the static library. Thanks, Jo
please rename dbug.h
Hi, I've hit a problem on AIX 4.3 with mysql client include files. My app needs to include xcoff.h which includes dbug.h. The problem is that I also need to access mysql. It turns out that the mysql include directory also has a dbug.h which get pulled in instead of the systems file. The fix is simple, rename the mysql dbug.h to my_dbug.h and change the include in my_global.h to #include my_dbug.h instead. Rather than my having to fix this with every new mysql release I download, could you please consider making this change in the master codelines? (ideally it would be nice if you prefixed all your header files with my_to avoid future clashes with system header files) Thanks, muchly. Jo sql, query - 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
download problems for MySQL 3.23.53a HP-UX
Hi, I have two problems. 1. The link for downloading MySQL 3.23.53a HP-UX 11.11 is incorrect, it points to the 10.20 download. 2. The download says MySQL 3.23.53a HP-UX 11.11 but I need support for HP-UX 11.00 with the 11.11 port work on 11.00 or am I out of luck? Cheers, Jo Oh yeah, sql, query - 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
Help sending to the lists
Hi, I'm being forced to use MS Outlook/MS Exchange to to all my email at work and I cant seem to send mail to the mysql list. The list managert doesn't allow attachments but for some reason Exchange or Outlook seem to insist on send out the email as plain text AND html as MIME attachments. Has anyone any idea how to stop this? I've tried everything in Outlook to select Plain Text and nothing seems to help. Note this is not Outlook Express Any ideas? Cheers Jo - 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