|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hello, Today i purchased and moved my MySQL server to a new server only for MySQL, all works good but it's slow. I'm using the private network of my provider to connect between the servers, so the problem isn't from this. I think that i need some tweaking on my.cnf: Code: [mysqld] skip-name-resolve set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql safe-show-database old_passwords back_log = 50 max_connections = 500 key_buffer_size = 144M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 4000 thread_cache_size = 384 wait_timeout = 30 connect_timeout = 10 tmp_table_size = 128M max_heap_table_size = 128M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 100000 thread_concurrency = 8 concurrent_insert = 2 table_lock_wait_timeout = 30 read_rnd_buffer_size = 1M bulk_insert_buffer_size = 8M query_cache_limit = 4M query_cache_size = 96M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM max_write_lock_count = 8 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid nice = -5 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 256M sort_buffer = 64M read_buffer = 16M write_buffer = 16M This my.cnf is the file using in the server with httpd and MySQL and it worked very good, there are any change that i can do for better performance for a remote MySQL? Thanks!!! __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Configure mysql on dedicated server | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 03-17-2010 05:30 PM |
Busy site needs server expansion: another dedicated server or cloud / hybrid hosting? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 12-21-2009 06:13 AM |
Server Optimization Requst - Moved to new server | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 08-02-2009 10:30 AM |
Server specs for dedicated virtual server (self hosted) - input appreciated | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-26-2009 12:00 PM |
Intermittent 'Can't connect to MySQL server' errors in MySQL & MySQLi | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-28-2009 10:00 PM |