nvme RAID crashing ...
 
Notifications
Clear all

nvme RAID crashing MySQL?

2 Posts
2 Users
0 Reactions
1,656 Views
(@gauvins)
Posts: 8
Member
Topic starter
 

Several changes (software updates, pushing the edge of parallel processing) could explain why mySQL is hanging for no obvious reason.

IIRC, I never had issues with the DB residing on a Thunderbay + 4 x Mercury Extreme Pro configured in RAID5.

More recently I've switched to an Express TB3 + 4 x Toshiba RD-400. I remember reading that RD-400 weren't designed for RAID systems, but people at OWC told me that they didn't experience issues. But this is the nag that explains why I am suspecting hardware issue. Benchmarking (Black Magic) showed excellent results. The system works generally very well, but for the occasional hang, typically when there's a lot of read/write activity. Today it crashed on a FLUSH TABLES .. FOR EXPORT statement -- something innocuous that points to a hardware problem.

I'll move the DB back to the TB2 / Mercury enclosure.

If anyone can suggest diagnostic steps, I'd appreciate.

Thanks

 
Posted : 06/10/2019 3:35 pm
(@softraid-support)
Posts: 9197
Member Admin
 

Unless MySL is doing something funky, it should not be able to trigger a panic/hang.

Try running AJA System test or black magic overnight. (AJA seems more intense)
5K video
RGBa
64GB file size, continuous.

If there is a hardware issue, AJA should help you trigger it.

Also, when this happened, run SoftRAID immediately and see if either a disk is missing, or in the log, if it shows a disk ejecting/hanging.

I don't see how there can be an issue. Samsungs have some Mac compatibility issues, with the top end lines, but I have not had any reports with toshibas.

 
Posted : 06/10/2019 4:13 pm
Share:
close
open