10,377 reputation
11127
bio website
location Cincinnati, OH
age 43
visits member for 2 years, 4 months
seen 1 hour ago

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


Dec
19
answered storing query results in a variable in mysql and using it in another query
Dec
18
revised MySQL audit storing application user ID
typos, add docs link
Dec
18
answered MySQL audit storing application user ID
Dec
17
comment After mysql server restarts I cannot see my own database
Why did you rename my.cnf?
Dec
14
comment ERROR 2013 (HY000) When long string data managed
"nothing seems to work" is a somewhat vague description of what you tried and didn't work. Where, specifically, did you change the setting for max_allowed_packet? There are separate settings for server and client, and Lost connection to MySQL server during query (I assume is the error message you see, you didn't include the actual text) suggests a client setting that's too small.
Dec
14
comment Could not start mysql or MariaDB. Permissions were ok, but mysql-bin.index permission error
What about the directory permissions on /var/lib/mysql itself? Error 13 on Linux is "Permission denied." (Use $perror 13 from the shell prompt to check error code 13)
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