Adjustment Mysql

[INDIGO]

How it is better to optimise options Mysql for optimum work of a server?

OS Ubuntu 9.04
CPU C2D 3Hz
RAM 4G

[JavierDC]

I'm using this configuration without any problem.

español
esta configuración estoy usando, sin ningún problema.

Code: Select all

[client]port=3306 [mysql]default-character-set=latin1 [mysqld]port=3306basedir="C:/Program Files/MySQL/MySQL Server 5.1/"datadir="C:/Program Files/MySQL/MySQL Server 5.1/Data/"default-character-set=latin1default-storage-engine=INNODBsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"max_connections=300table_cache=3000 query_cache_size=350Mquery_cache_type=1query_cache_limit=512k #posible que no hacen faltatmp_table_size=0M#max_heap_table_size=512M thread_cache_size=2048log_slow_queriesmemlock #probar esto, antes 14400wait_timeout =3600interactive_timeout=3600  query_prealloc_size=16k #*** MyISAM Specific optionsmyisam_max_sort_file_size=100Gmyisam_max_extra_sort_file_size=100Gmyisam_sort_buffer_size=30Mkey_buffer_size=350Mread_buffer_size=64Kread_rnd_buffer_size=256Ksort_buffer_size=256k #*** INNODB Specific options ***innodb_data_home_dir="C:/MySQL Datafiles/"#skip-innodbinnodb_additional_mem_pool_size=6Minnodb_flush_log_at_trx_commit=1innodb_log_buffer_size=3Minnodb_buffer_pool_size=350Minnodb_log_file_size=50Minnodb_thread_concurrency=8innodb_lock_wait_timeout =50innodb_file_per_tableinnodb_open_files=2400

[INDIGO]

What configuration of your computer?
Thanks.

[Gnacik]

How it is better to optimise options Mysql for optimum work of a server?

Use http://blog.mysqltuner.com/ to optimize your database. Very nice tool.

[Sirpaypi]

How it is better to optimise options Mysql for optimum work of a server?

Use http://blog.mysqltuner.com/ to optimize your database. Very nice tool.

Dead link fix it please, want to try this..

[JavierDC]

What configuration of your computer?
Thanks.

yes, it is my server configuration. in window 2003, but you can serve many parameters for linux

[Gnacik]

Dead link fix it please, want to try this..

They have some problem with WP. If you use linux just write in console:

Code: Select all

wget mysqltuner.pl

if you use windows download and save script to disc.

[mr.karrde]

Or http://github.com/rackerhacker/MySQLTuner-perl

if you use windows download and save script to disc.

...
* Windows is not supported at this time
...