LinHES Forums http://forum.linhes.org/ |
|
mysqld on 8.3 will not start http://forum.linhes.org/viewtopic.php?f=25&t=24144 |
Page 1 of 1 |
Author: | thekingofspain [ Tue Feb 24, 2015 9:09 pm ] |
Post subject: | mysqld on 8.3 will not start |
My backend oddly and slowly crashed last night about a week after upgrading to 8.3. Tracking it down it seems MySQL is the culprit. What is the proper way to run the mysql on LinHES? mysql, mysqld, sv start mysqld, ... depending on what command and who it runs under the following errors are spawned: cannot create a mysqld.sock at /var/run/mysqld/mysqld.sock mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)") cannot create test file /data/srv/mysql/ Can't find file: './mysql/plugin.frm' After the who and how, what should be the permission and owners the related mysql files? I was updating some metadata through the frontend when mysql went south. |
Author: | thekingofspain [ Tue Feb 24, 2015 9:44 pm ] |
Post subject: | Re: mysqld on 8.3 will not start |
Think I fixed the problem, seems to be an old mysql setting that is now deprecated. In /etc/mysqld/my.conf comment out the following line: table_cache = <some value> Tracking back this change to the mythtv wiki on optimization: https://www.mythtv.org/wiki/Optimizing_Performance Quote: MySQL Database Tweaks
Taken from this thread http://www.gossamer-threads.com/lists/mythtv/users/91034 in mythtv-users. Add the following to the [mysqld] section of /etc/my.cnf to see improvements in database speed for MythTV as well as MythWeb. Check your default values using 'mysql> show global variables;' key_buffer = 48M max_allowed_packet = 8M table_cache = 128 sort_buffer_size = 48M net_buffer_length = 1M thread_cache_size = 4 query_cache_type = 1 query_cache_size = 4M |
Author: | brfransen [ Wed Feb 25, 2015 7:12 am ] |
Post subject: | Re: mysqld on 8.3 will not start |
Compare /etc/mysql/my.conf with /etc/mysql/my.conf.pacsave which should be the default file. If pacman saw changes to your /etc/mysql/my.conf the pacsave file would have been created. |
Page 1 of 1 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |