meta user
network profile
| bio | website | |
|---|---|---|
| location | Cincinnati, OH | |
| age | 42 | |
| visits | member for | 8 months |
| seen | 6 mins ago | |
| stats | profile views | 101 |
If you question the superiority of the relational model... you're doing it wrong.
|
Apr 11 |
comment |
how to resolve ELFCLASS32 error in mysql for UDF lib_mysqludf_sys.so "that file not present" -- what file? Can you be more specific? |
|
Apr 11 |
answered | Is there a workaround for lack of support of cascade triggers with MySQL? |
|
Apr 9 |
answered | Should I disable triggers, timestamps in a slave in mysql? |
|
Apr 9 |
awarded | Fanatic |
|
Apr 6 |
answered | Idle connection plus schema-modifying query causing locked database |
|
Apr 5 |
answered | How do I find an invalid utf8 character “somewhere” in my MySQL/trac database |
|
Apr 5 |
revised |
Shortest method to upload database to server untagged mysql, not a mysql question |
|
Apr 3 |
answered | event scheduler not called |
|
Apr 3 |
comment |
mysql: how many disk seeks were made for a select query The link you posted only discusses indexed scenarios, not full table scans. Are you asking whether MySQL has a way to tell you, for a specific query, how many disk seeks were actually required? The question is unclear. |
|
Apr 2 |
reviewed | No Action Needed extproc env variables oracle 11g |
|
Apr 2 |
reviewed | Reviewed How to create Mysql Replication on mysql 5.5 master-slave |
|
Apr 2 |
comment |
Ubuntu / MySQL / Percona XtraBackup gives error “sh: 1: xtrabackup_55: not found” Dumb question, but have you tried this while not sitting inside /usr/bin? i.e., cd to a different directory first. |
|
Mar 30 |
answered | MySQL - ERROR 1045 (28000): Access denied for user |
|
Mar 30 |
comment |
mysql second slave not syncying while first slave works fine Of course you should expect to get different answers on a slave that's lagging. You would get the answer you would have gotten from the master 69,594 seconds ago. If you're not getting that answer, either, then your slave didn't actually start out synched. How did you set up this slave? Binary data copy from S1, mysqldump, or something else? |
|
Mar 29 |
answered | MySQL: parallel restores at same time from backup files? |
|
Mar 28 |
answered | MySQL subqueries that use range based on values of main queries don't use indices properly |
|
Mar 27 |
comment |
Is it possible to have extra tables in a Slave with MySQL Replication It is totally possible and should work without a problem on the slave in a simple/common/default configuration, so please explain what you mean by "this breaks the replication system." Do you mean theoretically? Or in your actual system? In what way does it break? |
|
Mar 25 |
comment |
Mysql - Problem speed of access on query (Low latency query sometime) Using MEMORY on master and InnoDB on slave is not sound advice for recovery purposes, because the first access of a memory table on the master, after restart, will trigger removal the contents of the table on the slave so that it's empty just like the one on the master... so this won't work. dev.mysql.com/doc/refman/5.5/en/…... and in RDS, you can't do this anyway. |
|
Mar 24 |
answered | MySQL export user with semi-colon “;” on the end |
|
Mar 24 |
answered | Cascading Inserts in MySql |
