Reputation
Next tag badge:
97/100 score
57/20 answers
Badges
11 78 177
Newest
 Enlightened
Impact
~6.7m people reached

Apr
21
comment How to solve “Can't connect to local MySQL server through socket” error?
What solutions have you tried ???
Apr
20
comment MySQL 5.6 upgrade - reducing code changes / developer burden
These were the actual steps I performed for a client months ago in dev and production. Other than having to explicitly set sql_mode to a blank string to make backward compatible with code that worked in MySQL 5.5 now operating in MySQL 5.6, there isn't anything else.
Apr
20
comment Why is Database Administration so hard?
You are still young. You got plenty of time to learn the social (dba.stackexchange.com/questions/2471/…) and technical (dba.stackexchange.com/a/2913/877) aspects of being a DBA.
Apr
17
comment MySQL Install on Windows 8.1 hangs at server restart
I just installed MySQL 5.6.24 with the no-install ZIP on my Windows 8.1 laptop. I have no problems whatsoever.
Apr
17
comment MySQL Install on Windows 8.1 hangs at server restart
Personally, I have never been a fan of the MSI Installer. I always install MySQL using the no-install ZIP file. I have Windows 8.1 running 5.6.21. I am going to install 5.6.24. I'll let you know how it goes.
Apr
15
comment Mathematical equality of two SQL statements
@a_horse_with_no_name is correct when it comes to unique keys. For all others, It is possible for select * from foo where id = 4 and select * from foo where id = 2 to have two different execution plans if 1) the index stats are not up-to-date and 2) even if the index stats are up-to-date, the key distribution of id is lopsided (provided id is not a unique key).
Apr
10
comment Delete from table where multiple fields match select subquery from other table
@Pacerier that's how I learned it 20 years doing Microsoft Access development. MySQL accepts it. So, it's just an old habit.
Apr
9
comment Speeding Inserts of longtext or longblob columns
I would not have those in production. In your particular case, it's OK since you are doing a migration.
Apr
9
comment How do I give root@localhost permission to grant privileges in MySQL?
I just added a manual fix to the mysql.user table.
Apr
9
comment How do I give root@localhost permission to grant privileges in MySQL?
Go to my post dba.stackexchange.com/questions/16397/… and see all the columns each version of MySQL has for mysql.user
Apr
9
comment How do I give root@localhost permission to grant privileges in MySQL?
You could add the missing columns manually to mysql.user
Apr
9
comment How do I give root@localhost permission to grant privileges in MySQL?
Ah ha. I know the problem. Please stand by ...
Apr
9
comment How do I give root@localhost permission to grant privileges in MySQL?
Please run the following query : select count(1) UserTableColumnCount from information_schema.columns where table_schema='mysql' and table_name='user';. What number does it report ???
Apr
9
comment Speeding Inserts of longtext or longblob columns
How much RAM on the DB Server ???
Apr
9
comment Speeding Inserts of longtext or longblob columns
What version of MySQL ?
Apr
8
comment Why is “select join insert” so much faster than “loop insert”?
@RickJames I know I sound silly saying that. I'll try to rephrase ...
Apr
8
comment MySQL query INSERT INTO … failed - The Table “x” is full
Yes that's the default size for MySQL 5.1
Apr
7
comment MySQL query INSERT INTO … failed - The Table “x” is full
@RickJames To be honest with you, I could be totally wrong on this if InnoDB is not being used. It could be a big MyISAM tmp table in /tmp.
Apr
7
comment MySQL query INSERT INTO … failed - The Table “x” is full
@RickJames Yes to both. 1) InnoDB internal chokes on TEXT/BLOB with small logs. Wrote about this before (dba.stackexchange.com/a/2300/877) because I learned about it from someone's ServerFault post (serverfault.com/a/3979/69271). 2) When your disable fast shutdown, everything MVCC and its grandmother are fully purged. The logs can actually be deleted afterwards.
Apr
7
comment MySQL Count rows from another table for each record in table
@RickJames Using INNER JOIN or JOIN will make the students with Total 0 disappear. In the question, the desired output includes the 0's. LEFT JOIN is thus required. LEFT JOIN ... COUNT(*) does not work because of non-nulls from the student columns of the SELECT, which makes the 0's come out as 1. LEFT JOIN ... COUNT( any-column-from-attendance-table ) makes this query work for the desired output.