MySQL Bugs: #48115: MySQL on SSD

Bug #48115	MySQL on SSD
Submitted:	16 Oct 2009 13:30	Modified:	7 Jan 2010 16:37
Reporter:	Max Mack	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: General	Severity:	S3 (Non-critical)
Version:	5.1.39-0.dotdeb.1 (Debian)	OS:	Linux (debian lenny)
Assigned to:		CPU Architecture:	Any
Tags:	solid state disk many updates

Description:
I've done many (about 3.000 querys / sec) on an mysql 5.1 Server on Debian Lenny.
The Updates i've done are simple "UPDATE table SET update_at = now, data = value where id = xxx", so nothing special. The only special i can imagine is that mysql runs on an solid state disk.

The whole database has about 24m records and is about 50GB in size (cause of binary data inside). The updates who were runing at crash time were against one table (about 5m rows). Just simple updates. (nothing binary, only integer updates).

SSD is an Super Talent with 128GB Space:
-------------------------------------
Host: scsi0 Channel: 00 Id: 00 Lun: 00
  Vendor: ATA      Model: STT_FTM28GX25H   Rev: 1571
  Type:   Direct-Access                    ANSI  SCSI revision: 05
-------------------------------------

df -h:
-------------------------------------
Filesystem Size  Used Avail Use% Mounted on
ext3 89G   50G   35G  59% /srv/ssd
-------------------------------------

uname -r: Debian Lenny
--------------
2.6.26-2-amd64
--------------

The syslog:
-------------------------------------
get's attached as file!
-------------------------------------

How to repeat:
I don't know how to repeat. Many updates on an SSD Disk?

Suggested fix:
don't know.

syslog

Attachment: mysql_bug_report.txt (text/plain), 14.53 KiB.

similar or the same as bug #38883 and bug #46683

Yeah, this looks duplicate of http://bugs.mysql.com/bug.php?id=46683.

duplicate entry...