This Log Buffer browses through Oracle, SQL Server and MySQL spaces and brings forth some of the useful blog posts for this week.

Oracle:

Conner throws it out of the park. As we all (hopefully) know, we should always deploy named program units (procedures/functions) within packages. Its a great method of encapsulation of logic.

Pythian’s Gleb talks about Azure on RAC. Microsoft Azure provides an acceptable and affordable platform for a training environment.

There are some performance improvements that require physical storage options to be set on tables or indexes. One particular technique that I will take as an …

Welcome to today’s installment of Planets9s, our weekly communication on all the latest resources and technologies we create around automation and management of open source databases. I trust that these resources will be useful to you and would love to get your feedback on them.

Download ClusterControl - The Full Monty Release for MySQL, MongoDB & PostgreSQL

This week we’re pleased to announce the release of ClusterControl 1.2.12. This release contains key new features, such as support for the latest versions of MySQL, MongoDB & PostgreSQL, operational reports and enhanced backup options, along with performance improvements and bug fixes. Worth highlighting are also the new replication features for Master & Slave, as well as SSL encryption of Galera

Replication links. …

Graph databases are great. But if I read more FUD about RDBMSs, I’m going to have another flashback to the 80’s where someone is telling me about how you don’t want to dismantle your car every time you park it in the garage (OODBMS reference for the oldies).
I recently read a graph-database book that explained that every SQL join requires computing a cartesian product. And yesterday, a post that explained that equijoins have an exponential order of complexity. (I guess… if the exponent is 1.) It’s getting very frustrating to read through the inaccuracies and FUD, and now, to me, it is all just turning into

Which is why it was nice to see @guyharrison‘s even-handed and accurate treatment in his new book …

With our new ClusterControl 1.2.12 release we have added many new features like operational reports, enhanced backup options, SSL Encryption for Galera replication links and improved the support for external tools. One of these tools is CCBot, the ClusterControl chatbot.

CCBot is based on the popular Hubot framework originally created by Github. Github uses Hubot as their DevOps tools of choice and allowing them to do Continuous Integration and Continuous Delivery on their entire infrastructure. So what does Hubot allow you to do?

Hubot

Hubot is a chatbot that has been modelled after Github’s internal bot called hubot. The Hubot framework allows you to quickly create your own bot and extend it with various pre made scripts and …

Some application required one time zone to convert another time zone PHP provide some readymade timezone conversion classes but it a very complecated so we have try to define this function simple wayYou can createe a simple class and write one function into the class then you able to use thi

strongWhy remove query stringsstrongMain two reasons for this1 Clear URL alwaya look better than the long URL2 When you are not remove your query string from URL then all get variable show in you URL string sometime it not good for a security You can remove your query string using th

Whenever you require to use any image plugin for select image and cropresizeeffectsframesstrickers ect so you have to use Aviary api like as you see of facebook twitter ect that site plugin provide lots of efects and api guide that way you can use easily in your web app and as well as on mob

It was a long time since I updated mysqljsonimport or mysqljsonexport and I had a few things I wanted to do with them. This release is significant enough for me to bump it up to 2.0, and the same is in the works for mysqljsonexport. The one big thing that is now implemented is reasonably advanced support for MariaDB Dynamic Columns, and it is actually pretty flexible, allowing you to load a nested JSON object into a MariaDB Dynamic Column. But don't worry, it will still link and run with MySQL if that is what you want to do (but then you will not have the dynamic column features, for obvious reasons),

Download from Sourceforge as usual (yes, I know I am oldfashioned and that I should have put it on github). Also as usual is the documentation in pdf format that is also downloadable separately.

/Karlsson …

Let's look at how well MySQL and MariaDB support privileges (part of "access control" in standard terms), compared to other DBMSs, and consequences thereof.

Count the Privileges

I go to the DBMS manuals (here and starting here and here) and I count the privileges. This is like judging a town by the number of traffic lights it claims to have, but I'm trying to get an indicator for how granular the DBMS's "authorization" is.

Number of privileges listed in the manuals

MySQL/MariaDB  Oracle 12c     DB2 9.7   SQL Server 2014
31             240            52        124

Pretty …

This article is the follow-up on discussion started around MySQL 5.7 results on OLTP_RW Benchmark.. -- the point was about the impact of PERFORMANCE_SCHEMA (PFS) enabled, and InnoDB checksums on MySQL 5.7 performance within this OLTP_RW workload.

As promised, here are the results:

Just in case if the legend naming in graphs is not obvious :

• PS-off : "performance_schema=off" was used
• PS-def : "performance_schema=on" was used (default PFS instrumentation)
• chksum0 : "innodb_checksums=0" was used
• chksum1 : "innodb_checksums=0, innodb_checksum_algorithm=crc32" was used

OLTP_RW 1M x8-tables MySQL 5.7 (config: trx_commit=2 double_write=0) :


OLTP_RW 1M x8-tables MySQL 5.7 …