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

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


6h
comment Maximum function nesting level of '100' reached, aborting! in C:\wamp\www\installation\framework\database\driver\mysqli.php on line 134
This doesn't look like a MySQL error. See also stackoverflow.com/questions/8656089/…
6h
comment Mysql binlogs exists, show binary logs is empty
What does SELECT @@LOG_BIN_INDEX; return? Is that the same path and name as the "mysql-bin.index" file you're examining?
6h
answered mysql query from 1st domain and insert in 2nd domain
1d
comment Inserting a lot of big numbers into a mysql database
No... the point of that exercise is to verify what was really inserted. Is it getting corrupted on the way into the database or on the way out? If HEX() returns the hex representation of the binary data you intended to insert, then the problem you see now is related to retrieving, rather than to storing, the correct values. If the response using HEX() contains the stray backslashes (in hex, of course) then the issue is still on the insert side.
1d
comment Inserting a lot of big numbers into a mysql database
If you SELECT HEX(data) FROM ... using the MySQL command line client, do you see those 0x5C values represented, too? Or could they be an artifact of what you're using to query?
2d
comment MySQL InnoDB Deadlock For 2 simple insert queries
What else did you do in each transaction before hitting the deadlock?
2d
comment #1025 - Error on rename of table errno: 150 : Table was deleted while tried to assign foreign key
I've seen developers get MySQL 5.1 servers with built-in InnoDB into this state, though exactly how they managed it eluded me, and I don't know whether it's limited to 5.1 or if it's still possible with the "plugin" InnoDB or on later releases. It's not a bad data dictionary entry for a table so much as bad foreign key constraint data that survives some kind of failed operation. I've been able to get the server happy again by converting the visible table "from and to" InnoDB with ALTER TABLE table2 ENGINE=InnoDB, without a restart.
2d
answered creating table syntax error
2d
reviewed Edit creating table syntax error
2d
revised creating table syntax error
Formatted code for readability.
2d
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