meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 5 months |
| seen | yesterday | |
| stats | profile views | 3 |
|
1d |
answered | How to safely change MySQL innodb variable 'innodb_log_file_size'? |
|
1d |
comment |
how important are mysql's innodb logs? @PeeyushKushwaha Oh and in case you want to resize your redo log, please make sure to follow this official procedure, and not the dubious shortcuts that you may stumble upon elsewhere. |
|
1d |
awarded | Critic |
|
1d |
revised |
how important are mysql's innodb logs? the redo log is on disk |
|
1d |
comment |
how important are mysql's innodb logs? Thanks Derek Downey, I have detailed the role of the redo log. @PeeyushKushwaha log_file_size won't have an impact on memory usage, the redo log is stored on the disk (in innodb_data_home_dir). innodb_log_buffer_size will. |
|
1d |
awarded | Editor |
|
1d |
revised |
how important are mysql's innodb logs? more info about the role of the redo log |
|
2d |
answered | how important are mysql's innodb logs? |
|
Jun 15 |
comment |
How to automate insertion of new column in Mysql table? @Kaii I prefered the original version ;) |
|
May 24 |
comment |
Mysql settings for query_cache_min_res_unit Database tuning involves some king of dark magic. There is no "correct" value for any setting (otherwise the MySQL folks would have made the engine tune itself automagically). It is up to you to find the right setting for your specific database. |
|
Apr 29 |
awarded | Supporter |
|
Apr 17 |
comment |
search for something in the first 1000 records in the table +1 for spotting that a LIMIT clause without an ORDER BY clause has little meaning. |
|
Apr 17 |
answered | search for something in the first 1000 records in the table |
|
Apr 16 |
answered | Backing up MySQL database |
|
Feb 7 |
awarded | Informed |
|
Jan 17 |
awarded | Teacher |
|
Jan 17 |
answered | Mysql: privileges to get access to “mysql” database |
|
Jun 9 |
answered | MySQL upgrade on Ubuntu - any heads ups? |
