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

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


Nov
21
answered Running two DELETE statements causes a syntax error
Nov
20
comment schema for mysql database with 30million rows
You do realize that you have a seriously, seriously flawed schema here... right? Money should never be stored as FLOAT (nor as DOUBLE) and you should not be redundantly storing text for things like menu item or employee name.
Nov
12
comment Data on the slave becomes inconsistent after couple of days
@NawazSohail MySQL 5.0 is apparently still running on the master, so there's no possibility of GTIDs.
Nov
10
reviewed Close MySQL : Cannot add to the replication Ignore list
Nov
10
reviewed Close Division Email Template DB Design
Nov
6
comment Steps or evaluation order of the SQL statement
zazzle.com/sql_queries_explained_coffee_mug-168973002678226909 (not a plug, no affiliation)
Nov
4
comment Differing AUTO_INCREMENT values between 5.1 vs 5.6 slaves
SELECT @@auto_increment_increment, @@auto_increment_offset; on all servers, and compare?
Nov
4
comment Differing AUTO_INCREMENT values between 5.1 vs 5.6 slaves
Curious... what is the master's binlog_format set to? In the table above, what's the largest id actually present, and are the tables InnoDB?
Nov
2
comment Moving MySQL to another server without updating connection strings
Wow... famous last words: "What could possibly go wrong?"
Oct
31
comment MySQL stops unexpectedly on CentOS 6.5 with WHM/Cpanel after migrating server with transfer tool
You'll need to monitor the server. It's likely not mysql that is the memory hog, it just looks, to the kernel, like a good candidate for killing, when memory pressure is high on the system as a whole. A certain popular major name web server that forks off multiple processes serving one concurrent request each is known for causing this condition under load. Before upgrading the instance class, consider that a more stable alternative is keeping database and web server on separate instances. There are other questions and answers here that should give some helpful hints on this topic.
Oct
31
comment SELECT in federated table is to slow
@GeoVIP it depends on the future growth of the remote tables, the cost of data transfer, who controls the other server, how often the remote tables have changes, and likely other factors. For now, it seems like a pretty good improvement. :) Did you just add an index or also try my alternate query on your existing setup? If all you did was add an index, you're probably good. The query I proposed was the part I referred to as not ideal for an interactive site.
Oct
31
comment Last synchronization time between master and slave (replication)
Define "goes down."
Oct
31
comment MySQL stops unexpectedly on CentOS 6.5 with WHM/Cpanel after migrating server with transfer tool
The problem occurred before the first line of error log that you posted. That line is a symptom. The rest is recovery. cat /var/log/messages | grep kernel. The usual suspect is a web server running on the same machine, and the kernel is killing mysql when the web server starts making excessive demands for more and more memory.
Oct
30
answered SELECT in federated table is to slow
Oct
29
answered MySQL UDF - wrong ELF class: ELFCLASS32
Oct
29
comment Moving a large MySql database(Over 15 GB) from server to server mysqldump
Not sure where you got the information about -r causing row-by-row read and saving memory. -r is an alias for --result-file -- specify the output filename: dev.mysql.com/doc/refman/5.6/en/… ... but mysqldump doesn't use a lot of memory, at any rate.
Oct
29
comment Moving a large MySql database(Over 15 GB) from server to server mysqldump
Don't forget the --events --routines and --compress options in mysqldump.
Oct
29
comment Determine if queries have small or large results
Each table involved in any cached query takes 1 block (no matter how many queries against the table are cached), each query takes 1 block, and each result takes 1 block... so there's the origin of your 2.6 average. However, query cache block size is dynamic, and contiguous chunks of free query cache memory are counted a only 1 block... so the free blocks and used blocks don't add up to a meaningful number that you can add together or multiply by. Illustrated here: dba.stackexchange.com/questions/33811/…
Oct
24
reviewed Close T-SQL Parsing XML escaped in format %3E (less than)
Oct
24
reviewed Leave Open SQL Server stuck in single_user with auto_update_statistics_async on