Reputation
870
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 12
Newest
 Taxonomist
Impact
~102k people reached

Jan
29
awarded  Taxonomist
Jun
4
awarded  Yearling
Jun
4
answered Index optimization and cardinality
Jun
2
comment Replication in same server within different databases. Mysql 5.6
Not that I'm aware of.
Jun
2
answered Replication in same server within different databases. Mysql 5.6
Jun
2
comment Replication in same server within different databases. Mysql 5.6
That wouldn't be a normal situation at all! You can't alter the database during replication, and the master / slave cannot have the same server ids. I'd recommend if you must do this, then set up some triggers on the first DB, to replicate the insert / update commands against the second one.
Jun
2
comment pt-table-checksum toolkit for few databases from file
Check the file with od -c filename to see if there are any odd characters at the ends of the lines, indicating that they aren't separated with a line-feed. Can you cat the file and send a screenshot as an image perhaps?
Jun
1
comment pt-table-checksum toolkit for few databases from file
Is your DB list file set up with each database on a separate line, or with all databases on a single line?
Jun
1
comment pt-table-checksum toolkit for few databases from file
What you may find is that the DB list is presented as "db1 db2 db3" as a single line through the read line statement, and doesn't get split at the spaces, meaning the loop only runs once?
May
30
answered mysql need help optimizing query
May
30
answered pt-table-checksum toolkit for few databases from file
May
25
answered Cannot overwrite file: /var/lib/mysql/ibdata1 when using Percona xtrabackup
Sep
30
awarded  Explainer
Sep
25
awarded  Notable Question
Apr
4
awarded  Popular Question
Feb
20
awarded  Yearling
Aug
22
comment MySQL Partitioning
True, but for my particular case we were only interested in single months of data at a time. You could however expand your range to an "IN ()" clause, listing all the relevant months would help there too.
May
26
awarded  Popular Question
Feb
20
awarded  Yearling
Oct
19
answered MySQL ignoring some params from my.cnf