1

Need help optimize mysql setting

view story
linux-howto

http://forums.cpanel.net – Hi, I am new member in this forum. I hope I can learn a lot from this forum. I have server with RAM 64 GB with MySQL Version 5.1.63-cll x86_64. I need help how to optimize my.cnf Here is my.cnf Quote: [mysqld] local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking #skip-innodb query_cache_limit=128M query_cache_size=32K join_buffer_size=2M tmp_table_size=64M max_heap_table_size=64M query_cache_type=1K max_user_connections=50 max_connections=50 interactive_timeout=10 wait_timeout=10 connect_timeout=10 thread_cache_size=16 (HowTos)

missing's picture
Submitted by missing on 07/08/2012

Stories similar to Need help optimize mysql setting

Hi,

Im hosting a website with a lot of visitors (joomla, etc) and im having load over 60 on my vps with 4 gigs of ram and 4 gigs burst.

Hi.

I'm running cPanel under a VPS (1Gb RAM / 2Gb Burst).

Here is my.cnf content:

Code: [mysqld] skip-networking skip-innodb slow_query_log safe-show-database local-infile = 0

max_connections = 150 max_delayed_threads = 20 max_tmp_tables = 32 query_cache_type = 1 query_cache_size = 64M thread_cache_size = 4 tmp_table_size = 128M max_heap_table_size = 128M join_buffer_

The MySQL my.cnf file on our centOS server shows skip-innodb as present.

We are looking to optimize my.cnf for a large Magento database. The server has 12GB of memory and 5 Xeon Processors.

Would it be best to comment/remove the skip-innodb line?

Server details:

RAM: 16GB HDD: 1000GB OS: Linux 2.6.32-220.7.1.el6.x86_64 Processor: 6 Core

Please see the link below for my # top preview:

I can often see the error mentioned in title in my plesk panel and my /etc/my.cnf configuration are as below:

bind-address=127.0.0.1 local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql

max_connections=20000 max_user_connec

/etc/my.cnf optimization 23 weeks 20 hours ago

Hello,

We have websites that are mainly php/mysql driven and website is getting good amount of traffic.

Please suggest changes to improve the performance.

Server Spec is:

Intel Xeon CPU E3-1230 V2 @ 3.30GHz with 8GB of Ram

Code: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock max_allowed_packet=100M thread_stack=3M max_connections=600 max_user_connections=50 ft_min_word

I have DS with 3g RAM and my processor is AMD Athlon(tm) 64 X2 Dual Core Processor 4200+.

My server is running: Fedora release 15 (Lovelock) Linux * 2.6.40.6-0.fc15.x86_64 #1 SMP Tue Oct 4 00:39:50 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux

my.cnf file is:

[mysqld] #skip-innodb #log user=mysql log-slow-queries=/var/log/mysql/log-slow-queries.log long_query_time = 5 #query_cache_size = 20

I have been tuning MYSQL for a few days now, it's using some huge cache's

key_buffer_size = 128M sort_buffer_size = 1M read_buffer_size = 1M join_buffer_size = 1M thread_cache_size = 50 table_open_cache = 1500 query_cache_size= 164M query_cache_type = 1 query_cache_limit = 1M max_connections = 200 tmp_table_size = 256M max_heap_table_size = 256M

The tmp table sizes seem to be pre

I've changed data directory in /etc/my.cnf.

I have got a error message with my MySQL server. Linux with 8 GB memory.