Tag: INDEX

Feed: Planet MySQL; Author: Markus Winand; “Still using SQL-92?” is the opening question of my “Modern SQL” presentation. When I ask this question, an astonishingly large portion of the audience openly admits to using 25 years old technology. If I ask who is still using Windows 3.1, which was also released in 1992, only a few raise their hand…but they’re joking, of course.Clearly this comparison is not entirely fair. It nevertheless demonstrates that the know-how surrounding newer SQL standards is pretty lacking. There were actually five updates since SQL-92—many developers have never heard of them. The latest version is SQL:2016.As ... Read More

Feed: Planet MySQL; Author: Michael "Monty" Widenus; Last week, Oracle announced the general availability of MySQL 8.0. This is good news for database users, as it means Oracle is still developing MySQL.I decide to celebrate the event by doing a quick test of MySQL 8.0. Here follows a step-by-step description of my first experience with MySQL 8.0. Note that I did the following without reading the release notes, as is what I have done with every MySQL / MariaDB release up to date; In this case it was not the right thing to do.I pulled MySQL 8.0 from ghit@github.com:mysql/mysql-server.git I ... Read More

Feed: Planet PostgreSQL. “Still using SQL-92?” is the opening question of my “Modern SQL” presentation. When I ask this question, an astonishingly large portion of the audience openly admits to using 25 years old technology. If I ask who is still using Windows 3.1, which was also released in 1992, only a few raise their hand…but they’re joking, of course.Clearly this comparison is not entirely fair. It nevertheless demonstrates that the know-how surrounding newer SQL standards is pretty lacking. There were actually five updates since SQL-92—many developers have never heard of them. The latest version is SQL:2016.As a consequence, many ... Read More

Feed: Big Data Made Simple - One source. Many perspectives.. Author: Baiju NT. There is little doubt in anyone’s mind that big data is the key to business growth and success these days. This is exactly why over half of businesses have incorporated the futuristic technology into their daily practices. However, to SMBs, big data analytics still seems like a game for the big time players with huge budgets. Limited budgets and an overall misunderstanding of its practicality is what’s holding many business owners back from embracing the technology, of which could make all the difference in their success. Big ... Read More

Feed: Planet MySQL; Author: MyDBOPS; MySQL 8.0 has a rich set of features. One of the feature which interests DBA’s more is invisible index What is an index in MySQL ? The indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. What is invisible index ? The invisible index is ability to mark an index as unavailable for use by optimizer. In MySQL 5.7 and other previous versions the indexes are visible by a default. To ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; Encountered a problem while running the RODBC library from the R prompt as the root user, as follows: > install.packages('RODBC') It failed with the following library dependency: checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package ‘RODBC’ * removing ‘/usr/lib64/R/library/RODBC’   The downloaded source packages are in ‘/tmp/RtmpdT1gay/downloaded_packages’ Updating HTML index of packages in '.Library' Making 'packages.html' ... done Warning message: ... Read More

Feed: Planet MySQL; Author: Tony Darnell; MySQL Enterprise Edition Database Firewall – Control and Monitor SQL Statement Executions April 23, 2018 Leave a comment As of MySQL 5.6.24, MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall (it runs within the mysql database process) that enables database administrators to permit or deny SQL statement execution based on matching against whitelists of accepted statement patterns. This helps harden MySQL Server against attacks such as SQL injection or attempts to exploit applications by using them outside of their legitimate query workload characteristics. Each MySQL account registered with the firewall has its own ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; This post serves as a quick start guide on how to use the MySQL Document Store with the official Node.js connector. It mainly highlights how easy it is to leverage CRUD-style operations and getting up and running with the X DevAPI. Make sure you have Node.js 7.6.0 (or higher) and MySQL 8.0.11 (or higher) installed on your machine. First, using the command line, let’s start by creating a directory for our sample application. $ mkdir myproject$ cd myproject Create a package.json manifest file using the following command: $ npm init -y Next, install the MySQL ... Read More

Feed: AWS Compute Blog. Author: Tara Van Unen. This post courtesy of Massimiliano Angelino, AWS Solutions ArchitectDifferent enterprise systems—ERP, CRM, BI, HR, etc.—need to exchange information but normally cannot do that natively because they are from different vendors. Enterprises have tried multiple ways to integrate heterogeneous systems, generally referred to as enterprise application integration (EAI). Modern EAI systems are based on a message-oriented middleware (MoM), also known as enterprise service bus (ESB). An ESB provides data communication via a message bus, on top of which it also provides components to orchestrate, route, translate, and monitor the data exchange. Communication with the ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles  | April 13, 2018 |  Posted In: Amazon Aurora, AWS, MariaDB, MongoDB, MyRocks, MySQL, Percona Monitoring and Management, Percona Software, Percona XtraBackup, ProxySQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live is just over a week away — there’s an awesome keynote lineup, and you really should register. Also don’t forget to save the date as Percona Live goes to Frankfurt, Germany November 5-7 2018! Prost! In acquisitions, we have seen MariaDB acquire MammothDB and Idera acquire Webyog. Some ... Read More