Reputation
11,675
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 13 32
Newest
 Caucus
Impact
~718k people reached

Jun
19
comment Mysql Replication - How it works offline?
N.B. do not try to replicate only certain schemas or tables. Replicate everything. Partial replication has very complex rules. Replicating everything is much simpler.
Jun
19
answered How to select users that doesn't in the role
Jun
19
answered Mysql Replication - How it works offline?
Jun
17
comment Is there a tool to check if my database is normalized to the third normal form?
@Drewverlee it seems, at first, like you're correct, based on the phrasing I chose, here. It's been so long ago that I don't recall precisely what I intended. My intention was to craft an unrealistic scenario where the table -- which I suggest is not in 3NF with realistic data -- would have been clearly in at least 3NF as it was. If student were the primary key, though, the answer still seems to be correct as it is, with instructor and subject being dependent only on student and not each other. I would, of course, welcome any edits that improve the quality or clarity of this answer.
Jun
3
comment INET6_ATON returns NULL for input parameter
Not necessarily a bug... SHOW WARNINGS; upon receiving the NULL response might also have provided you with some useful info.
May
29
answered Will frequent small select queries slow down frequent write queries in InnoDB table in MySQL?
May
29
answered MySQL binlog limitations
May
29
comment MySQL binlog limitations
"a binlog tailer" is... what, specifically?
May
27
comment Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes
@aland that is a very good point. No, I should have been using the default value of 4096. It looks as if the query cache trims the block down to the smallest possible power of two after filling it, leaving the free space at the end, so that 7/8ths of the entire 4096 bytes originally allocated aren't stranded. I'll have to dig more deeply into this.
May
19
comment Converting MySQL master-master replication to master-standby
And to be clear, the RESET SLAVE; would be done on the master to prevent it from receiving further updates from the slave.
May
19
comment Converting MySQL master-master replication to master-standby
... in fact, the master should not only be stopped, but also RESET SLAVE; to be safe... else you risk dropping and reloading tables on the master, while you are rebuilding the slave.
May
19
comment Delete and Recreate Indexes in MySQL to reduce table size for copying the db to a new server?
If mysqldump isn't working, then you are doing something wrong, and you should consider posting a new question, to figure out why, assuming there is not already an answer here that addresses the problem. It is the standard tool for this task, and is by far the safest approach.
May
9
comment Best configuration for MySQL? InnoDB and MyISAM
You should remove all of those settings except innodb_buffer_pool_size. Don't depart from the defaults unless you have a specific reason to, and verify the impact of each change, separately. Tweaking parameters like this can have unintended consequences and most "tuning" advice you will find is not helpful.
May
7
comment Intermittent “access denied” (1045) message from MySQL
SET GLOBAL LOG_WARNINGS = 2; and try again. Then check the MySQL error log.
May
6
comment Get data faster from databasse
That is not really a query. It would be better to get the actual SQL being generated by that construct... and then use EXPLAIN SELECT ... to review the server's query plan... but certainly WHERE column LIKE '%search_string%' is always going to be a slower query because indexes provide very little benefit. The % at the beginning prevents any index on the referenced column from being used, if there is one.
May
5
comment Inconsistencies with ADD CONSTRAINT index_name in MySQL
The answer implies that SET foreign_key_checks = 1; is a "flag" that can be set at the database level, and set "unknowingly," when it is actually scoped to the connection (session) level and is the default. I also don't see where the answer is derived from the documentation cited.
Apr
28
answered Does MySQL support querying for the current running transaction id
Apr
28
comment What are some known hazards with cyclical replication between two MySQL master servers?
Agreed. Failure is very likely, in such an environment. To put a fine point on it, this setup isn't guaranteed to work in either direction. "MySQL supports replication from one major version to the next higher major version.". Specifically, that means from and older master and to a newer slave, only. In circular replication, both servers have both roles, and a newer master with an older slave "may be possible, but is generally not supported". There are too many changes for backwards replication to be safe.
Apr
24
awarded  innodb
Apr
8
answered Vague replication error code 2005