Reputation
11,645
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 13 32
Newest
 Caucus
Impact
~715k people reached

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
Dec
1
comment Signal in MYSQL procedure with parameters?
Have you tried this with the MySQL command line client? It could be a bug in whatever you're using to connect to MySQL, trying somehow to be "helpful" and suppressing the message in the process.
Dec
1
answered MYSQL Group Replication
Dec
1
answered Converting string to date with timezone adjustment
Dec
1
answered How database buffer pool work?
Dec
1
comment MySQL on dedicated 2048 Linode starting to swap
Is the server doing anything other than running MySQL? (i.e. running the web server, too?)
Nov
28
answered Question on turning on GTID for MySQL master and slaves
Nov
28
comment select on table slows done during update on same table
A query cache this large is a significant liability. Never full or pruned? Doesn't matter -- the time required for maintaining/managing the memory structures for such a large query cache will cost you performance. Something between 32MB and 256MB is probably a lot more reasonable.
Nov
24
revised Migration error: “Invalid date literal detected” when reading decimal
not a MySQL question; removed tag
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.