9,436 reputation
11025
bio website
location Cincinnati, OH
age 43
visits member for 2 years, 1 month
seen 14 hours ago

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


Sep
30
awarded  Explainer
Sep
29
comment MySQL dies when trying to access a specific database
"Lost connection to MySQL Server..." followed by can't connect message ending in (111) almost certainly means that whatever is happening is actually crashing the server (typically, it will recover and become available on its own, depending on the nature of the crash). Please check the MySQL server's error log and update your question based on what you find there.
Sep
27
reviewed Close Why does mysql give different result for this summations?
Sep
27
reviewed Leave Open Storing a Shipping Address Best Practice
Sep
24
awarded  Autobiographer
Sep
23
answered Dynamic my sql error
Sep
18
comment MySQL - Database has huge overhead but tables don't
What process did you use to recreate the tables?
Sep
18
comment What happens if the mysql database's innodb log files are lost?
@Rafael if the server was stopped gracefully with innodb_fast_shutdown set to 0, and apparently 1, the data in the logs should have already been committed to ibdata1 file and *.ibd files, so there should be no data loss.
Sep
16
answered Replicated timestamp column in different timezone
Sep
16
answered Create t2 instance and connect via Wokrbench
Sep
15
awarded  Yearling
Sep
12
comment Is it possible to copy a dev. database schema over a prod. one, but keep the prod. database' data?
Absolutely. There is simply no safe way to "diff" the schemata of two servers and craft the DDL to make one identical to the other, if there is data in the tables. I designed my own tool for this, and it ends up "commenting out" many of the statements it generates, since there isn't a conclusive way to determine that they are safe. Column drop/add or column rename? Indistinguishable.
Sep
11
comment How many Slaves Can I to replicate with one Master Server with MySQL?
If stop/start clears the problem for a while, and the slaves do have different ids, then it might be this: dba.stackexchange.com/a/71846/11651
Sep
10
comment Amazon: How to change database name in Amazon RDS MySQL?
You have not mentioned which RDBMS your RDS instance is running (MySQL? Oracle? MSSQL? Postgres?) and that information is relevant, if you are asking how to rename one database in an RDS Instance. I assumed you were asking how to rename the instance... the word "database" is ambiguous, here.
Sep
9
comment Amazon: How to change database name in Amazon RDS MySQL?
This question appears to be off-topic because it is easily answered by checking the documentation: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…
Sep
9
comment MySQL replication - slave hangs during ALTER table or BULK update - v5.1.71
Agreed. A 5.1 >> 5.6 migration is also slightly delicate, since officially the migration path means going to 5.5 first, with the slave always running the same version or a newer version of the master. +1
Sep
6
comment How to “warm up” a cold DB server?
@moin thanks. Interesting. Also noteworthy, Amazon Web Services just announced a feature that provides automatic re-warming of the InnoDB Buffer Pool after reboot on RDS for MySQL: aws.amazon.com/about-aws/whats-new/2014/09/03/…
Sep
6
comment Replication - Binary log parsing(Tableid generation, ON DELETE CASCADE handling, Changed columns for update event)
@bin as I recall, I chose DESCRIBE TABLE because it gave me everything I needed and I concluded that it was a more lightweight call than querying information_schema. My project is still alive, but getting ready for version 2, which (naturally) will be almost a total rewrite, with event-driven, non-blocking, asynchronous everything, so I can be parsing packets and emitting events at the same time. Large events will also go automatically to a temp file rather than eating memory.
Sep
5
answered For two triggers(before insert and after insert),is it allowed for you to use where in the NEW keyword
Sep
5
comment MySQL table replication on the same server
Depending on why you want to do this, there may be (different) way... what issue are you trying to solve?