Interesting MySQL Error

[Sepivip]

Hi gr8 ppl, I am running "Mega File Hosting Script" on "Fedora Core 5" and "DA".

As you guess I always recieve high loads on mysql, everything was fine till yesterday, at night my users reported following errors:

Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0

FATAL ERROR: Connections to database server failed.
MYSQL Error:Too many connections
If the server shows on secondary server, you need setup remote access to the mysql database of main server

Any suggestions or possible solutions?

Thank you in advance

 

[nobaloney]

Have you run out of space on any device?

Search for my.cnf in these forums and install the configuration file for mysqld.

That may resolve the "Too many connections" error. If not you may need to tweak some settings.

Jeff

 

[Sepivip]

My.cnf looks like this:

[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-innodb

set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
server-id = 1

# Point the following paths to different dedicated disks
#tmpdir = /tmp/ 
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
safe-updates

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

that solved my connections setting, but I keep getting new errors:

sometimes there is:

FATAL ERROR: Connection to database server failed. 
MYSQL Error:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
If the error shows on secondery server, you need setup remote access to the mysql database of main server

and sometimes:

Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0

 

[Mik3yZ]

with the unix command 'df' (no quotes) you can check if you have space left.
please post the outcome here...

- Mike