Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » concurrent_insert=2 maintenace
concurrent_insert=2 maintenace [message #3750] Sat, 29 November 2008 16:51 Go to previous message
blargman is currently offline blargman
Messages: 1
Registered: November 2008
Junior Member
If I'm running concurrent_insert=2 and i end up with a bunch of deleted empty rows

what's the best way to clear those out?

shut down the server and run a myisamchk --sort ?

from what i've read concurrent_insert=2 , appends to the end of the table, ignoring deleted rows for storage. which would lead to empty deleted rows, aka a bunch of empty data in the .MYD . that's what i got from reading the docs on it anyway.
Report message to a moderator
[Message index]

Read Message
Read Message
Previous Topic:Why temporary tables?
Next Topic:very slow search query, help needed
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Thu Jul 9 23:02:33 EDT 2009

Total time taken to generate the page: 0.02005 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.