(Shlomi Noach) Following up on MySQL security: inconsistencies, and on MySQL bug #61596, I was thinking it may take a long time till the non-existent ROUTINE_PRIVILEGES view is implemented. Here’s my own implementation of the view.
Tag: Open Source
Less known facts about MySQL user grants
(Giuseppe Maxia) Reading MySQL security: inconsistencies I remembered a few related experiments that I did several years ago when I was studying for the MySQL certification. The first fact that came to mind is about the clause “WITH GRANT OPTION”, which can only be given on the full set of options,
MySQL security: inconsistencies
(Shlomi Noach) Doing some work with MySQL security, I’ve noticed a few inconsistencies. They’re mostly not-too-terrible for daily work, except they get in my way right now.
Creating User Models in PHP and MySQL
(Alejandro Gervasio) In this fourth part of a programming tutorial series, you will learn how to create a user model in PHP and MySQL using segregated interfaces.
Insert into multiple MySQL tables linked by a foreign key
(Ilan Hazan) I have been asked if there is a way to insert data into two MySQL tables that connected by a foreign key in one MySQL query.
Advantages of weighted lists in RDBMS processing
(Justin Swanhart) A list is simply a list of things. The list has no structure, except in some cases, the length of the list may be known. The list may contain duplicate items. In the following example the number 1 is included twice.
Regularly flushing the MySQL Query Cache
(Shinguz) When we analyze our customers systems we see typically a high fragmentation of the query cache after a while. This leads to a less optimal use of the Query Cache than possible.
Silent MyISAM Table Definition Changes and mysqldump
(Singer Wang) The other day while trying to move a schema from one MySQL server to another, I encountered a very odd issue. The schema to be moved contained both MyISAM and InnoDB tables, so the only option I had was to dump the schema using mysqldump on the source server and import it on the destin
Building a realtime Feed with RabbitMQ Node.js AMQP and mySQL
(Dathan Vance Pattishall) Being a backend programmer, I rarely code in JavaScript. Today I code a lot of cross browser JavaScript with the fantastic lib jquery and its various extensions. Front end programming is hard to get correct since IE sucks but that’s another Blog post that is out of scope.
Scaling Web Databases: Auto-Sharding with MySQL Cluster
(Mat Keep) The realities of today’s successful web services are creating new demands that many legacy databases were just not designed to handle: