possible mysql 8 bug

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Vegan
Forum Regular
Posts: 567
Joined: Fri Sep 05, 2008 3:34 pm
Location: Victoria, BC
Contact:

possible mysql 8 bug

Post by Vegan »

I had to recover my site after my database on my server became 95GB and the SSD became unwriteable

wonder about the SSD and if it is able to handle TRIM efficiently
Hardcore Games™ Legendary is the Only Way to Play™
User avatar
Benjamin
Site Administrator
Posts: 6911
Joined: Sun May 19, 2002 10:24 pm

Re: possible mysql 8 bug

Post by Benjamin »

What do you mean by TRIM?

Was the disk full or placed into read only mode? If it went into RO mode check DMESG, it's probably failing.
User avatar
Vegan
Forum Regular
Posts: 567
Joined: Fri Sep 05, 2008 3:34 pm
Location: Victoria, BC
Contact:

Re: possible mysql 8 bug

Post by Vegan »

After several updates the problem seems to be corrected now.

When the database grew that large I was shocked as the tables were unaffected so I looked at the relevant folders. All I know is that it was MySQL using a lot of space.
Hardcore Games™ Legendary is the Only Way to Play™
User avatar
Vegan
Forum Regular
Posts: 567
Joined: Fri Sep 05, 2008 3:34 pm
Location: Victoria, BC
Contact:

Re: possible mysql 8 bug

Post by Vegan »

Checking in to indicate the defect has been fixed

Some bizzare bug in MySQL 8 was accidentally introduced and its now fixed
Hardcore Games™ Legendary is the Only Way to Play™
Post Reply