Results 1 to 10 of 12
Hybrid View
-
9th Apr 2012, 01:25 AM #1Super 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
-
9th Apr 2012, 01:40 AM #2OPMemberWebsite's:
PornShareProject.org MidnightDesires.orgOops, 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
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
MySQL error
By Funny in forum Web Development AreaReplies: 6Last Post: 27th Oct 2012, 01:56 PM -
Database error-mysql error
By saini in forum vBulletinReplies: 8Last Post: 8th Nov 2011, 06:54 AM -
MYSQL Error while Import via MYSQL Dumper (Error
By desibreaker in forum Server ManagementReplies: 10Last Post: 5th Aug 2011, 07:26 PM -
kloxo mysql failed to stop or even start
By accyuklad in forum Hosting DiscussionReplies: 5Last Post: 29th Nov 2010, 06:07 PM -
MySQL error
By mash-e1 in forum Webmaster DiscussionReplies: 2Last Post: 28th Mar 2009, 12:12 PM
themaLeecher - leech and manage...
Version 5.03 released. Open older version (or...