Reputation
815
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 12
Newest
 Yearling
Impact
~75k people reached

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
Aug
14
comment Can I have an InnoDB master and MyISAM slaves with Full-Text for searching?
It works great, I have a syslog system, where the master collects data into the BLACKHOLE storage engine, which then off-loads all the heavy lifting to the slave running combinations of MyISAM and InnoDB. This way I can pause the slave in order to analyse the data, leaving the master collecting and only using log storage :)