New CUBRID 8.4.1 - 70% faster
We have been waiting for this day for quite some time. Based on the release policy of new versions, the new release of the CUBRID DBMS is released every six months. So it happened! On behalf of the developers, I am pleased to announce a new release of CUBRID version 8.4.1 with an increased performance of 70%.
Download CUBRID 8.4.1 right now from the official site !
CUBRID developers have done a lot of work to improve the performance and stability of the DBMS. According to the results of quality assessment tests, the performance of INSERT and UPDATE operations increased by more than 70% (see the table below).
')
Also, thanks to numerous requests, we have added many new features and support for additional SQL syntax for even greater compatibility with MySQL. In addition, the new version of the DBMS adds support for regular expressions in the
Below I will give a list of major innovations in version 8.4.1.
( y -axis - the number of requests per second)
In this version of CUBRID 8.4.1, we improved the internal implementation of the database engine to improve the performance of the entire system during parallel processing of transaction logs, writing the memory buffer to disk, as well as performing replication in a High Availability environment.
As a result of all this, the performance of INSERT and UPDATE operations in version 8.4.1 has increased dramatically by more than 70% compared with the previous version 8.4.0.
The following table shows the output of the quality assessment obtained as a result of tests conducted on versions 8.4.0 and 8.4.1.
The test was conducted on a large number of transactions using the YCSB (Yahoo Cloud Serving Benchmark). More information about this test can be found in the CUBRID 8.4.1 Quality Assessment Report (eng.).
A list of additional changes can be found in the Notes for the current version (English).
Download CUBRID 8.4.1 right now from the official site !
CUBRID developers have done a lot of work to improve the performance and stability of the DBMS. According to the results of quality assessment tests, the performance of INSERT and UPDATE operations increased by more than 70% (see the table below).
')
Also, thanks to numerous requests, we have added many new features and support for additional SQL syntax for even greater compatibility with MySQL. In addition, the new version of the DBMS adds support for regular expressions in the
WHERE statement for clearer announcement of the search conditions, as well as new broker parameters and improved system monitoring. In total, about 50 bugs were fixed in the new version.Below I will give a list of major innovations in version 8.4.1.
70% improved INSERT and UPDATE performance
( y -axis - the number of requests per second)
In this version of CUBRID 8.4.1, we improved the internal implementation of the database engine to improve the performance of the entire system during parallel processing of transaction logs, writing the memory buffer to disk, as well as performing replication in a High Availability environment.
As a result of all this, the performance of INSERT and UPDATE operations in version 8.4.1 has increased dramatically by more than 70% compared with the previous version 8.4.0.
The following table shows the output of the quality assessment obtained as a result of tests conducted on versions 8.4.0 and 8.4.1.
| Throughput (operas / sec) | 99th percentile latency (ms) | |||||
|---|---|---|---|---|---|---|
| Operations | R4.0 p2 | R4.1 | Performance Factor | R4.0 p2 | R4.1 | Performance Factor |
| Insert | 4085 | 7090 | 174% | 33 | eleven | 167% |
| Select | 24477 | 24739 | 101% | 3 | 3 | 100% |
| Update | 4556 | 8274 | 182% | 28 | 13 | 154% |
| Mix | 3929 | 4402 | 112% | 223 | 218 | 102% |
The test was conducted on a large number of transactions using the YCSB (Yahoo Cloud Serving Benchmark). More information about this test can be found in the CUBRID 8.4.1 Quality Assessment Report (eng.).
New SQL functions and regular expression support
- New SQL functions in version 8.4.1:
ADDTIME, ASCII, BIN, CONV, FIND_IN_SET, HEX, andSERIAL_NEXT_VALUE (serial_name, number). - The
REGEXPoperator is added to refine the search criteria inWHEREconditions. - Data types, such as
DATE, DATETIMEandTIMESTAMP, now support the minimum values of '0000-00-00', '0000-00-00 00:00:00', which gives application developers a smoother transition from MySQL to CUBRID.
Additional features
A list of additional changes can be found in the Notes for the current version (English).
Source: https://habr.com/ru/post/137886/
All Articles