Oceanbase version 2.2 experience: running TPC-C with BenchmarkSQL

OB Jun: good news! "Oceanbase version 2.2" is officially launched on the official website! (click to read the original text and download it directly) OceanBase 2.2 is a stable version that successfully supports tmall double 11 in 2019, and it is also the version used for TPC-C testing and ranked first in TPC-C performance. We will con ...

Posted by bamfon on Fri, 13 Mar 2020 11:36:25 +0100

Azure configuration management series Oracle Linux (PART3)

Azure configuration management series Oracle Linux (PART1) Azure configuration management series Oracle Linux (PART2) Azure configuration management series Oracle Linux (PART4) 4. Install VNC server in Oracle Linux VM In this article, describe the process of installing VNC server in Oracle Linux VM. To set up the VNC server, we perform the fol ...

Posted by Darkwoods on Wed, 04 Mar 2020 12:18:46 +0100

8. Adding Paging Extensions to DAO

Why extend DAO?In the previous section, I mentioned that the DAO generated by jOOQ has some basic CRID methods, as well as some query methods for each field.However, these methods are relatively simple and based on a single field to query, which is not enough to face complex business scenarios. For ...

Posted by Adthegreat on Wed, 04 Mar 2020 02:30:17 +0100

Technology sharing calculation method of MySQL field length limit

Author: kay is good at Oracle, mysql, PostgresSQL and other database fields. He is good at Oracle, MySQL performance optimization, database architecture design, database fault repair, data migration and recovery. He is keen on studying MySQL database kernel source code and sharing technical articles. He has Oracle OCP certification and works i ...

Posted by foo on Thu, 27 Feb 2020 11:04:37 +0100

PHP environment building windows

To prepare the Apache and php packages: Link: https://pan.baidu.com/s/1xclkowi-a3r8oeyften3a Extraction code: whjj Install Apache 1. Modify the httpd.conf configuration in the Apache24\conf \ directory, and open the httpd.conf file in Notepad 2. Find the item "Define SRVROOT" and change the ...

Posted by getmukesh on Fri, 14 Feb 2020 08:54:55 +0100

(database) 08 multi table query

08 multi table query 1, Multi table query 1. Cartesian set 2, Oracle connection 1. Equivalent connection 2. Multiple join conditions AND and operators 1. Distinguish duplicate column names 2. Alias of table 3. Multi table associated query 4. Non equivalent connection 5. external connection 1. Int ...

Posted by tensitY on Tue, 11 Feb 2020 08:24:15 +0100

Function introduction of MySQL8 role

The role function is not special for Oracle database. However, for MySQL, the role function added in MySQL 8.0 is quite novel, which is also what many users of MySQL have been expecting The role function added in MySQL 8.0 allows DBAs to create roles, grant permissions to them, and authorize users. Using roles can greatly reduce the work of DB ...

Posted by wblati on Mon, 10 Feb 2020 12:31:48 +0100

ORA-00600 KGLDELETEALLPINSONOBJ1 a BUG crossing 10g/11g/12c

A friend on motianlun encountered a rare ORA-600 error. The first error parameter is KGLDELETEALLPINSONOBJ1. From the naming of KGLDELETEALLPINSONOBJ1, we can quickly guess the basic situation: KGL - Kernel Generic Library cache, which means that the problem lies in the Library Cache level; DELET ...

Posted by Ind007 on Thu, 06 Feb 2020 09:03:03 +0100

The bootstrap navigation bar enables the mouse to move in and expand the event, highlighting the event

HTML code: <nav class="nav1 navbar navbar-default navbar-fixed-top" style="border-Radius:0px;"> <div class="container"> <div class="navbar-header"> <a href="#" class="navbar-brand">logo</a> <button type="button" class="navbar-toggle" data-toggle="collapse" data-tar ...

Posted by midgar777 on Sat, 01 Feb 2020 00:59:32 +0100

Quick start to basic operation of mysql-8.0.18

Quick start to mysql-8.0 basic operation 1 mysql download and installation Go to mysql official website Download the corresponding version. The version I choose is mysql-8.0.18-winx64 Unzip the downloaded package, enter the internal bin directory in the cmd window, and start the mysql background ser ...

Posted by piyush23424 on Wed, 29 Jan 2020 18:00:39 +0100