Reputation
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 18 39
Newest
 Mortarboard
Impact
~969k people reached

Oct
8
comment Error 1236 'Found old binary log without GTIDs' after master restart
SELECT @@VERSION; from master and slave? It's important to note that this error is thrown by the master and caught by the slave -- not thrown by the slave -- and it is, unfortunately, an error code that is used for many different conditions, all related in one way or another to binlogs but varying widely in their meaning.
Oct
3
comment MySQL import a sql file but login for which is different than localhost db
Please don't put error messages into your own words. Include the exact error text, including any letter and number codes.
Oct
1
comment Mysql general log
When using statement-based binary logging on a replication master server, statements received by its slaves are written to the query log of each slave. dev.mysql.com/doc/refman/5.6/en/query-log.html ... not so strange, for statement mode (which I rarely use, so wasn't sure). If the slave sql thread is connection 1, mystery solved, but that seems a little unlikely; also, I would have assumed the pseudo-thread-id, copied from the master, would be the logged id (that is how SBR keeps temp tables straight among events) but perhaps not.
Sep
30
comment Mysql general log
Hmmm. No, if the inserts in the master are showing on the slave as connection 1, that would not be the event scheduler. Can you update your question with an example of the general log entry? Also SELECT @@BINLOG_FORMAT; on the master and include the output.
Sep
29
answered Mysql general log
Sep
27
answered Connecting to a new RDS instance from an EC2 instance
Sep
27
comment Connecting to a new RDS instance from an EC2 instance
This answer does not answer the question. It should be deleted.
Sep
26
awarded  Generalist
Sep
23
answered Converting table to a 2NF relation
Sep
23
reviewed Close Setting max server memory in SQL Server 2014
Sep
23
reviewed Close Making a very simple product hierarchy in MySQL
Sep
22
comment MySql 5.6 error (Table 'mysql.user' doesn't exist) when started as a daemon
You'll be sorry for changing the default locations. I'm not trying to be funny, but I don't do it. Potentially worth trying, put these directives in the [mysqld] sections in /etc/mysql/my.cnf or /etc/my.cnf, whichever is on your system, or remove any conflicting entries already there.
Sep
18
comment MySQL: Recover Master from Slave after failover
There is no need to RESET MASTER. You only have to start replication at the correct coordinates -- assuming -- no data was lost on the master and no binlogs have been purged from the slave from the entire time since the old master went away. In fact, if you do RESET MASTER on the old slave, you'll need to completely rebuild the old master from a dump of the old slave, because you've lost data in the slave binlogs at that point.
Sep
18
comment xampp mysql slow after bind 0.0.0.0
Slows down...what? The initial connection? Something else? Did changing it back make any difference?
Sep
18
comment Is binary logs required on the slave in order to do replication?
"log-slave-updates must not be enabled on the Slave" seems to imply that Otherwise Bad Things Will Happen™, which isn't the case in any sense I can think of. The expire_logs_days system variable can prevent unbounded binlog growth, too. I don't have a slave anywhere in my infrastructure that doesn't use log_slave_updates, regardless of its role. In less I'm missing something, "should probably not be enabled" seems more fitting.
Sep
17
answered Replace a specific part of a string using MySql
Sep
16
comment Why am I seeing `ERROR 1290 (HY000)` when altering my table?
@Feng please provide the information that was requested: the output of SELECT @@VERSION;. The specific version of 5.6 could be relevant.
Sep
16
comment MySQL set one db in server to slave
It seems like binlog_format=ROW on MASTER A would also be essential since cross-database statement-based queries would not replicate correctly.
Sep
15
awarded  Yearling
Sep
12
comment Where does extra bytes come from
Good points, here, but I suspect the InnoDB row structures are accountable for most of the unexplained space.