I can alloc 14GB to innodb_buffer_pool_size, even 15GB on my 16GB system. However I used mysql6.0, not mysql5.0. Maybe you can try newer mysql version.
Thx, Xuekun On 7/24/08, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi, > U can use max of 80% of your Memory to Mysql, as OS needs the remaning. > Also you can exclude Myisam parameter like key_buffer, as this i only > INNODB. > > > On 7/24/08, Dominik Klein <[EMAIL PROTECTED]> wrote: > > > > Hi > > > > I installed a 64bit Linux and compiled and installed 5.0.51b. This is to be > > an innodb only system. > > > > The machine has 16 GB of memory and I can see all of that with "free". > > Except for mysql, there is nothing running on that system. > > > > free -m > > total used free shared buffers cached > > Mem: 16071 182 15888 0 10 51 > > -/+ buffers/cache: 120 15951 > > Swap: 2055 0 2055 > > > > So according to the performance blog and the mysql manual, I tried to > > configure innodb_buffer_pool_size to 14 GB. > > > > But mysql does not start and reports > > 080724 13:29:30 mysqld started > > 080724 13:29:30 InnoDB: Error: cannot allocate 652288000 bytes of > > InnoDB: memory with malloc! Total allocated memory > > InnoDB: by InnoDB 14917625712 bytes. Operating system errno: 12 > > 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: Note that in most 32-bit computers the process > > InnoDB: memory space is limited to 2 GB or 4 GB. > > InnoDB: We keep retrying the allocation for 60 seconds... > > > > Lowering the configuration value in 1GB steps to 11 GB starts the server up > > okay, but I guess I could use more. What's going on? > > > > Here's my.cnf > > > > [client] > > port = 3306 > > socket = /tmp/mysql-test.sock > > [mysqld] > > port = 3306 > > socket = /tmp/mysql-test.sock > > skip-locking > > key_buffer = 10M > > max_allowed_packet = 128M > > table_cache = 256 > > sort_buffer_size = 4M > > net_buffer_length = 8K > > read_buffer_size = 1M > > read_rnd_buffer_size = 512K > > myisam_sort_buffer_size = 8M > > auto_increment_increment=2 > > auto_increment_offset=1 > > skip-name-resolve > > max_connections=600 > > old-passwords > > default-storage-engine=innodb > > default-table-type=innodb > > log-bin=binlog/mysql-bin > > log-slave-updates > > relay-log=JBOSS03-relay-bin > > long-query-time=1 > > log-slow-queries > > log-queries-not-using-indexes > > server-id = 5012 > > innodb_buffer_pool_size = 11000M > > innodb_additional_mem_pool_size = 200M > > innodb_log_file_size = 1000M > > innodb_log_buffer_size = 24M > > innodb_flush_log_at_trx_commit = 1 > > innodb_lock_wait_timeout = 50 > > innodb_file_per_table > > innodb_flush_method=O_DIRECT > > [mysqldump] > > quick > > max_allowed_packet = 16M > > [mysql] > > no-auto-rehash > > [isamchk] > > key_buffer = 20M > > sort_buffer_size = 20M > > read_buffer = 2M > > write_buffer = 2M > > [myisamchk] > > key_buffer = 20M > > sort_buffer_size = 20M > > read_buffer = 2M > > write_buffer = 2M > > [mysqlhotcopy] > > interactive-timeout > > > > Regards > > Dominik > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
