Timeline for How do I prevent ibdata1 from continually growing by over 1GB per hour?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 31, 2023 at 6:52 | comment | added | James Cobban | Thank you Rick. Perhaps somebody else with greater experience can explain this. My entire site was down FOR TWO DAYS BECAUSE OF THIS and I had to back up all of my databases and restart Mariadb FROM SCRATCH. And I am still getting multiple errors about corrupted databases. I demand an explanation. | |
| Dec 29, 2023 at 1:01 | comment | added | Rick James |
Connect as root and do SHOW PROCESSLIST; Maybe something is running that you don't know about.
|
|
| Dec 29, 2023 at 0:58 | comment | added | James Cobban | Firstly by looking at my.cnf which has innodb_file_per_table=1. Secondly the folder for my database has a separate .idb file for each table. So why was ibdata1 increasing in size by a gigabyte per hour? | |
| Dec 27, 2023 at 23:27 | comment | added | Rick James | @JamesCobban - Hmmm... How are you checking that the "tables have moved"? (I don't know a simple way.) | |
| Dec 27, 2023 at 21:20 | comment | added | James Cobban | Sorry that should have read "my.cnf had innodb_file_per_table=1 set but I did not check to see if all of the tables had moved." | |
| Dec 27, 2023 at 21:13 | comment | added | James Cobban | Thank you Rick for your cogent suggestions. During the two days that the ibdata1 file was mushrooming in size, there were almost no changes to the database contents. It was Christmas Day and people have more important activities than browsing websites. I went over logs and the ONLY changes to the database were changing usage counters in the table that tracks advertising, indicative of people browsing the site. And yet the table ballooned in size by over 5GB in 24 hours. my.cnf had innodb_file_per_table=0 set but I did not check to see if all of the tables had moved. | |
| Dec 26, 2023 at 20:52 | history | edited | Rick James | CC BY-SA 4.0 |
added 668 characters in body
|
| Dec 26, 2023 at 20:46 | history | answered | Rick James | CC BY-SA 4.0 |