mysql doesn;t start version MySQL version 5.1.7 my.cnf is
[client] port = 3306
socket=/var/tmp/mysql.sock
[mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0
[mysqld]
user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking
bind-address = 127.0.0.1
key_buffer = 384M max_allowed_packet = 2G thread_cache_size = 64
myisam-recover = BACKUP
query_cache_limit = 10M query_cache_size = 19000M
expire_logs_days = 10 max_binlog_size = 1000M innodb_file_per_table = 1 thread_concurrency = 8 myisam_sort_buffer_size = 64M read_rnd_buffer_size = 8M read_buffer_size = 2M sort_buffer_size = 2M table_cache = 512 max_connections = 9000 big-tables default-storage-engine = MyISAM
[mysqldump] quick quote-names max_allowed_packet = 64M
[mysql]
[isamchk] key_buffer = 256M write_buffer = 2M read_buffer = 2M sort_buffer_size = 256M
!includedir /etc/mysql/conf.d/
open_files_limit = 16196
this happens suddently. on my server and all virtual servers are gone... please help
Comments
Submitted by andreychek on Tue, 09/16/2014 - 11:19 Comment #1
Howdy -- you would want to determine what error MySQL is throwing, either on the command line or in the error logs.
Knowing the error will help resolve the issue.
However, you appear to be using Virtualmin GPL there. If you're using Virtualmin GPL, we'd encourage you to use the Forums if you're interested in free community support. We monitor the Forums, along with lots of wonderful folks in the community!
If you create a new post in the Forums, let us know what error it is you're seeing.
Also let us know if something on your server has changed recently.
Alternatively, we do offer Professional Services, where we charge $125 an hour to provide assistance and resolve problems. If you prefer, we could log into your server and resolve the problem right away. While it's difficult to say what the problem is without looking, I would estimate that we would only need to charge for an hour to resolve that issue.