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] > >
