This Log Buffer edition has collected some of the valuable blog posts from different databases like Oracle, SQL Server and MySQL.
- Accessing HDFS files on a local File system using mountable HDFS – FUSE
- enq: TM – contention
- The Four A’s of Data Management
- ODI, Big Data SQL and Oracle NoSQL
- Using the RIDC Client to Interface with Oracle Webcenter Content
- SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms
- Creating a multi-option parameter report for SQL Server Reporting Services
- Re-factoring a database object can often cause unexpected behavior in the code that accesses that object
- What is Database Continuous Integration?
- Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table
For years it was very easy to defend InnoDB’s advantage over competition. Covering index reads were saving I/O operations and CPU everywhere, table space and I/O management allowed focusing on database and not on file systems or virtual memory behaviors, and for the past few years InnoDB compression was the way to have highly efficient OLTP.
InnoDB locks and deadlocks with or without index for different isolation level.
pquery binaries with statically included client libs now available!
MySQL Group Replication – mysql-5.7.6-labs-group-replication.
MySQL 5.7 aims to be the most secure MySQL Server release ever, and that means some significant changes in SSL/TLS.