9,882 reputation
11025
bio website
location Cincinnati, OH
age 43
visits member for 2 years, 3 months
seen 58 mins ago

If you question or otherwise fail to recognize the superiority of the relational model... you're doing it wrong.


Dec
13
comment Should tables with very large records quantities be split into multiple tables
It's most certainly not "absolutely true." Splitting tables can cause problems of its own, as queries should (arguably) never have to blur the line between object identifiers and data... the name of the table where a given row will be found should not typically be something you ever have to construct (e.g. a "transactions_2014" table, for transactions in a particular year, 2014).
Dec
12
reviewed Leave Open How To Strip Hebrew Accent Marks
Dec
12
reviewed Close MySQL Multi Count
Dec
12
reviewed Close Determine the name of the column with a null value nearest the last column
Dec
12
answered MySQL unique index only if column has specific value
Dec
11
answered Use of IN clause within a DELETE command - MySQL
Dec
11
comment Is there a SELECT statement to subtract rows of the same column?
Subtract them from what?
Dec
9
answered What's the approach to figure out reason for mysql crash?
Dec
9
comment Cannot ALTER TABLE
FWIW, rebooting an RDS instance shouldn't be expected to move it to new hardware. Another approach would be to take a snapshot of the database, restore to a new instance of the same size, and try the ALTER TABLE there, on the clone, to see what happens.
Dec
9
comment What's the approach to figure out reason for mysql crash?
What version of Percona Server are you running?
Dec
8
comment Why mysqldump is returning with error 1143: Couldn't execute 'show table status like
Use -f with extreme caution, because it masks errors, by definition, leaving you with an incomplete backup. Last I checked, it incorrectly leaves the exit status of the dump process set to 0, even if errors occurred.
Dec
8
comment How do I create a user-defined aggregate function in MySQL (redux)?
If you know how to write in C, user-defined aggregate functions are very easy, because MySQL does the grouping, then throws row values at it for each group, and asks it for the result... where "it" is the UDF code. Using it would be even easier than what you imagine above. But that's if you're proficient in C/C++, the only UDF environment supported.
Dec
7
answered Index and rows placement within database files
Dec
2
comment Converting string to date with timezone adjustment
Hmmm. Works for me, as shown, so that would suggest that you haven't populated the MySQL time zone tables, so it's failing to do the conversion at the end. dev.mysql.com/doc/refman/5.6/en/mysql-tzinfo-to-sql.html
Dec
1
comment Signal in MYSQL procedure with parameters?
Have you tried this with the MySQL command line client? It could be a bug in whatever you're using to connect to MySQL, trying somehow to be "helpful" and suppressing the message in the process.
Dec
1
answered MYSQL Group Replication
Dec
1
answered Converting string to date with timezone adjustment
Dec
1
answered How database buffer pool work?
Dec
1
comment MySQL on dedicated 2048 Linode starting to swap
Is the server doing anything other than running MySQL? (i.e. running the web server, too?)
Nov
28
answered Question on turning on GTID for MySQL master and slaves