Reputation
457
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 8 17
Impact
~57k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Apr
15
asked MySQL Slow_log LOCK_TIME shows wrong values
Feb
23
comment Getting Waiting for table metadata lock for select statements
@Giovanni, I checked the table INNODB_TRX, I found only select statements which are showing in SHOW PROCESSLIST. I checked innodb_lock_wait_timeout, it is 50 seconds
Feb
23
comment Getting Waiting for table metadata lock for select statements
@Rick, No dump is happening at this time. I checked global autocommit status and it is ON.
Feb
20
comment Getting Waiting for table metadata lock for select statements
I saw at SHOW PROCESSLIST itself, and there are no statements other than SELECT statements. I don't use LOCK TABLE.
Feb
20
asked Getting Waiting for table metadata lock for select statements
Feb
5
asked How to track only DDL statements executed in MySQL
Jan
22
awarded  Popular Question
Jan
7
comment Load Balancer for MySQL MASTER MASTER Replication
Can you please list out any limitations on using LB directly on MySQL servers like Transaction limitations, so that we will take care of these..
Jan
7
revised Load Balancer for MySQL MASTER MASTER Replication
added 59 characters in body
Jan
7
comment Load Balancer for MySQL MASTER MASTER Replication
I need Load Balancing at DB level, not at application level. That is one application connects to LB and LB sends request to DB. So will HAProxy supports this? and what are the limitations using this?
Jan
7
comment Blob datatype issue with log file
My Total DB size is less than 1 GB and I had removed all the BLOB columns. Even after removing, I am getting error.
Jan
7
comment Load Balancer for MySQL MASTER MASTER Replication
Ahmad, We have already setup MySQL MASTER-MASTER replication. We require information on Load balancing on these 2 MySQL servers.
Jan
6
revised Load Balancer for MySQL MASTER MASTER Replication
edited tags
Jan
6
asked Load Balancer for MySQL MASTER MASTER Replication
Jan
1
comment Blob datatype issue with log file
I had changed all the columns whose datatype from BLOB to TEXT. Now there are BLOB datatype tables only in 'mysql' schema. Even after converting the datatype, I am observing the above error message.
Jan
1
revised Blob datatype issue with log file
added 210 characters in body
Jan
1
awarded  Notable Question
Dec
4
comment Blob datatype issue with log file
Yes I understood your point. But question is why should we need to increase the log_file_size if the data of blob datatype increases. Also, it is recommended to limit the log_file_size to be less than 4 GB as the log file is using while crash recovery. Please let me know if there is any work around for not increasing log file size even if blob data increases.
Dec
3
comment Blob datatype issue with log file
If size of blob table increases to 100 GB, should I need to crease my log file size to 10 GB. Now this is staging databases, once after migrating the same to production, I can't stop MySQL service. In that case, what should I do?
Dec
3
comment Blob datatype issue with log file
OS - Linux MySQL - 5.6.21