2,969 reputation
11137
bio website
location
age
visits member for 3 years, 3 months
seen Dec 23 at 0:13

Dec
10
comment Cannot Run SQL INSERT in MySQL
Also given his final version output it looks as though sudo is not required to just execute the mysql client.
Dec
9
reviewed Approve Do agile software development approaches apply to SQL?
Dec
6
awarded  Popular Question
Dec
5
reviewed Reject Sql Server 2012 Change Data Capture weird behaviour
Dec
5
reviewed Reject DB2 UPDATE TRIGGER
Dec
5
reviewed Approve Slow query on large table after new column is added
Dec
3
awarded  Nice Question
Dec
3
reviewed Reject Is it possible for a MySQL database to have duplicate tables with the same name?
Nov
24
reviewed Approve Possible RMAN orphan files in backup directory
Nov
24
reviewed Approve How to pass output of one stored procedure to the input of another
Nov
24
reviewed Approve Professor told us to store serialized Java objects as blobs instead of defining relational tables
Nov
18
answered Question on having a MySQL 5.1 replicate from a MySQL 5.6 DB
Nov
18
reviewed Approve Determine last time a mysql table was accessed (i.e. SELECT'ed)
Nov
18
reviewed Reject “show create table” output with out “show”?
Nov
14
answered How mysql (innodb) handles auto increment column
Nov
13
reviewed Approve Preventing PostgreSQL from starting on boot in Ubuntu
Nov
12
answered MySQL Loop Through Each Row
Nov
11
reviewed Approve Foreign Key Error
Nov
11
comment MySQL InnoDB + high table creation-destruction rate
If you're porting everything over into mysql perhaps now is a good time to work with the rest of the engineering team to figure out if your current paradigms of 16 million tables being created and destroyed makes sense before just blindly translating the usage pattern.
Nov
11
comment MySQL InnoDB + high table creation-destruction rate
If your db isn't running file per table currently the only way to convert is to reload into a new mysqld running w/ that config set from the get go.