MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: nikobellicgamerin on 2017-07-21, 22:47:29
-
my website are loading very slow and taking ages to load , but my server is fast this all happen after updating from 6.5 to 7.0
help
-
Check to 'log manager' for php slow.
-
check i cant understand after some time all website stops responding , plz help to optimise my server
-
Try reboot your server.
-
done like 100 times nothing happned
-
Change to 'dynamic' from 'ondemand' for php-fpm in 'web features'.
-
done , but i want to use Apache 2.2 but the tick from Apache 2.4 is not removed i tryed many times but its there always.
-
What's the reason to use old apache (aka 2.2 version)?.
-
because its stable , non of my website works after 10 min from server restart me frustrated brother plz help.
-
Possible mysql data corrupt and or too much using resource. So, need optimize.
-
Try running 'top' and 'iotop' from each ssh terminal to know what's service using resource too much.
-
Please check and tell
(http://image.ibb.co/ibTVUk/process.png)
-
You have a trouble with mysql.
If using myisam for storage-engine, try 'sh /script/mysql-optimize --select=repair; sh /script/mysql-optimize --select=optimize'.
-
its innodb bro
-
its innodb bro
So, you need repair your database.
-
your command does not repair innodb i tryed.
-
: The storage engine for the table doesn't support repair
-
Search this forum to how to repair innodb or use google to find out 'how to repair innodb'.
-
BROTHER THIS LOG FILE TAKES TOO MUCH CPU CAN YOU TELL WHY
(http://image.ibb.co/egRMLQ/sql.png)
-
2017-07-24 17:24:35 7f7987019820 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
170724 17:24:35 [ERROR] InnoDB: Can't open './ibdata1'
170724 17:24:35 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
170724 17:24:35 [ERROR] Plugin 'InnoDB' init function returned error.
170724 17:24:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170724 17:24:35 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
170724 17:25:06 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
170724 17:25:06 [ERROR] Plugin 'Aria' init function returned error.
170724 17:25:06 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
170724 17:25:06 [Note] Plugin 'FEEDBACK' is disabled.
170724 17:25:06 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
170724 17:25:06 [ERROR] Aborting
170724 17:25:06 [Note] /usr/sbin/mysqld: Shutdown complete
170724 17:25:06 mysqld_safe mysqld from pid file /var/lib/mysql/ns1.pattola.com.pid ended
-
reply bro
-
Brother why are you not replying
-
why dont you try help fix this
-
Did you read how to fix innodb in this forum or search with google?.
-
not fount a single good article all things in this forum are unfinished
-
Read http://blackbird.si/mysql-corrupted-innodb-tables-recovery-step-by-step-guide/
Because using MariaDB, innodb_force_recovery and innodb_purge_threads add to /etc/my.cnf.d/server.cnf instead /etc/my.cnf.
That it.
-
What should i add to
add to /etc/my.cnf.d/server.cnf
-
tell me
-
Yes.
-
Yes.
What should i add to
add to /etc/my.cnf.d/server.cnf
-
Yes.
What should i add to
add to /etc/my.cnf.d/server.cnf
Use nano or vi to edit this file. Googling to know about nano or vi.