Tag: MariaDB

Feed: Planet MySQL; Author: RoseHosting; In this tutorial, we will show you how to install LAMP Stack on a Debian 9 VPS. A LAMP (Linux, Apache, MySQL, PHP) stack is a combination of open-source software, typically installed on a server used for hosting dynamic websites and web applications. It includes the Linux operating system, the Apache web server, MySQL or MariaDB for data storage and management, and PHP for handling any dynamic content. Installing LAMP on Debian 9 is a straightforward task and should not take more than 10 minutes. Let’s start with the installation. Table of Contents Prerequisites: A ... Read More

Feed: Recent Announcements. Once you create tags for your RDS DB instances, you can separate RDS backup charges in AWS Cost Explorer according to the tags of the corresponding DB instances. When you view your Cost and Usage Report (CUR), you’ll find that the ResourceId for each RDS ChargedBackup line contains the name of the corresponding DB instance, and tags associated with the DB instance are marked in additional columns. Note that detailed backup charges have been activated as of October 8, 2019. Your RDS backup charges prior to this date will continue to show up as a single line ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Rowid filtering is an optimization in MariaDB 10.4. Its target use case is as follows: a table uses ref access on index IDX1 but it also has a fairly restrictive range predicate on another index IDX2. In this case, it is advantageous to: Do an index-only scan on index IDX2 and collect rowids of index records into a data structure that allows filtering (let's call it $FILTER). When doing ref access on IDX1, check $FILTER before reading the full record Example Consider a query SELECT ... FROM orders JOIN lineitem ON o_orderkey=l_orderkey ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Good news ! Once agin, the MySQL, MariaDB & Friends Devroom has been accepted for FOSDEM’20‘s edition !! This event is a real success story for the MySQL ecosystem; the content, the speakers and the attendees are growing every year. FOSDEM 2020’s edition will take place 1st & 2nd February in Brussels and our MySQL, MariaDB & Friends devroom will run on Saturday 1st (may change). FOSDEM & MySQL/MariaDB is a love story started 20 years ago ! The committee selecting the content for our devroom is not yet created and if you want ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; Introduction Ever wanted to connect to a relational database using Java and didn’t know which JDBC Driver Maven dependency to use? If so, this article is surely going to help you from now on. Oracle Since September 2019, the Oracle JDBC Driver is available on Maven Central. For JDK 10 and 11, use the following Maven dependency: com.oracle.ojdbc ojdbc10 ${oracle.version} For JDK 8, use the ojdbc8 artifact instead: com.oracle.ojdbc ojdbc8 ${oracle.version} For more details about the proper version to use, check out the following Maven Central link. MySQL The MySQL Driver is available on ... Read More

Feed: Planet MySQL; Author: Marco Tusa; This week is almost over, and it pass after two nice event that I had attended.PerconaLive 2019 in Amsterdam Schiphol and ProxySQL Technology Day in Ghent. What are my takeaways on both events? Venue The venue was nice, the hotel comfortable and rooms were nice as well, clean and quiet. Allow to have good rest and same time decent space to work if you have to. The conference was just there so I was able to attend, work and rest without any effort, A+. The hotel was far away from the city and the ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This page describes how MariaDB optimizer computes condition selectivities calculate_cond_selectivity_for_table(T) This function computes selectivity of the restrictions on a certain table T. (TODO: name in the optimizer trace) Selectivity is computed from selectivities of restrictions on different columns (histogram data) selectivities of potential range accesses. Restrictions on different columns, as well as disjoint sets of columns, are considered independent, so their selectivities are multiplied. Data from potential range accesses First, we take into account the selectivities of potential range accesses. If range accesses on indexes IDX1 and IDX2 do not use the ... Read More

Feed: Planet MySQL; Author: Federico Razzoli; Searching a text is not a simple task!Maybe you’re wondering why in MySQL/MariaDB 'string' seems to be the same as 'STRING'. Or maybe that’s not the case for you, but you would like to make a case insensitive search. This article explains how to write a case sensitive or a case insensitive query. Table of Contents hide The wrong way I’ve seen terrible queries doing something like these: SELECT * FROM book WHERE LOWER(title) = 'solaris'; SELECT * FROM book WHERE UPPER(title) = 'SOLARIS'; Why are they terrible? Because if we pass a column ... Read More

Feed: Planet MySQL; Author: Colin Charles; Percona Live Europe Amsterdam Day 1 was a bunch of fun, especially since I didn’t have to give a talk or anything since my tutorial was over on Day 0. At lunch, I realised that there are a lot more fringe events happening around Percona Live… and if you’ve seen how people do “tech weeks”, maybe this is what the event ends up being – a show, plus plenty of focused satellite events. FOSDEM in the open source world totally gets this, and best of all, also lists fringe events (see example from ) ... Read More

Feed: Planet MySQL; Author: Shiv Iyer; MySQL works great for Online Transaction Processing (OLTP) systems, MySQL performance degrades with analytical queries on very large database infrastructure, I agree you can optimize MySQL query performance with InnoDB compressions but why then combine OLTP and OLAP (Online Analytics Processing Systems) when you have columnar stores which can deliver high performance analytical queries more efficiently? I have seen several companies building dedicated MySQL servers for Analytics but over the period of time they end spending more money in fine tuning MySQL for Analytics with no significant improvements, There is no point in blaming ... Read More