Reputation
3,069
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 13 38
Impact
~357k people reached

May
1
answered lot of relay log formation in mysql5.6
Apr
30
asked Can anyone explain TokuDBs seemingly large amount of data_free for an append only table?
Apr
30
comment Insanely slow replication after MHA promotion
Both IO and SQL threads where running, executed gtids were advancing... slowly. The relay logs were piling up in logdir. Spec'd to be identical machines.
Apr
29
revised Insanely slow replication after MHA promotion
updated information
Apr
29
asked Insanely slow replication after MHA promotion
Apr
25
awarded  Notable Question
Apr
8
comment Vague replication error code 2005
Yeah I had found something similar before posting here. The previous grants were a wild carded ip type grant though. I even tried renaming to just @% briefly. As I mentioned in a previous retry it all of a sudden worked as planned, alas I didn't save the terminal history to be certain of what I did or didn't do. There had been plenty of times I've not gotten GTID replication right the first time but there were must more specific errors. Further confounding the situation is there a another slave in the same DC that went w/o issue. I clearly forgot some step but erased the history.
Apr
7
comment Vague replication error code 2005
Maybe it has something to do w/ running percona builds but I most certainly can specify just master_host with previous user names, password and non standard ports defined. I had about half a dozen other slaves I moved over in a similar fashion. At anyway trying to give things another try, attempts to at least first reproduce the problem first failed (replication started back up as I hoped). Not sure what I did wrong/differently first time.
Apr
7
asked Vague replication error code 2005
Feb
12
awarded  Notable Question
Jan
14
reviewed Approve startup mount issues with Oracle
Jan
14
reviewed Approve MYSQL: Join with many to many
Jan
13
comment ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Find the mysqld in your processlist. Run sudo lsof -p PID where PID is the process id of your mysqld process. This should show you file handles it has open
Jan
13
comment ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
See the link in my answer below on how to restore
Jan
13
answered ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Jan
13
comment ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Examine the source sql file you ran. Did it contain anything like a mysql.users table or any GRANT, set password or create user queries? It's possible you blew out your root account credentials with that.
Jan
12
comment Not able to solve issue: Incorrect string value: '\xC5\xABt\xC4\x97'
Try a hyphenated characterEncoding=utf-8 in your URL
Jan
12
comment Not able to solve issue: Incorrect string value: '\xC5\xABt\xC4\x97'
Does your JDBC URL have a characterEncoding=UTF8mb4 parameter? @TianyiCong
Jan
12
comment Not able to solve issue: Incorrect string value: '\xC5\xABt\xC4\x97'
Are the character encoding variables you pasted the session values from the same connection as the client connection that is experiencing the error?
Jan
9
reviewed Reject Speed inserts in database with a table with +47 million data per each year, containing more than 10 years?