Reputation
Top tag
Next privilege 20 Rep.
Talk in chat
Badges
4
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Sep
30
awarded  Popular Question
Aug
27
revised Ubuntu kernel trace - troubleshooting “task hung for 120 secs” random crashes
added 39 characters in body
Aug
27
revised Ubuntu kernel trace - troubleshooting “task hung for 120 secs” random crashes
added 2956 characters in body
Aug
27
asked Ubuntu kernel trace - troubleshooting “task hung for 120 secs” random crashes
Aug
22
comment Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
what is the difference between that script and running ' mysqlcheck --analyze --optimize --all-database ' ? wouldn't --optimize just map to alter table with innodb?
Aug
22
awarded  Scholar
Aug
22
accepted Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
Aug
22
comment Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
how about mysqlcheck --analyze --optimize --all-database ? i'd rather do all tables in one shot - all are innodb.
Aug
22
comment Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
is running 'mysqlcheck -u root -p --auto-repair --check --optimize --all-databases' the same thing? with Innodb an optimize tables would essentially re-create the entire tables as if it was dumped/restored?
Aug
22
awarded  Student
Aug
22
comment Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
updated above. thx.
Aug
22
revised Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
added 193 characters in body
Aug
22
awarded  Editor
Aug
22
comment Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
Value is at 300
Aug
22
revised Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
added 822 characters in body
Aug
22
comment Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
I will add above...
Aug
22
comment Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
what does that mean? hardware or driver issue? could this issue be due to a misconfigured My.cnf?
Aug
22
comment Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
Yes. I am thinking of running mysqlcheck with -optimize but before this locks the database for 2-3 hours I would like to see if it would a difference.
Aug
21
comment Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
RAM and Swap is fine. innodb_pool_size is taking up around 50% of the RAM - 32gigs. It is not swapping. Bonnie++ and other stress tests cannot replicate the issue. however this can't really test read/writes to the fragmented database.
Aug
21
asked Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?