Reputation
3,967
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 9 21
Newest
 Enlightened
Impact
~188k people reached

Sep
26
revised Using an index for both asc and desc on a string column
added 625 characters in body
Sep
25
comment Using an index for both asc and desc on a string column
It's a pretty odd case.
Sep
25
comment Using an index for both asc and desc on a string column
@Cratylus, I just copied the block of codes from the latin1_general_ci collation in the same file, and reversed the order.
Sep
25
comment Speed Up Index Creation in MySQL
I guess I assume everyone using MySQL is using a Linux server. Because for the most part, they are. Running a Windows server on a VM seems to me like fighting a boxing match with both hands tied behind your back.
Sep
25
comment Speed Up Index Creation in MySQL
See msdn.microsoft.com/library/dn197896.aspx, it confirms that you only get 300 IOPS per disk in Azure. That's really disappointing.
Sep
25
comment Speed Up Index Creation in MySQL
Okay then go with the tmpfs solution. Based on this and your other question, it sounds like your VM disks are really slow.
Sep
25
answered Speed Up Index Creation in MySQL
Sep
25
revised Using an index for both asc and desc on a string column
added 4265 characters in body
Sep
24
revised Using an index for both asc and desc on a string column
added 148 characters in body
Sep
24
answered Using an index for both asc and desc on a string column
Sep
24
answered WARNING Error checking mysqldump version Error retrieving version from mysqldump.exe: mysqldump: unknown option '--no-beep' (exit 2)
Sep
12
comment Amazon: How to change database name in Amazon RDS MySQL?
Aha, I tried it, and that doesn't work if you have triggers. I get an error: ERROR 1435 (HY000): Trigger in wrong schema
Sep
12
comment Amazon: How to change database name in Amazon RDS MySQL?
Why not just RENAME TABLE tablename TO db2.tablename; for each table? Then there shouldn't be any shipping of data back and forth.
Sep
9
revised Which database technologies to consider for a data search application?
added 2344 characters in body
Sep
7
revised Which database technologies to consider for a data search application?
edited tags
Sep
7
answered Which database technologies to consider for a data search application?
Sep
4
comment MySQL does not start - Ubuntu 14.04 LTS after migration to new disk
At this point I'd try using sudo -u mysql -g mysql and see if you can read and write files under the datadir. It could still be permission problems in the ancestor directories, or it could be AppArmor interfering and giving misleading error messages. Try disabling AppArmor temporarily and see if that makes the errors go away.
Sep
4
revised MySQL does not start - Ubuntu 14.04 LTS after migration to new disk
added 175 characters in body
Sep
4
answered MySQL does not start - Ubuntu 14.04 LTS after migration to new disk
Sep
4
comment Calculating RAM requirements for an in-memory database
Check the total resident memory used by all processes by summing the RSS column from ps. You can also use free to check RAM in use. Also don't forget to leave some spare RAM for filesystem buffers.