I recently granted ALTER access in MySQL so a user could run the ALTER TABLE command . However after I granted the necessary privileges, the user was still not able to perform the tasks needed. Then I realized what the issue was and how to fix it.
Hello and welcome to Log Buffer #180. Time’s a-wastin’, so let’s go!
Applying binary logs to a MySQL instance is not particularly difficult, using the mysqlbinlog command line utility. Turning off binary logging for a session is not difficult, from the MySQL commandline, if you authenticate as a user with the SUPER privilege.sometimes you want to apply binary logs to a MySQL instance, without having those changes applied to the binary logs themselves. One option is to restart the server binary logging disabled, and after the load is finished, restart the server with binary logging re-enabled. This is not always possible nor desirable, so there’s a better way, that works in at least versions 4.1 and up
Here’s the future of MySQL, Drizzle, Monty Program, the Percona fork, etc. The best product management strategies… should we be lightweight for the web, plug-in oriented like Drizzle? Should we follow Monty’s giant-killing roadmap? Should we focus on performance-oriented patches? The best product management strategies will win. They can’t win alone. Will they be backed by appropriate investments from effective developers? Effective developers are the ones who convert winning product management strategies into working products. You can’t get there without them and I’ve seen lots of great strategies fail that test (including my own actually). And there can be more than one winner.
I was sad that last year there was no community dinner, and I missed the one the year before when Jonathan Schwartz and Rich Green made an appearance. This year I am determined not to miss it, and so I am calling for a community (pay-your-own-way) dinner on Monday, April 12th, at Pedro’s
You have found the 179th edition of Log Buffer, the weekly review of database blogs. Welcome. Enjoy your stay. We begin with . . .
There are those that are very adamant about letting people know that using INFORMATION_SCHEMA can crash your database. Of course they leave out one extremely important piece of information: you can actually figure out how dangerous your INFORMATION_SCHEMA query will be, ahead of time, using EXPLAIN. Here’s how.
Pythian has launched a Partner Program to assist Independent Software Vendors (ISVs), whose applications have intensive database requirements. We assist their client base by helping them correctly plan, deploy, and manage the underlying database infrastructure, be it MySQL, Oracle or SQL Server, to ensure the ISV customers’ software environment is sound, and performs well over time.
Gerry Narvaja has published the 178th edition of Log Buffer, the weekly review of database blogs.
Welcome, everyone, to the 177th edition of Log Buffer, the weekly review of database blogs. It was another week heavy with technical posts, so let’s waste no time, and get it all started with . . .