기본 InnoDB 전문 검색(Full Text) 파서는 공백이나 단어 분리자가 토큰인 라틴 기반 언어들에서는 이상적이지만 개별 단어에 대한 고정된 구분자가 없는 중국어, 일본어, 한국어(CJK)같은 언어들에서는 각 단어는 여러개의 문자들의 조합으로 이루어집니다. 그래서 이경우엔 단어 토큰들을 처리할 수 있는 다른 방법이 필요합니다.
우리는 CJK에서 사용할 수 있는 n-gram 파서를 제공하기 위한 새로운 플러그블 전문 파서(pluggable full-text parser)를 MySQL 5.7.6 에서 제공할 수 …
[Read more]Upgrading MySQL
Upgrading MySQL is a task that is almost inevitable if you have been managing a MySQL installation for any length of time. To accomplish that task, we have provided a utility and documentation to upgrade from one version of MySQL to another. The general recommendation is to perform the upgrade by stepping from one major release to the next, without skipping an intermediate major release. For example, if you are at 5.1.73, and you want to go to 5.6.24, the safest and recommended method is to upgrade from 5.1.73 to 5.5.43 (the latest 5.5 release at the time of this writing), and then upgrade from 5.5.43 to 5.6.24 (or any version of 5.6). This allows the …
[Read more]Madrid MySQL Users Group is having a Meetup this afternoon, Wednesday, 13th May at 19:00. I will be presenting (in Spanish) a quick summary of Percona Toolkit and also offering a summary of the new features in MySQL 5.7 as the release candidate has been announced and we don’t expect new functionality. This is also … Continue reading MMUG12: Talk about Percona Toolkit and the new features of MySQL 5.7
The post MMUG12: Talk about Percona Toolkit and the new features of MySQL 5.7 first appeared on Simon J Mudd's Blog.
One of the cool new features in 5.7 Release Candidate is Multi Source Replication, as I previously looked into in 5.7.5 DMR.
I’ve had more and more people like the idea of this, so here’s a quick set-up as to what’s needed and how it could work.
1. Prepare master environments.
2. Prepare 40 masters for replication.
3. Create slave.
4. Insert data into the Masters.
* I originally tried running 50 mysql’s but I just ran out of resources on my old pc, so it’s at 40.
* The real key behind this scenario is that each of the masters has a unique centre_code that is implicitly inserted via the app & users at that site. i.e. no other site will want to modify any data that was entered from that site, e.g. call centre reclaims dept for specific areas / regions, CNC …
[Read more]A Database Administrator experiences a wide range of emotions. It could be one those endless meetings, friendly disagreements with fellow developers, getting something approved from managers or preparing your junior DBAs for bigger battles. Each day is a challenging one. We’ve tried to compile a list of GIFs which every DBA will be able to relate to.
When a DBA.StackExchange answer gets 500+
upvotes!
…
[Read more]Locking is important in many scenarios to prevent other sessions from modifying tables during periods when a session requires exclusive access to them. for example altering table definition online or any kind of table definition changes. Mysql provides an option to lock table/s with different types of locks, depends on need.
syntax for lock table:
LOCK TABLES
tbl_name [[AS] alias] lock_type
[, tbl_name [[AS] alias] lock_type] ...
lock_type:
READ [LOCAL]
| [LOW_PRIORITY] WRITE
UNLOCK TABLES
Following are the examples for READ and WRITE LOCK:
READ LOCK:
session1> create table t1( c1 int); Query OK, 0 rows affected (0.06 sec) session1> insert …[Read more]
While I previously blogged about installing Netbeans 8, some of my students would prefer to use the Eclipse IDE. This post shows how to install and configure Eclipse IDE, include the mysql-connector-java.jar, and write Java to access the MySQL.
You can download Eclipse IDE and then open it in
Fedora’s Archive Manager. You can use the Archive
Manager to Extract the Eclipse IDE to a directory
of your choice. I opted to extract it into my
student user’s home directory, which is
/home/student.
After extracting the Eclipse IDE, you can check the
contents of the eclipse directory with the following
command:
ls -al eclipse |
You should see the following:
| … |
While our engineering team is working on finalizing the TokuMXse storage engine, I want to provide an experimental build that you can try and test MongoDB 3.0 with our storage engine.
It is available here
percona.com/downloads/TESTING/Percona-TokuMXse-rc5/percona-tokumxse-3.0.3pre-rc5.tar.gz
To start MongoDB with TokuMXse storage engine use:
mongod --storageEngine=tokuft
I am looking for your feedback!
The post MongoDB with Percona TokuMXse – experimental build RC5 is available! appeared first on MySQL Performance Blog.
We discussed in an earlier post how to design indexes for many types of queries using a single table. Here is a real-world example of the challenges you will face when trying to optimize queries: two similar queries, but one is performing a full table scan while the other one is using the index we specially created for these queries. Bug or expected behavior? Read on!
Our two similar queries
# Q1 mysql> explain select col1, col2 from t where ts >= '2015-04-30 00:00:00'; +----+-------------+---------------+------+---------------+------+---------+------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------+------+---------------+------+---------+------+---------+-------------+ | 1 | SIMPLE | t …[Read more]
Release Notes Changelog What is MariaDB 10.0?
MariaDB APT and YUM Repository Configuration Generator
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.18. This is a Stable (GA) release.
See the Release Notes and …
[Read more]