aggressive InnoDB settings

smcnally

Joined: 2007-03-05
Posts: 34
Posted: Mon, 2007-07-09 18:07

Hello -

I've read Performance docs and related info.

I recently updated my.cnf per this article and activated those chnages this AM.

Gallery2 performance seems worse than before.

Is there a glaring omission I've made?

# 070708 - SMc - update to buffer_pool_size; memPool; logfile size; flushLogs
innodb_data_home_dir = /var/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/mysql
innodb_log_arch_dir = /var/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 128M
# innodb_additional_mem_pool_size = 2M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50

I'm happy to share more particulars (my.cnf; php.ini; slow logs) if that would be of use.

Many thanks -


Gallery version = 2.2.1 core 1.2.0.1
PHP version = 5.2.1 apache2handler
Webserver = Apache/2.0.55 (Unix) DAV/2 PHP/5.2.1
Database = mysqlt 5.0.27-log, lock.system=flock
Toolkits = ImageMagick, SquareThumb
Acceleration = full/900, full/900
Operating system = SunOS spardehg02 5.10 Generic_118855-19 i86pc
Default theme = SnapshotV1
gettext = disabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4
Rows in GalleryAccessMap table = 20082
Rows in GalleryAccessSubscriberMap table = 3858
Rows in GalleryUser table = 9700
Rows in GalleryItem table = 3858
Rows in GalleryAlbumItem table = 38
Rows in GalleryCacheMap table = 80379