Check log thấy database semaphore đang bị crash và cách repair trong Drupal 7

Sự cố thường gặp trong Drupal 7 là table semaphore' is marked as crashed and should be repaired

Bạn có thể kiểm tra log lỗi ở đường dẫn /var/lib/mysql file vps15.superdata.vn.err và repair theo hướng dẫn sau :

This tutorial explains how to repair and optimize database tables through phpMyAdmin.

Hoa hau tran tieu vy

How to Repair MySQL Database Tables?

To repair a MySQL database, first open the phpMyAdmin tool, then the Databases tab and click on the name of the desired database. Select the tables that need repair by ticking the check-boxes on the left of the table names. Then from the With Selected: drop down menu choose Repair Table. The tables will be automatically repaired and you will be presented with a page showing the results from the repair operation.

How to Repair MySQL Database Tables

How to Optimize MySQL Database Tables?

To optimize the tables of a MySQL Database, select all of the tables that you want optimized by ticking the check-box next to their name. Then from the With Selected: drop down menu choose Optimize table. The optimization will be performed automatically and a new page will open that shows the result of the operation.

How to Optimize MySQL Database Tables?