posted 2 years ago in News category by Esen Sagynov
We have been waiting for this day for a long time! On behalf of CUBRID Development Lab I am very proud to announce the release of the new CUBRID 8.4.1 which is 70% faster then the previous version!
CUBRID 8.4.1 is available for download right now!
Thanks to all of those who have reported bugs, CUBRID developers have done really great job on improving both the performance and stability of the database server. While performing tests on large amount of transaction, performance of INSERT and UPDATE was improved over 70%.
Also, according to your requests we have added many new functions and SQL syntaxes to make CUBRID more compatible with MySQL. Moreover, regular expressions are now supported in conditional search, broker parameters are added, and monitoring features have been improved. In addition, approximately 50 major and minor bugs have been fixed.
Below I will list new features and major changes in this new release.
Improved Performance of INSERT and UPDATE more than 70%
(y-axis refers to the number of queries per second)
In CUBRID 8.4.1 we have improved the internal implementation of the Engine to enhance the performance during simultaneous processing of transaction logs, writing memory buffers to a disk, and performing replication for HA. Consequently, the performance of INSERT and UPDATE operations was dramatically improved over 70% in comparison with 2008 R4.0 Patch 2 version.
The following table illustrates the overall performance increase gained in CUBRID 8.4.1.
|Throughput (ops/sec)||99th Percentile Latency (ms)|
|Operations||R4.0 P2||R4.1||Performance Ratio||R4.0 P2||R4.1||Performance Ratio|
The test has been conducted on large amount of transactions based on YCSB (Yahoo Cloud Serving Benchmark). For more information on performance test, refer to section 2.2.2 in CUBRID 2008 R4.1 QA Completion Report.
New SQL Functions and Regular Expression Support
- In this version we have added new SQL functions: ADDTIME, ASCII, BIN, CONV, FIND_IN_SET, HEX, and SERIAL_NEXT_VALUE (serial_name, number) functions, which can be used to obtain multiple serial values with a single call.
- Added the REGEXP operator in order to allow conditions to be searched with regular expressions.
- DATE, DATETIME, and TIMESTAMP data types now support '0000-00-00', '0000-00-00 00:00:00' lower bound values. This provides more compatibility with MySQL's SQL syntax.
The full list of new features, improvements, and fixes can be found the in CUBRID 2008 R4.1 Release Note.