Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've made some changes to My.cnf to configure Mysql server as below:

innodb_buffer_pool_size = 50M
innodb_log_file_size = 15M
bulk_insert_buffer_size=25M
log-slow-queries = mysql-inja-slow.log

Then I restarted the MySQL server with command below:

service mysqld restart

It reported that MySQL has stopped, but when wanted to start said: [ Faild ]. Now when I want to access Kloxo login page I get the error :

The connection has timed out
          The server at XX.XX.XX.XX is taking too long to respond.

I have no idea what happened? Could someone please shed some light on the issue? Did I do something wrong in between?

share|improve this question
add comment

1 Answer

General recommendation is to check your mysql error log.

In your case you might have problem with changing innodb_log_file_size. To do it correctly you need to backup your database, remove all database files (ibdata and ib_log), than start database and restore backup. See manual

share|improve this answer
    
connect to your VDS using ssh –  DukeLion May 23 '12 at 10:22
    
No, file should be created automatically –  DukeLion May 23 '12 at 10:27
    
working directory of mysql is not in /etc, if you omit path to file in config - it will use same path, as for database files. It is possible that there are some errors with this file, so you need to check your logs to stop guessing and start fixing. –  DukeLion May 23 '12 at 10:39
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.