368 reputation
716
bio website dotancohen.com
location
age 37
visits member for 3 years, 5 months
seen Jan 27 at 7:47

Jan
26
asked Will a covering index save a table hit if only the commoly-used length of a `text` field is indexed?
Jan
26
accepted Reusing covering index for fields in FROM, from another query's index
Jan
26
asked Reusing covering index for fields in FROM, from another query's index
Jan
12
awarded  Notable Question
Jan
12
awarded  Notable Question
Dec
20
comment Why do we use Group by 1 and Group by 1,2,3 in SQL query?
Use order by 1 only when sitting at the mysql> prompt. In code, use ORDER BY id ASC. Note the case, explicit field name, and explicit ordering direction.
Dec
10
awarded  Notable Question
Dec
9
comment Cannot ALTER TABLE
Sure enough, the issue was disk space. Thanks.
Dec
9
accepted Cannot ALTER TABLE
Dec
9
comment Cannot ALTER TABLE
@Michael-sqlbot: Thank you. I understand that rebooting an EC2 instance does move it, so I assumed that is valid for RDS as well.
Dec
8
comment Cannot ALTER TABLE
Yes, I think so too. However the console shows that there is space. I've now filed an issue with Amazon support.
Dec
8
comment Cannot ALTER TABLE
Thank you, in fact I did try this. I could make the new table, but in populating it I get the error he table 'replacement_tasks' is full.
Dec
8
comment Cannot ALTER TABLE
Thank you. When I try to repair the table I get the message The storage engine for the table doesn't support repair. And since this is a managed server in RDS, I cannot access the configuration file.
Dec
8
asked Cannot ALTER TABLE
Nov
24
awarded  Popular Question
Sep
12
awarded  Popular Question
Sep
11
accepted ON DUPLICATE KEY UPDATE faster than UPDATE
Aug
24
accepted Set MySQL option to restore MySQL server after deleting ibdata1
Aug
24
comment Set MySQL option to restore MySQL server after deleting ibdata1
Thank you. I've bitten the bullet and installed an older version of the OS (Ubuntu 12.04). Thank you, I have learned much from this post.
Aug
18
comment Cannot configure nor start MySQL
Yes, of course! Only the grep process itself shows up.