Hi everyone.
I searched about my problem in cpanel forums, I could not find the solution.
My vps features are:
VPS 2 - Xen
Disk: 60 GB RAID Protected
Bandwidth : 500 GB
RAM / Memory: 2048 MB (+2048 MB Burst)
CPU Cores: 2
Operating System Centos.
Company: Namecheap
This is my.cnf configuration:
My mysqltuner:
The problem is, I have 35 small joomlas has very little traffic. When entering the website of one of my clients, I get this error:
Can't open file: './databctaxi_aleport/zlmzn_session.frm' (errno: 24) SQL=INSERT INTO `zlmzn_session` (`session_id`, `client_id`, `time`) VALUES ('9aaca5ce05738ccaae8766be7bf6b069', 0, '1388065914')
Other:
Can't open file: './legadbdez_zetafin/hqjc8_session.frm' (errno: 24) SQL=INSERT INTO `hqjc8_session` (`session_id`, `client_id`, `time`) VALUES ('ab79945b37e6f3584152aff208fa2c15', 0, '1389727890')
The momentary solution is to restore the mysql server.
After 30 minutes or an hour, I get the error again, I have to restart mysql another time.
Important: I use siteautobackup.com for backup my accounts, then download my backups on my vps and all my backup restored automatically with this command:
for i in `ls /home/*.tar.gz`;do /scripts/restorepkg --force $i;done
What could be done to fix this problem, I hope your answer.
I'm grateful for your assistance.
Sorry for my bad English.
I searched about my problem in cpanel forums, I could not find the solution.
My vps features are:
VPS 2 - Xen
Disk: 60 GB RAID Protected
Bandwidth : 500 GB
RAM / Memory: 2048 MB (+2048 MB Burst)
CPU Cores: 2
Operating System Centos.
Company: Namecheap
This is my.cnf configuration:
Code:
query_cache_size=50M
query_cache_limit=1M
innodb_buffer_pool_size=400M
tmp_table_size=50M
max_heap_table_size=50M
join_buffer_size=1M
read_rnd_buffer_size=2M
slow_query_log=1
slow_query_log_file=mysql-slow.log
long_query_time=0.1
Code:
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
ERROR 23 (HY000) at line 1: Out of resources when opening file '/tmp/#sql_5860_0.MYD' (Errcode: 24)
ERROR 23 (HY000) at line 1: Out of resources when opening file '/tmp/#sql_5860_0.MYD' (Errcode: 24)
[!!] InnoDB is enabled but isn't being used
Argument "" isn't numeric in numeric gt (>) at /usr/local/cpanel/bin/mysqltuner.pl line 698.
[OK] Total fragmented tables:
ERROR 23 (HY000) at line 1: Out of resources when opening file '/tmp/#sql_5860_0.MYD' (Errcode: 24)
Argument "" isn't numeric in numeric eq (==) at /usr/local/cpanel/bin/mysqltuner.pl line 763.
-------- Performance Metrics -------------------------------------------------
[--] Up for: 4m 46s (179 q [0.626 qps], 15 conn, TX: 289K, RX: 41K)
[--] Reads / Writes: 74% / 26%
[--] Total buffers: 524.0M global + 5.4M per thread (151 max threads)
[OK] Maximum possible memory usage: 1.3G (71% of installed RAM)
[OK] Slow queries: 0% (1/179)
[OK] Highest usage of available connections: 1% (2/151)
[!!] Cannot calculate MyISAM index size - re-run script as root user
[!!] Query cache efficiency: 15.6% (12 cached / 77 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 27 sorts)
[!!] Joins performed without indexes: 3
[OK] Temporary tables created on disk: 3% (2 on disk / 59 total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 93% (93 open / 100 opened)
[OK] Open file limit used: 14% (148/1K)
[OK] Table locks acquired immediately: 100% (263 immediate / 263 locks)
[!!] Connections aborted: 6%
Can't open file: './databctaxi_aleport/zlmzn_session.frm' (errno: 24) SQL=INSERT INTO `zlmzn_session` (`session_id`, `client_id`, `time`) VALUES ('9aaca5ce05738ccaae8766be7bf6b069', 0, '1388065914')
Other:
Can't open file: './legadbdez_zetafin/hqjc8_session.frm' (errno: 24) SQL=INSERT INTO `hqjc8_session` (`session_id`, `client_id`, `time`) VALUES ('ab79945b37e6f3584152aff208fa2c15', 0, '1389727890')
The momentary solution is to restore the mysql server.
After 30 minutes or an hour, I get the error again, I have to restart mysql another time.
Important: I use siteautobackup.com for backup my accounts, then download my backups on my vps and all my backup restored automatically with this command:
for i in `ls /home/*.tar.gz`;do /scripts/restorepkg --force $i;done
What could be done to fix this problem, I hope your answer.
I'm grateful for your assistance.
Sorry for my bad English.