Reputation
10,893
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 12 30
Newest
 innodb
Impact
~601k people reached

Jan
1
comment mysql multi-source replication to single slave from Debian repo's?
CHANGE MASTER ... FOR CHANNEL and START SLAVE ... FOR CHANNEL would both be statements executed at the slave. The channels seem to be only arbitrary text labels for replication configuration, and only used on and meaningful at the slave, but if you encounter something that contradicts that, feel free to ask.
Jan
1
comment When try to do Mysqldump Backup from console then getting such as error
There is no issue related to connection -- well, yes, there is. Error 10061 is absolutely an issue related to the connection. Either your my.ini has spurious or inconsistent configuration in the [client] or [mysqldump] vs. the [mysql] section, or you are passing an argument to mysql (when you start the command line client) that you also need to pass to mysqldump, such as host or port.
Jan
1
comment Is that create table statement correct?
TRUNCATE TABLE year_2014;
Jan
1
answered mysql multi-source replication to single slave from Debian repo's?
Jan
1
comment Foreign key set to cascading but fails to update - why?
What did you try to update? Update an "id" to be a different (unused) value?
Jan
1
answered OOM in mysql-percona
Dec
31
comment When try to do Mysqldump Backup from console then getting such as error
Is MySQL Server running on the standard port, 3306? Adding --port=3306 (or another port number, if you changed it) may help. Error 10061 means there is no service listening on the port where the connection is trying go ("connection refused.")
Dec
31
comment Is it worth indexing a varchar(32) column of UUIDS where half the UUIDS are v1 and half are v4?
...so, no, given that an index on the binary column is half the size of an index on the hex column, it should not be faster, or otherwise better, to add this new column and index, particularly when you consider the cumulative time each write query will need, to update two indexes instead of one.
Dec
31
comment Is it worth indexing a varchar(32) column of UUIDS where half the UUIDS are v1 and half are v4?
"I was under the impression that MySQL doesn't inline functions" not at all true if done correctly: WHERE c1 = UNHEX('expr') will resolve the result of UNHEX() to a constant and use an index on c1 in a perfectly optimal way ... but WHERE hex(c1) = 'expr' will scan every row of the table, evaluating HEX(c1) on each row to see if it matches 'expr'. The general rule is that if you do not use a column as the argument to a function, the optimizer will get it right.
Dec
31
answered What is exactly a uniform server in a galera cluster setup?
Dec
31
comment How to ensure MYSQL imports of .sql files properly retain foreign key relationships, constraints, etc
We can't detect "this" untill we are certain what actually occurred. Since you say "all data was fully present," I'll need you to define "fixing the foreign keys" please. Did you have missing constraints from table definitions? If so, how do we reconcile that against the error message, which doesn't imply that they were missing, since it's about a constraint violation. The query that generated the error, too, might be useful, but specifically and especially, I need to understand... what exactly did you fix?
Dec
30
answered Remove duplicate terms from column
Dec
30
comment How to ensure MYSQL imports of .sql files properly retain foreign key relationships, constraints, etc
"a foreign key relationship didn't import properly" ... it's not clear how the error message definitively indicates this to be the case, since you haven't described the circumstances that raised the error (which could, of course, also be caused by attempting a query that would cause the constraint to be violated if the query were allowed to execute). Are you saying the parent table is missing rows or the child table has spurious and invalid rows? If two servers were loaded from the same backup, without errors or failing partway through, they should both be fine or both be broken.
Dec
29
reviewed Close InnoDB Failure of some kind
Dec
29
reviewed Close Graphical user interface to change data capture on Oracle
Dec
29
reviewed Approve DBO execute returns true but doesn't execute
Dec
28
comment Using Netscaler datastream and MySQL
So... you are trying to run mysqlslap against (potentially) multiple MySQL servers at the same time through the Netscaler?
Dec
28
answered call mysql function by string name
Dec
28
comment What are the optimal mysqldump settings?
Also --events...
Dec
26
comment How to take backups of MySQL databases, explicitly based on PyMySQL
Why would you not use the canonical backup utility for MySQL, which is mysqldump? Using a different library for your backups seems like an unnecessary reinvention of the wheel at best, and a risk of your data's integrity at worst.