Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 10
Newest
 Caucus
Impact
~5k people reached

  • 0 posts edited
  • 1 helpful flag
  • 17 votes cast
Nov
24
awarded  Caucus
Nov
13
awarded  Nice Question
Jan
3
awarded  Critic
Aug
5
awarded  Notable Question
Mar
12
awarded  Citizen Patrol
Mar
7
awarded  Popular Question
Aug
15
comment Why are all MySQL InnoDB tables fragmented?
Ahhh ok, things make a lot more sense now, thanks. I ended up exporting the data, wiping MySQL completely, then reinstalling (but adding innodb_file_per_table to the conf file before starting the server and re-importing). Prior to that I was getting all sorts of InnoDB errors (the really bad kinds...ones that meant I had to run with innodb_force_recovery at level 6 just to get the data out!), and all sorts of 'the log file date is in the future!' errors. Those seem to have stopped now but I've still got a fair few fragmented tables. I'll just keep my eye on it, thanks again for the input
Aug
15
comment Why are all MySQL InnoDB tables fragmented?
@Rolando I was hoping you might see this :) I do have innodb_file_per_table enabled now (didn't before), but I've actually gutted out the whole MySQL server and reinstalled. At the time of writing I'm down to 187 fragmented tables, but that seems to be increasing every time I do some work on a local site :/ I'm still not entirely sure if it's actually a problem or not though, my knowledge of MySQL internals is pretty sketchy
Aug
15
awarded  Student
Aug
15
awarded  Scholar
Aug
15
accepted Why are all MySQL InnoDB tables fragmented?
Aug
15
comment Why are all MySQL InnoDB tables fragmented?
@JohnGardeniers Thanks, that's reassuring. If you'd like to put that in as an answer I'll be glad to accept it
Aug
15
comment Why are all MySQL InnoDB tables fragmented?
@JohnGardeniers I believe so, the message is: [!!] Total fragmented tables: 2314, which I'm pretty sure indicates a problem (with the double red exclamation marks)
Aug
15
awarded  Editor
Aug
15
revised Why are all MySQL InnoDB tables fragmented?
added 14 characters in body
Aug
15
comment Why are all MySQL InnoDB tables fragmented?
@DavidSchwartz Not a clue, that's why I asked ;) There are 2314 tables, each with 7MB free, and I don't know what that means. I'm not sure why mysqltuner would show me that figure if it wasn't a potential cause for concern. I was hoping someone here might be able to to tell me how concerned to be given the numbers, and what I can do to mitigate the problem since the 'standard' methods don't work
Aug
15
asked Why are all MySQL InnoDB tables fragmented?
Apr
6
awarded  Supporter
Apr
6
awarded  Autobiographer