Title: Mysql database stop Last modified: August 22, 2016 --- # Mysql database stop * [gasparo](https://wordpress.org/support/users/gasparo/) * (@gasparo) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/) * Were is wrong i dont find the problem? Table prefix is revmisc * Version: ‘5.5.38-0ubuntu0.12.04.1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 (Ubuntu) 141016 7:26:54 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscaiowps_failed_logins’ is marked as crashed and should be repaired 141016 7:26:54 [Warning] Checking table: ‘./xxx/revmiscaiowps_failed_logins’ 141016 7:26:54 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscaiowps_login_activity’ is marked as crashed and should be repaired 141016 7:26:54 [Warning] Checking table: ‘./xxx/revmiscaiowps_login_activity’ 141016 7:26:54 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscaiowps_login_lockdown’ is marked as crashed and should be repaired 141016 7:26:54 [Warning] Checking table: ‘./xxx/revmiscaiowps_login_lockdown’ 141016 7:26:56 [ERROR] /usr/sbin/ mysqld: Table ‘./xxx/revmiscoptions’ is marked as crashed and should be repaired 141016 7:26:56 [Warning] Checking table: ‘./xxx/revmiscoptions’ 141016 7:26:56[ ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscpostmeta’ is marked as crashed and should be repaired 141016 7:26:56 [Warning] Checking table: ‘./xxx/revmiscpostmeta’ 141016 7:26:58 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscposts’ is marked as crashed and should be repaired 141016 7:26:58 [Warning] Checking table: ‘./ xxx/revmiscposts’ 141016 7:27:01 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscterm_relationships’ is marked as crashed and should be repaired 141016 7:27:01 [Warning] Checking table: ‘./xxx/revmiscterm_relationships’ * [https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) Viewing 12 replies - 1 through 12 (of 12 total) * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393903) * Hi gasparo is the first time this happens? * Thread Starter [gasparo](https://wordpress.org/support/users/gasparo/) * (@gasparo) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393904) * No ,when i have a lot of visitor is crash * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393905) * Have you spoken to your server administrator? Or your Host? * Thread Starter [gasparo](https://wordpress.org/support/users/gasparo/) * (@gasparo) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393907) * yes an he said is no problem with that, the plugin is the reson * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393911) * Hi are you running the latest version? If you are then one of the developers will check this issue for you. * Kind regards * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393913) * [@gasparo](https://wordpress.org/support/users/gasparo/), Such errors have never occurred before due to the AIOWPS plugin which is why I’m a little puzzled at your situation. * Can you check how many rows are in the “aiowps_events” table? * This table can grow rather large if you have the “Enable IP Lockout For 404 Events” in the firewall menu active and if you’re being hammered by bots which are continually generating 404 events. * If that table if it is very big you might need to manually delete the entries from phpmyadmin and also deactivate the “Enable IP Lockout For 404 Events” feature for now. We are applying an improvement to the next version of the plugin which will automatically ensure that this table does not get bigger than a certain size. * Thread Starter [gasparo](https://wordpress.org/support/users/gasparo/) * (@gasparo) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393916) * Were i look for in php my admin? Utilizare spațiu Tip Utilizare Date 0 octeți Index 1,024 octeți Total 1,024 octeți Statisticile rîndului Comenzi Valoare Format dinamic Interclasare utf8_general_ci Linie 0 Următorul Autoindex 1 Creare 06 Aug 2014 la 13:02 Ultima actualizare 16 Oct 2014 la 09:03 Ultima verficare 16 Oct 2014 la 09:03 * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393927) * Yes use PHPMyAdmin to check how many rows that table has. * Thread Starter [gasparo](https://wordpress.org/support/users/gasparo/) * (@gasparo) * [11 years, 8 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393930) * 9 rows 1 id bigint(20) Nu None AUTO_INCREMENT 2 event_type varchar(150) utf8_general_ci Nu 3 username varchar(150) utf8_general_ci Da 4 user_id bigint(20) Da NULL 5 event_date datetime Nu 0000- 6 ip_or_host varchar(100) utf8_general_ci Da 7 referer_info varchar(255) utf8_general_ci Da 8 url varchar(255) utf8_general_ci Da NULL 9 event_data longtext utf8_general_ci Da * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393941) * The information you’ve provided actually describes the **columns** of the table not how many entries there are in it. * I meant how many rows of data have already been inserted into that table. When you view that table in MySQL you will see something like the following message displayed at the top: * Showing rows 0 – 24 (**779 total**, Query took 0.0201 sec) * The example above shows that there are 779 rows in the table. * Thread Starter [gasparo](https://wordpress.org/support/users/gasparo/) * (@gasparo) * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393942) * MySQL a dat un set de rezultate gol (zero linii). ( comanda a durat 0.0005 sec) * MySQL returned an empty result set (zero line). (Command took 0.0005 sec) * But now is shut down * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393943) * Ok thanks – looks like you do not have any entries in that table. * I cannot see any reason for the plugin to be causing the issue. Did you take the recommended DB backup before you changed the DB prefix? If so, I would strongly suggest that you restore the DB backup file. Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Mysql database stop’ is closed to new replies. * ![](https://ps.w.org/all-in-one-wp-security-and-firewall/assets/icon-256x256. png?rev=2798307) * [All-In-One Security (AIOS) – Security and Firewall](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) * [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/#faq) * [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/) * [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/unresolved/) * [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/) ## Tags * [mysql-error](https://wordpress.org/support/topic-tag/mysql-error/) * 12 replies * 3 participants * Last reply from: [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-stop/#post-5393943) * Status: not resolved