network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 4 months |
| seen | Feb 14 at 16:56 | |
| stats | profile views | 30 |
|
Jun 6 |
awarded | Popular Question |
|
May 20 |
awarded | Popular Question |
|
May 15 |
awarded | Notable Question |
|
Apr 10 |
awarded | Popular Question |
|
Feb 21 |
awarded | Popular Question |
|
Feb 6 |
comment |
MySQL crashes with Signal 8 after “Table has no partition for value” error I mean the centos version itself if you see are mostly using some older version of php and mysql this I read due to stability. |
|
Feb 5 |
comment |
MySQL crashes with Signal 8 after “Table has no partition for value” error I am on centos machine and normally they discourage for upgrade fear of this sort of problems. |
|
Feb 3 |
comment |
MySQL crashes with Signal 8 after “Table has no partition for value” error ok I have now build back the partition and this was the cause of it.But this message [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it is still there so you suggest to upgrade is it? |
|
Feb 1 |
asked | MySQL crashes with Signal 8 after “Table has no partition for value” error |
|
Jan 30 |
comment |
Best option to back up mysql innodb partition thank you for the link so I will just yum install it and what is next after that any special setting for it to start it? |
|
Jan 22 |
comment |
Best option to back up mysql innodb partition should I provide anymore extra information this? |
|
Jan 21 |
comment |
Best option to back up mysql innodb partition I am using Centos 6.3. So what else must I be prepared with ? Can I just download the partition easily and recover them thereafter? Reading further this tool can also do a backup is it? But I read some where that it only run only percona mysql is that true? |
|
Jan 20 |
comment |
Best option to back up mysql innodb partition yes I am now confused between the percona tool and mysqldump I do not know how to make the decision now? So in order to try xtrabackup I need to install the pt toolkit and what are the other tools needed? |
|
Jan 18 |
comment |
Best option to back up mysql innodb partition any help on the partition backup and deletion only? |
|
Jan 16 |
comment |
Best option to back up mysql innodb partition so if I am going to partition my table I would prefer to dump only those old partition and leave the existing ones in the system how should I tweak the script given by you. |
|
Jan 16 |
comment |
Best option to back up mysql innodb partition As per now the data size is just 500Mb but it will sure to go few GB. I am preparing for future when the size grow and how to handle it. So some of the table I anticipate to be few million therefore I am going to partition them by month is that fine or you suggest some other mechanism? |
|
Jan 16 |
comment |
Best option to back up mysql innodb partition my first worry I read some places it says that mysqldump can cause locking if run on live systems? I just have moderate number of tables to be dump I guess not more then 15 tables. I prefer to do one by one to avoid locking or any other problem. Just before the delete of partition if just want to view the data in that partition is that possible? |
|
Jan 16 |
comment |
Best option to back up mysql innodb partition So far just few million of lines for 2 of the tables the rest are below million. |
|
Jan 16 |
accepted | Max and group by query help |
|
Jan 15 |
asked | Best option to back up mysql innodb partition |
