Timeout error occurred trying to start MySQL Daemon.

[AlternativeWeb]

I download and used "mysqltuner" script and made some changes to my my.cnf and now i'm getting errors:

( http://www.howtoforge.com/tuning-mysql-performance-with-mysqltuner )

Timeout error occurred trying to start MySQL Daemon.

I tired to put everything back to default, but after trying to restart mysql, i'm getting the same error message again.

Any idea what i'm doing wrong?

[root@server ~]# /etc/init.d/mysqld restart
Stopping MySQL: [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

I'm running on:
Metered Dedicated Servers - Dell 860 - Intel Xeon X3050 - 4GB MEM - 500GB HDD - 2TB BW

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 1000 #600
skip-locking
key_buffer = 256M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 16M
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
tmp_table_size > 16M
max_heap_table_size > 16M
#skip-innodb

user=mysql
local-infile=0
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192

[isamchk]
key_buffer = 256M
sort_buffer = 256M
read_buffer = 16M
write_buffer = 16M

[myisamchk]
key_buffer = 256M
sort_buffer = 256M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout


skip-networking

#log-slow-queries = /var/log/mysql-slow.log

 

[Sp32]

Revert back to the original my.cnf and then tell me what changes you are making.

 

[JamesVaporH]

hahah

tmp_table_size > 16M
max_heap_table_size > 16M

MySQL does not understand what the > is for so change it to = and it should be fine.

 

[AlternativeWeb]

Oops, I thought I reverted back to default.
I must of missed that

Thanks for helping me out guy, everything working again.

---------- Post added at 09:40 PM ---------- Previous post was at 09:29 PM ----------

My server keeps swapping once a day. Do you have any idea what I can do to prevent it from happening again?

My current my.cnf:

[mysqld]
 datadir=/var/lib/mysql
 socket=/var/lib/mysql/mysql.sock
 max_connections = 1000 #600
 skip-locking
 key_buffer = 256M
 myisam_sort_buffer_size = 32M
 join_buffer_size = 1M
 read_buffer_size = 1M
 sort_buffer_size = 2M
 table_cache = 1024
 thread_cache_size = 16M
 interactive_timeout = 25
 wait_timeout = 1000
 connect_timeout = 10
 max_allowed_packet = 16M
 max_connect_errors = 10
 query_cache_limit = 1M
 query_cache_size = 32M
 query_cache_type = 1
 tmp_table_size = 16M
 max_heap_table_size = 16M
 #skip-innodb
 innodb_buffer_pool_size = 53M
 
 user=mysql
 local-infile=0
 # Default to using old password format for compatibility with mysql 3.x
 # clients (those using the mysqlclient10 compatibility package).
 old_passwords=1
 
 [mysqld_safe]
 log-error=/var/log/mysqld.log
 pid-file=/var/run/mysqld/mysqld.pid
 open_files_limit = 8192
 
 [isamchk]
 key_buffer = 256M
 sort_buffer = 256M
 read_buffer = 16M
 write_buffer = 16M
 
 [myisamchk]
 key_buffer = 256M
 sort_buffer = 256M
 read_buffer = 16M
 write_buffer = 16M
 [mysqlhotcopy]
 interactive-timeout
 
 skip-networking
 
 #log-slow-queries = /var/log/mysql-slow.log

 

[JamesVaporH]

Swapping? Do you mean it keeps using swap space?

 

[AlternativeWeb]

Sorry, I'm not sure if I'm using the right lingo, but yes, swap space.

The server keeps freezing up on me at least once a day this whole week.

 

[JamesVaporH]

How does it freeze up on you?

What OS do you currently use.

 

[AlternativeWeb]

I mean freezing up as in website won't load. When I login via SSH, and use the "top" command, I see the server is using all the swap space.

I'm using "CentOS release 5.7 (Final)"

 

[JamesVaporH]

Heres a dirty trick i usually use on all my servers i administrate to keep swap from being used.

type in

vi /etc/sysctl.conf

add to the file sysctl.conf at the very bottom unless the vm.swappiness is defined then edit it

vm.swappiness = 1

USUALLY you want to restart for it to use the new settings, but you can run this command

/sbin/sysctl -p

That should update the system settings. The just to make sure try to restart mysql and such that uses swap.

Also make sure you are not using all your ram or else that could also be why swap is being used.

 

[AlternativeWeb]

I hope this works because I was starting to get tired of waking up to a stalled server.
I'll give that a try, Thanks James!

 

[JamesVaporH]

If it does not work or there seems to be a issue you can always contact me via pm and i will look more into the issue and provide ideas as to how to make it fix.

 

[AlternativeWeb]

I appreciate it, thank you!