network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 10 months |
| seen | 15 hours ago | |
| stats | profile views | 40 |
|
May 14 |
answered | How to increase fast backup and restore of 500GB database using mysqldump? |
|
May 14 |
answered | Having too many connection problem |
|
May 14 |
comment |
Having too many connection problem What is the max_connections set to? Is it a new problem that you face all of a sudden from already existing application ? Check the time that it takes to complete each cron threads triggered. |
|
May 9 |
comment |
Master updates Slave but not Master itself @Mike - I didn't see any such error type in error log. It has info about recovery as Recovering after a crash using mysql-bin Starting crash recovery... Crash recovery finished. |
|
May 6 |
comment |
Master updates Slave but not Master itself No assumptions I would like to keep here for Crash recovery. @NathanJolly - Slave takes information from Master's binlog, and that is how Slave DB server gets updated. ( I can get convinced when before flushing to disk the DB server got crashed and that is why I get previous internval data on Master) . But what about the lines that found missing for me in Master binlog?? |
|
May 3 |
awarded | Promoter |
|
May 2 |
comment |
Master updates Slave but not Master itself Ok my server parameters are sync_binlog = 0 and innodb_flush_log_at_trx_commit = 2. Now if I need to follow this logic, then would it be possible for Master to remove lines from what it had committed in binary logs after restart? |
|
Apr 30 |
awarded | Custodian |
|
Apr 30 |
reviewed | Approve suggested edit on Master updates Slave but not Master itself |
|
Apr 30 |
asked | Master updates Slave but not Master itself |
|
Apr 16 |
comment |
Myisam Mysql server crashed what do you find in err log? |
|
Apr 10 |
asked | Slave lags ONLY when long running sql runs |
|
Apr 10 |
revised |
Mysql innoDB write operations are extremely slow deleted 1 characters in body |
|
Apr 10 |
answered | Mysql innoDB write operations are extremely slow |
|
Apr 4 |
asked | Mysql DB server hits 400% CPU |
|
Apr 4 |
accepted | Master Slave Replication in Mysql |
|
Apr 3 |
awarded | Critic |
|
Apr 3 |
comment |
ibdata1 grows exponentially when innodb_file_per_table is configured I didn't understand you. What are the steps you have taken to convert the Database server in PER-TABLE model. |
|
Apr 3 |
comment |
ibdata1 grows exponentially when innodb_file_per_table is configured Have they configured existing DB data to per-table model? If yes, can you explain how did they configure to per-table? |
|
Apr 3 |
comment |
ibdata1 grows exponentially when innodb_file_per_table is configuredLet me know if you ever heard of this.(heard of what?) |
