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]