View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Tue Feb 24, 2015 9:09 pm 
Offline
Joined: Fri Nov 19, 2004 11:58 pm
Posts: 82
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.


Top
 Profile  
 
PostPosted: Tue Feb 24, 2015 9:44 pm 
Offline
Joined: Fri Nov 19, 2004 11:58 pm
Posts: 82
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


Top
 Profile  
 
PostPosted: Wed Feb 25, 2015 7:12 am 
Offline
Joined: Fri Jul 21, 2006 11:12 pm
Posts: 988
Location: SC
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.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu