| bio | website | google.com |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 8 months |
| seen | Feb 13 '12 at 8:48 | |
| stats | profile views | 25 |
|
Sep 14 |
awarded | Yearling |
|
Feb 2 |
comment |
Quick MySQL Backup (1 file per table) I understand that its out of routine solution but I fail to understand what it brings benefit if I backup individual tables and then copy locally only needed ones? |
|
Jan 31 |
asked | Quick MySQL Backup (1 file per table) |
|
Nov 25 |
accepted | Quick MySQL Backup |
|
Oct 8 |
accepted | Estimating query time |
|
Oct 1 |
revised |
Quick MySQL Backup added 192 characters in body |
|
Oct 1 |
awarded | Commentator |
|
Oct 1 |
comment |
Quick MySQL Backup I was afraid of too much down time but if 3GB even takes 5 minutes, its bearable at the moment. So, I think I should go with the simplest approach. {about your Edit} I cannot go with this option because atm I have only single server. |
|
Oct 1 |
comment |
Strictly only RAM matters? But as you mentioned that max cap is 8GB for MyISAM then it means beyond that RAM resources will not be utilized efficiently? {Sorry for asking this question too late..} |
|
Oct 1 |
asked | Quick MySQL Backup |
|
Sep 25 |
comment |
Estimating query time What keys are you mentioning to enable/disable? |
|
Sep 25 |
revised |
Table partitioning added 93 characters in body |
|
Sep 25 |
answered | Table partitioning |
|
Sep 25 |
revised |
Estimating query time added 81 characters in body |
|
Sep 25 |
comment |
Estimating query time I'll add all info about machine but I thought there might be an SQL way to know query execution time. |
|
Sep 25 |
asked | Estimating query time |
|
Sep 21 |
revised |
Converting CHAR to BIT spelling mistake |
|
Sep 21 |
revised |
Converting CHAR to BIT retag |
|
Sep 21 |
comment |
Converting CHAR to BIT I am using MySQL. |
|
Sep 21 |
accepted | Strictly only RAM matters? |