vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I've have a MySQL server with APACHE Server in a windows 2003 server enviroment. My HardWare is: 4x CPU XEON 4 GB of RAM How can I configure MySQL to use 3GB of RAM in order to let APACHE to use 1 GB? My DB (270) are Mambo/Joomla with MyISAM tables and only ONE INNODB Tables. Thanks This is my INI. max_connections=800 query_cache_size=84M table_cache=1520 tmp_table_size=30M thread_cache_size=38 *** MyISAM Specific options myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=30M key_buffer_size=129M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K #*** INNODB Specific options *** innodb_additional_mem_pool_size=6M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=3M innodb_buffer_pool_size=512M innodb_log_file_size=50M innodb_thread_concurrency=10 |