As I come across various tutorials and installation instruction manuals across the Web, there's one thing I see quite often: the unnecessary use of the "FLUSH PRIVILEGES" statement.
MySQL access control is based on grant tables, which are loaded... (read more...)
I recently received this question from someone on Twitter:
Hi Richard I couldn't find answer to my doubt..I searched all over the internet..does MySQL always use clustered index(primary key) for select * from table?
I had a... (read more...)
When the new server starts for the first time, it creates the binlog index file and an initial binlog file. It then connects to the clusters, finds it's not initialised and starts an SST operation. So far, so good...
The issue I've been hitting ... (read more...)
Yes, I know it's been a long, long time, but I've finally got round to dragging this site out of the 90s and look not quite so eye-wateringly bad.
Now all I need to do is spend more time working on content! If you have any suggestions for artic... (read more...)