Differences between version 3 and predecessor to the previous major change of MySQLNotes.
Other diffs: Previous Revision, Previous Author, or view the Annotated Edit History
Newer page: | version 3 | Last edited on Sunday, April 11, 2004 12:12:03 pm | by MichaelBordignon | Revert |
Older page: | version 2 | Last edited on Wednesday, February 25, 2004 12:00:03 am | by MattBrown | Revert |
@@ -34,4 +34,12 @@
!!! Clearing Unwanted Binary Log Files
mysql in some configurations can log all database activity to a binary log file (usually in /var/lib/mysql). If you have a busy site this can grow quite large. The recommended management solution in the mysql manual is to remove binary log files that you no longer want. They suggest removing files that are older than 3 days. To remove all binary log files you can use the following command
RESET MASTER;
+
+!!! What to do if the table handler is returning error 28
+
+If you receive the following from mysql_error()
+
+ Got error 28 from table handler
+
+this means your disk is full. Probably /tmp. Go clear it out.