MySQL Config - Moving from InnoDB + MyISAM to just InnoDB - How to upgrade mySQL 4.0.x to 4.1.x [Archive] - Parallels Helm Forums - polala.com

POLALA.COM
welcome to my space

polala.com

HOME

Homepage

Add to favorites

Welcome to:polala.com

Supplements and Vitamins

Software

Basketball

NAVIGATION: Home >>

MySQL Config - Moving from InnoDB + MyISAM to just InnoDB
Published by: cfz 2009-01-07

How to upgrade mySQL 4.0.x to 4.1.x [Archive] - Parallels Helm Forums::
Data folder ( it will just have to DBs MySQL and Test ) and rename InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and # row data.
http://forums.webhostautomation.com/archive/index.php/t-11157.htmlHOME

Hey,

This is my question. Right now we have our vBulletin database (MyISAM) and our main site database (InnoDB) on one server. The my.cnf looks like this:

[client]
port=3306
socket=/var/lib/mysql/mysql.sock

[mysqld]
port=3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
back_log=75
max_connections=700
key_buffer=512M
myisam_sort_buffer_size=96M
join_buffer_size=4M
read_buffer_size=4M
sort_buffer_size=8M

MediaWiki Installation::
MyISAM databases tend to get corrupted more often than InnoDB databases. Database character set Move the config/LocalSettings.php file to the parent
http://buhaoclub.com/ub_album_2.htmlHOME

mysql.general [Archives] - PHWinfo::
myisam. how to move the data directory? Granting users localhost access. Working with Images Innodb vs myisam. Master - Slave MySQL Database Server. only
http://www.phwinfo.com/forum/archive/index.php/f-421.htmlHOME

table_cache=1800
thread_cache_size=512
wait_timeout=10
connect_timeout=10
tmp_table_size=512M
max_heap_table_size=512M
max_allowed_packet=32M
max_connect_errors=10
read_rnd_buffer_size=1M
bulk_insert_buffer_size=16M
query_cache_limit=18M
query_cache_size=384M
query_cache_type=1
query_prealloc_size=65536
query_alloc_block_size=131072
default-storage-engine=MyISAM
#log-slow-queries
log-error
#low-priority-updates

#innodb_force_recovery=0
innodb_file_per_table
innodb_data_home_dir=/var/lib/mysql/ibdata
innodb_data_file_path=ibdata1:1G:autoextend:max:2G
innodb_buffer_pool_size=6GB

Slicehost Forum - Memory optimisation for Virtual Hosts::
You really need to tweak MySQL as the default config will eat up a 256mb slice. all means run mysql with myisam, turn off innodb and youll have a database that
http://forum.slicehost.com/comments.php?DiscussionID=129HOME

innodb_additional_mem_pool_size=10M
innodb_log_file_size=1GB
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_open_files=300
innodb_status_file
innodb_thread_concurrency=20

[mysqld_safe]
nice=-10
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[myisamchk]
key_buffer=384M
sort_buffer=384M
read_buffer=256M
write_buffer=256M

If we moved the vBulletin database to a separate server, which settings could I modify (or get rid of completely) so that this server would give all of its power to InnoDB?

This is something I have always wondered.

Thanks everyone :)

I see... congrats on your forum's continued growth although the server hardware side does seem to be getting more complex :)

does the main site server handle both apache/php and mysql (innodb) ? How much memory on this main site server ? I think innodb_buffer_pool_size is the big one to look at but you already have 6GB assigned to it.

Remember most of the settings that aren't innodb specific are only put in use if used.. so if you don't have any myisam tables utilised it won't use those resources.

Maybe better to use 2nd server as dedicated mysql database server and use main site server as a web server for multi server setup ?
Thanks for the reply, George :)

The existing database server is already just MySQL. The second database server is just MySQL too. We have separate web servers for Apache/PHP/etc. :)

I think you answered my question... the part about how things are only used if there are tables specifically for that.

Thanks!