9,008 reputation
11023
bio website
location Cincinnati, OH
age 43
visits member for 2 years
seen 8 hours ago

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


21h
comment MySQL - Database has huge overhead but tables don't
What process did you use to recreate the tables?
1d
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
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
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?
Sep
4
comment MySQL GRANT requiring additional permissions
No, that's what WITH GRANT OPTION does. Allowing a user to grant privileges is only one step removed from giving that user the privilege, so you wouldn't really gain any real security if what you were trying were possible. If it were, and that account were compromised, it could just be used to give privileges to a different account, and the data would still be exposed.
Sep
4
comment MySQL replication - slave hangs during ALTER table or BULK update - v5.1.71
I'm not saying that... only that OP needs to understand the implications fully before attempting it... and needs to fully understand the apparent "hang" events before proceeding.
Sep
3
comment MySQL replication - slave hangs during ALTER table or BULK update - v5.1.71
This advice, while technically valid in some cases, seems premature or a little dangerous, here... we don't have any evidence that the slave is actually "hanging" and I would suggest that it's just taking a long time to complete an operation, and STOP SLAVE in the middle of such an operation will eventually work. Not logging operations, timed improperly with the parallel updates, could break replication.
Aug
22
comment MySQL replication working, but data is out of date
Replicate-*-DB options, and others like them that prevent replicating the entire server are extremely problematic unless you absolutely understand how they work and their implications, especially when the master's binlog_format is not set to ROW. Have you read and thoroughly understood this and this‌​?
Aug
21
comment How to make MySQL log to 2 seperate remote servers?
Wow... I wondered why that was where it was configured, instead of [mysqld], and I never noticed until just how this is actually implemented inside mysqld_safe: cmd="$cmd 2>&1 | logger -t '$syslog_tag_mysqld' -p daemon.error" ... where $cmd is the command that starts the MySQL server daemon. It's a classic Unix mix of simple, clever, effective... and sketchy. :)
Aug
19
comment MySQL replication: Understanding content of binlog
This is a row-based event, and the "statement" is in the BINLOG blocks. You can use the --verbose --base64-output=decode-rows options to decode it into pseudo-sql to see the rows in a human-readable format. What's in the binlog after the COMMIT?
Aug
9
comment Is it Possible to Recover Data from a BLACKHOLE table?
Of course, if binlogging is enabled... the data is actually all there if the logs haven't been purged, and there is a possibility of recovering it by replaying them from just the right point on another system.
Aug
6
comment Why Percona MySQL is crashing again and again
It's probably worth your time to thoroughly test the server's RAM, and if that's good, check the disks for bad blocks.
Jul
29
comment Replication of a remote MySQL database to local MySQL database
Replication seems unlikely to be a possibility in this case, depending on what exactly OP means by "shared hosting."
Jul
23
comment MySQL Code Works in PHPMyAdmin but not in PHP Page
@Justin, welcome to DBA.SE... Stop, and research SQL injection vulnerabilities. You should never concatenate your variables into queries like this. There are massive potential security holes waiting for you. Even if the values come from a safe place now, that's not a good reason to build queries this way. xkcd.com/327