JavaScript has emerged in the past couple years as the de facto expression of next generation web technologies, and a critical component of HTML5 technologies – along with CSS and JQuery. JavaScript is really ubiquitous – it really is showing up everywhere! There are many other reasons why JavaScript and JS-based tools are becoming the wave of the future. JavaScript is the #1 most-used language on GitHub, and this trend is only going to increase. As one article put it, “JavaScript is the number one …
[Read more]In addition to our general CJK support, as detailed in this blog post, we’ve also added a MeCab parser. MeCab is a Japanese morphological analyzer, and we now have a full-text plugin parser based on it!
How Would I Use It?
- Set the mecab_rc_file option — mecab_rc_file is a read-only system variable pertaining to the MeCab parser. The mecabrc file that it points to is a configuration file required by MeCab, …
Finely tune your query writing and database performance with tips from the experts.
MySQL offers a few different types of indexes and uses them in a variety of ways. There’s a lot to know about the various kinds of indexes and how they interact with the storage engines, and it’s all very important for query optimization. A few examples are listed below:
- The “leftmost prefix rule”
- Clustered primary indexes versus secondary indexes
- B-Tree and hash
- New types of indexes such as LSM and Fractal Trees
- Newer features in the query optimizer and executor in MySQL 5.6 and 5.7
You will leave this webinar with a better understanding of how MySQL and its storage engines use indexes to speed up queries, as well as how you can improve query performance with basic and advanced index optimizations. Register below, and we will send you a copy of the recording and slide …
[Read more]
When reading a MySQL Query Execution Plan (QEP) produced by the
EXPLAIN command, generally one of the first
observations is to validate an index is being used per table
(i.e. per row of output). In MySQL, this is observed with the
key
column.
In the following two simple single table examples we see the use of the PRIMARY key. To the untrained eye this may lead to assume that the right index is being used.
Example 1
+----+-------------+----------------+-------+---------------+---------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+----------------+-------+---------------+---------+---------+------+------+-------------+ | 1 | SIMPLE | txxxxxxxxxxxx | index | NULL | PRIMARY | 4 | NULL | 100 | Using …[Read more]
MySQL QA Episode #1: Bash/GNU Tools & Linux Upskill & Scripting Fun
This episode consists of 13 parts, and an introduction. See videos below
In HD quality (set your player to 720p!)
Introduction
Part 1: echo, ls, cp, rm, vi, cat, df, du, tee, cd, clear, uname, date, time, cat, mkdir
Part 2: find, wc, sort, shuf, tr, mkdir, man, more
Part 3: Redirection, tee, stdout, stderr, /dev/null, cat
Part 4: Vars, ‘ vs “, $0, $$, $!, screen, chmod, chown, export, set, whoami, sleep, kill, sh, grep, sudo, su, pwd
Part 5: grep, regex (regular expressions), tr
Part 6: sed, regex (regular expressions)
Part 7: awk
Part 8: xargs
Part 9: subshells, shells, …
[Read more]MariaDB CONNECT Storage Engine allows to access a JSON file as if it was a local table. The mapping between a hierarchical structure and a relational structure is not ‘natural’ and needs to be defined. To achieve that we need a specific syntax. We associate with each column a ‘field_format’ attribute. This ‘field_format’ column attribute [...]
MySQL Enterprise Backup team is excited to announce the new release of MySQL Enterprise Backup (MEB) 3.12.0.
MEB 3.12.0 focuses on enhancing the capabilities of the product that would be very useful to the database administrators.
New functionality added
• Support for Open Stack Object Storage
In the last release of MEB, we added cloud support of Amazon S3
to do backups and restore from MEB. Now in MySQL Enterprise
Backup 3.12.0, we have added cloud backup and restore using
OpenStack Object Storage ("Swift") 1.0.
Authentication can be handled either through Swift's own TempAuth
authentication system or the OpenStack Identity Service
(Keystone) 2.0.
A number of new command options have been introduced to support the OpenStack Object Storage. Details of Cloud Storage Options are available …
[Read more]Welcome to the MySQL QA Training Series!
If you have not read our introductory blog post on pquery yet, I’d recommend reading that one first to get a bit of background. The community is enthuastic about pquery, and today I am happy to announce a full training series on pquery and more. Whether you are a Linux or MySQL newbie or a seasoned QA engineer, there is something here for you. From Bash scripting (see episode 1 below), to every aspect of the new pquery framework, it is my hope that you enjoy this series. If you do, please leave us a comment
Database quality assurance is not as straightforward as it may seem. It’s not a matter of point-and-click, but rather of many intertwined tools and scripts. Beyond that, due to the complexity of the underlying product, it’s about having an overall plan or …
[Read more]The default InnoDB full-text parser is ideal for latin based languages where whitespace is the token or word separator, but for languages like Chinese, Japanese, and Korean (CJK)—where there is no fixed separators for individual words, and each word can be compromised of multiple characters—we need a different way to handle the word tokens. I’m now very happy to say that in MySQL 5.7.6 we’ve made use of the new pluggable full-text parser support in order to provide you with an n-gram parser that can be used with CJK!
…
[Read more]Monitoring the metrics of the database hosts is critical. By keeping Swap and Physical Memory usage within allowable limits, you’ll ensure that there is enough memory for queries to be executed and connections to be created. By monitoring Disk Utilization, you can map growth patterns and better plan for capacity upgrades. If you’re using ClusterControl, you would have seen metrics like CPU utilization, Disk, Network Interface , Swap memory usage, physical memory usage, free physical memory, processes and event logs.
In this blog, we will discuss generic host statistics – CPU, disk, network and memory and the meaning of the data. This is a follow-up to an earlier blog post on Galera metrics monitoring, where we …
[Read more]