network profile
| bio | website | market76.com |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 6 months |
| seen | Nov 22 '12 at 23:26 | |
| stats | profile views | 3 |
|
Nov 21 |
comment |
mysqlcheck to optimize innodb tables — performance/scheduling innodb_file_per_table is on. |
|
Nov 20 |
comment |
mysqlcheck to optimize innodb tables — performance/scheduling My main goal is general InnoDB table maintenance, something our current server hasn't received much of. We're using New Relic to record queries and improve query design to optimize from that end too, but would also like to make sure there's not general nightly/weekly type maintenance we can do in order to prevent meltdowns/general issues. |
|
Nov 18 |
asked | mysqlcheck to optimize innodb tables — performance/scheduling |
|
Nov 18 |
awarded | Scholar |
|
Nov 18 |
accepted | InnoDB Performance Tuning |
|
Nov 17 |
comment |
InnoDB Performance Tuning @DTest, how can I go about changing innodb_flush_log_at_trx_commit? I've looked around online but I want to do it safely. |
|
Nov 15 |
awarded | Student |
|
Nov 15 |
awarded | Editor |
|
Nov 15 |
comment |
InnoDB Performance Tuning Thanks for the suggestions. I've updated the original post with GB totals. I will also try #2 and #3 and post results. I'm assuming #3 also requires stoping the MySQL server? |
|
Nov 15 |
revised |
InnoDB Performance Tuning added 263 characters in body |
|
Nov 15 |
asked | InnoDB Performance Tuning |
