New CUBRID 8.4.1 - 70% Faster
We have been waiting for this day for quite some time. Based on the policy of releasing new versions, a new release of the CUBRID DBMS is released every six months. So it happened! On behalf of the developers, I am pleased to announce the 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 !
The developers of CUBRID have done a great job in improving 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 table below).
Also, thanks to numerous requests, we have added many new functions and support for additional SQL syntax for even more compatibility with MySQL. In addition, the new version of the DBMS has added support for regular expressions in the operator
Below I will list the main innovations in version 8.4.1.
(the y axis
indicates the number of requests per second) In this version of CUBRID 8.4.1, we improved the internal implementation of the database engine to increase the performance of the entire system during parallel processing of transaction logs, writing the memory buffer to disk, and replication execution in the High environment Availability.
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 to 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 YCSB (Yahoo Cloud Serving Benchmark). You can find more information about this test in the CUBRID 8.4.1 Quality Assessment Completion Report .
You can find a list of additional changes in the Release Notes for the current version .
Download CUBRID 8.4.1 right now from the official site !
The developers of CUBRID have done a great job in improving 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 table below).
Also, thanks to numerous requests, we have added many new functions and support for additional SQL syntax for even more compatibility with MySQL. In addition, the new version of the DBMS has added support for regular expressions in the operator
WHEREfor a clearer declaration of search conditions, as well as new broker parameters and improved system monitoring. In total, about 50 errors were fixed in the new version. Below I will list the main innovations in version 8.4.1.
70% improved INSERT and UPDATE operations performance
(the y axis
indicates the number of requests per second) In this version of CUBRID 8.4.1, we improved the internal implementation of the database engine to increase the performance of the entire system during parallel processing of transaction logs, writing the memory buffer to disk, and replication execution in the High environment Availability.
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 to 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 (opera / sec) | 99th percentile delay (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 | thirteen | 154% |
| Mix | 3929 | 4402 | 112% | 223 | 218 | 102% |
The test was conducted on a large number of transactions using YCSB (Yahoo Cloud Serving Benchmark). You can find more information about this test in the CUBRID 8.4.1 Quality Assessment Completion Report .
New SQL Features and Regular Expression Support
- New SQL features in version 8.4.1:
ADDTIME, ASCII, BIN, CONV, FIND_IN_SET, HEX, andSERIAL_NEXT_VALUE (serial_name, number). - An operator has been added
REGEXPto refine the search criteria in the conditionsWHERE. - Data types such as
DATE, DATETIMEandTIMESTAMPnow 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
You can find a list of additional changes in the Release Notes for the current version .
