Activity Stream
48,167 MEMBERS
6706 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Results 1 to 10 of 12

Hybrid View

AlternativeWeb Timeout error occurred trying to... 9th Apr 2012, 01:23 AM
Sp32 Revert back to the original my.cnf... 9th Apr 2012, 01:25 AM
AlternativeWeb Oops, I thought I reverted back to... 9th Apr 2012, 01:40 AM
JamesVaporH hahah tmp_table_size > 16M... 9th Apr 2012, 01:27 AM
JamesVaporH Swapping? Do you mean it keeps... 9th Apr 2012, 01:58 AM
AlternativeWeb Sorry, I'm not sure if I'm using... 9th Apr 2012, 02:11 AM
JamesVaporH How does it freeze up on you? ... 9th Apr 2012, 02:16 AM
AlternativeWeb I mean freezing up as in website... 9th Apr 2012, 02:31 AM
JamesVaporH Heres a dirty trick i usually use... 9th Apr 2012, 02:47 AM
AlternativeWeb I hope this works because I was... 9th Apr 2012, 03:08 AM
JamesVaporH If it does not work or there seems... 9th Apr 2012, 03:24 AM
AlternativeWeb I appreciate it, thank you! 9th Apr 2012, 04:28 AM
Previous Post Previous Post   Next Post Next Post
  1.     
    #1
    Super Member
    Revert back to the original my.cnf and then tell me what changes you are making.
    Sp32 Reviewed by Sp32 on . Timeout error occurred trying to start MySQL Daemon. 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? Rating: 5

    So kiss me and smile for me, say that you'll wait for me <'3

  2.   Sponsored Links

  3.     
    #2
    Member
    Website's:
    PornShareProject.org MidnightDesires.org
    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:

    Code: 
    [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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MySQL error
    By Funny in forum Web Development Area
    Replies: 6
    Last Post: 27th Oct 2012, 01:56 PM
  2. Database error-mysql error
    By saini in forum vBulletin
    Replies: 8
    Last Post: 8th Nov 2011, 06:54 AM
  3. MYSQL Error while Import via MYSQL Dumper (Error
    By desibreaker in forum Server Management
    Replies: 10
    Last Post: 5th Aug 2011, 07:26 PM
  4. kloxo mysql failed to stop or even start
    By accyuklad in forum Hosting Discussion
    Replies: 5
    Last Post: 29th Nov 2010, 06:07 PM
  5. MySQL error
    By mash-e1 in forum Webmaster Discussion
    Replies: 2
    Last Post: 28th Mar 2009, 12:12 PM

Tags for this Thread

BE SOCIAL