Reputation
467
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 9 21
Impact
~76k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
11h
comment MYISAM can't create table: Row size too large
Hi Ahmad, First I would like to create table in MyISAM. Even, I followed the steps as per the link and changed the innodb_log_file_size to 10GB, still it is not working. Mentioned in step 6.
11h
asked MYISAM can't create table: Row size too large
Dec
1
awarded  Popular Question
Oct
7
awarded  Popular Question
Sep
25
awarded  Taxonomist
Sep
14
awarded  Popular Question
Sep
7
asked How to calculate MySQL Transactions per second
Aug
3
awarded  Caucus
Jun
18
comment MySQL server installation file download for windows
Yes but this can't be done by deployment team. So why I am asking for direct installation file which is user friendly for all.
Jun
17
comment MySQL Upgrade on Windows
Nawaz, my plan is the same what you mentioned, but I need if any precautions to be taken care other than mysql users.
Jun
17
comment MySQL server installation file download for windows
Using MySQL installer, we are not allowed to select the changing the path of data directory. So we are checking for installation file. Also server installation is to be taken care by deployment team who is not having idea on changing the data directory path, so looking for direct installation file.
Jun
17
revised MySQL Upgrade on Windows
added 162 characters in body
Jun
17
comment MySQL Upgrade on Windows
This is the better way, but I am having DB of huge size and taking backup and restoring backup will take time. But we are not having much downtime. So wanted to have faster approach.
Jun
17
asked MySQL Upgrade on Windows
Jun
17
asked MySQL server installation file download for windows
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