初次体验崖山数据库

〇〇

最简安装过程

root@localhost:~# useradd yashan
root@localhost:~# passwd yashan
New password:
Retype new password:
passwd: password updated successfully
root@localhost:~# su yashan
$ mkdir /home/yashan
$ exit
root@localhost:~# su yashan
$ pwd
/root
$ exit
root@localhost:~# su - yashan
$ pwd
/home/yashan
$ mkdir install
$ cd install
$ tar -zxf /storage/emulated/0/Download/Browser/yashandb-personal-23.1.1.100-linux-aarch64.tar.gz
$ cd scripts
$ ./install.sh
sed: can't read /home/yashan/.bashrc: No such file or directory
$ cat /home/yashan/.bashrc
[ -f /home/yashan/yashandb/yasdb_home/conf/yasdb.bashrc ] && source /home/yashan/yashandb/yasdb_home/conf/yasdb.bashrc
$ cat /home/yashan/yashandb/yasdb_home/conf/yasdb.bashrc > /home/yashan/.bashrc
$ . /home/yashan/.bashrc
$ ./initDB.sh
process started!
Database open succeed !
$ cd /home/yashan/yashandb/yasdb_data/instance
$ mv yasdb.pwd yasdb1.pwd
$ yaspwd file=yasdb.pwd
Enter password for SYS:Yashan-1
$ yasql sys/Yashan-1
YashanDB SQL Personal Edition Release 23.1.1.100 aarch64

Connected to:
YashanDB Server Personal Edition Release 23.1.1.100 aarch64 - X86 64bit Linux

SQL> select * from dual;

DUMMY
-----
X

1 row fetched.

SQL> set timi on
SQL> select sum(level)from dual connect by level<1000000;

SUM(LEVEL)
-----------
5.0000E+11

1 row fetched.

Elapsed: 00:00:00.265

〇〇

关闭数据库实例可以shutdown,但是启动数据库要
$ nohup yasdb open &
$ nohup: ignoring input and appending output to 'nohup.out'
而不能
$ yasql sys/Yashan-1再startup
http://doc.yashandb.com/yashandb/22.2/zh/%E8%BF%90%E7%BB%B4%E6%89%8B%E5%86%8C/%E5%9F%BA%E6%9C%AC%E6%95%B0%E6%8D%AE%E5%BA%93%E7%AE%A1%E7%90%86/%E5%AE%9E%E4%BE%8B%E5%90%AF%E5%81%9C.html

newkid

很多数据库在单项指标上都可以打败ORACLE,但是放到现实世界中走两步，就会发现差距了。