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/