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

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


Dec
23
revised creating table syntax error
Formatted code for readability.
Dec
23
comment Inserting a lot of big numbers into a mysql database
Oh, C? I assumed something less powerful, like PHP maybe. In that case, you could use prepared statements directly, putting the blob into a character buffer... that way, there's no need to escape the "string" ... doing the hex conversion and including UNHEX() would be an unnecessary step. dev.mysql.com/doc/refman/5.6/en/c-api-prepared-statements.html
Dec
23
answered Inserting a lot of big numbers into a mysql database
Dec
20
reviewed Leave Open IF statement in ON clause
Dec
20
comment IF statement in ON clause
@ypercube's first suggestion would probably be easier for the optimizer to use to come up with the best query plan (although I would say add parentheses to clarify the operator precedence). With no context, it's hard to say, but using CASE inside ON (or WHERE, just like using any functions with column values as arguments) could constrain the number of plans the optimizer may be able to consider, limit its flexibility to re-order the tables in inner joins, and could increase the possibility of full table scans.
Dec
20
comment Similar hardware, Same DBconfiguration and Database but different status variables result between Windows and Linux server
qcache_free_blocks is a count of contiguous blocks and tells you nothing about the block size; a totally empty query cache on a newly started server has exactly 1 free block. dba.stackexchange.com/questions/33811/…
Dec
20
reviewed Close Similar hardware, Same DBconfiguration and Database but different status variables result between Windows and Linux server
Dec
20
reviewed Close Migrating Data to A New Database Schema
Dec
20
reviewed Close GROUP BY Returning Different Totals
Dec
20
reviewed Close Companies and addresses MySQL
Dec
19
answered Processlist show most of the queries are sending data for select query
Dec
19
comment Can we protect data form Database Administrator by encrypting the data?
If you have a concern that the database administrator will steal your data, then you have a problem that cannot be solved with technology.
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