Innodb buffer pool allocation on Window 2000

2005-10-17 Thread Jonathan Stockley
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 open files issue

2005-10-13 Thread Jonathan Stockley
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

RE: Lock wait timeout exceeded

2005-10-05 Thread Jonathan Stockley
'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

Lock wait timeout exceeded

2005-10-03 Thread Jonathan Stockley
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

4.1.10a packaging for Solaris

2005-03-16 Thread Jonathan Stockley
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

2005-01-17 Thread Jonathan Stockley
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

please rename dbug.h

2003-03-14 Thread Jonathan Stockley
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

download problems for MySQL 3.23.53a HP-UX

2002-12-10 Thread Jonathan Stockley
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,

Help sending to the lists

2002-11-08 Thread Jonathan Stockley
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