8,051 reputation
1822
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 7 months
seen 17 hours ago

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


Jan
26
reviewed Leave Open Best Format to Bulk INSERT/UPDATE Data to SQL SERVER using C#
Jan
26
comment Automobile database logic
No, it doesn't at first glance... any time you have more than one table per "thing" that's usually a bad sign. What do you specifically see as the advantage of this approach? What does it exactly solve? "The data is so inconsistent" is a little vague.
Jan
26
reviewed No Action Needed Automobile database logic
Jan
25
comment The total number of locks exceeds the lock table size, even after increasing buffer pool size
The only variable relevant to this error is innodb_buffer_pool_size because that's where the table of lock structures lives. The first step might be to SHOW GLOBAL VARIABLES LIKE 'innodb_buffer_pool_size'; to verify that your configuration is actually setting the pool as large as you intend... but also, what are you thinking messing around with partitioning on such a relatively small table when you don't even have a primary key or any indexes?
Jan
25
answered Error in upgrade_from_array - mysql: 1064 query: DROP TABLE IF EXISTS filling tables
Jan
24
comment Recover an Innodb mysql database from an EBS on Ec2
Wheeee good ol' apparmor. :( Yeah, I know, I know, but still. Now that I've seen Eric Hammond's article, I see what's going on with the bind mounts and that makes a lot more sense. Hopefully you took an EBS snapshot of that volume before you started trying to recover... and if you didn't... you should still do that before you do anything else.
Jan
24
answered row-based replication with slave triggers
Jan
23
comment How to determine MySQL queries per day?
The Queries global status variable is counting everything since the server was last started... which was SHOW STATUS LIKE 'Uptime'; seconds ago. Many status variables are cleared with FLUSH STATUS; but Queries is not, at least in the test servers I confirmed it on just now, which were MySQL 5.5.19 and 5.6.14.
Jan
23
answered Recover an Innodb mysql database from an EBS on Ec2
Jan
23
comment Why is the index not used?
Please post the table definition and preferably also your explain output so we can verify that you are correctly interpreting them.
Jan
23
comment How can I set a field when original lookup is NULL or isn't in the list?
@LOSTinDB Ah, yes, that does make sense... actually that's an oversight in my answer. It should have read END as regionname in the line right before FROM instead of just END. The original version would not have resulted in a valid column name, which we needed since you were using CREATE TABLE ... SELECT and the column names in the new table were being implicitly created from the results returned by the query. The answer has been updated.
Jan
23
revised How can I set a field when original lookup is NULL or isn't in the list?
CASE needed to result in a valid column name since this is CREATE TABLE...SELECT
Jan
23
answered Auto Increment Primary ID inserting random values
Jan
23
comment Auto Increment Primary ID inserting random values
fwiw, mysql --version does not give you a reliable answer for the version of your server. It gives you the version of the client (14.14) and the version of the server that your client version shipped with (Distrib 5.5.29). SELECT @@VERSION; gives you the server version.
Jan
23
reviewed No Action Needed postgres filtering select based on combination of joins
Jan
23
reviewed Close How to run procedure in Oracle SQL developer
Jan
23
reviewed Approve suggested edit on Testing if temp table exists in iSeries SQL stored procedure
Jan
20
reviewed Close A simple database and Query System?
Jan
20
reviewed Leave Open T-SQL script to perform a compressed backup with maximum compression level
Jan
20
reviewed Approve suggested edit on What is Key Preserved Table concept?