wordpress 建站专家,四川住建厅官方网站的网址,网站备案主体注销,大连网站开发哪家好ClickHouse 这点不错#xff0c;支持MySQL wire通讯协议#xff0c;用 mysql 命令行直接连 ClickHouse 服务器#xff0c;用起来跟 MySQL 几乎一样。
mysql 命令行客户端版本#xff1a;8.0.16
ClickHouse 服务器版本#xff1a;24.1.8.22
不需要任何配置#xff0c;只…ClickHouse 这点不错支持MySQL wire通讯协议用 mysql 命令行直接连 ClickHouse 服务器用起来跟 MySQL 几乎一样。
mysql 命令行客户端版本8.0.16
ClickHouse 服务器版本24.1.8.22
不需要任何配置只要网通用 mysql 使用缺省的 9004 端口连接 ClickHouse 实例的 IP 即可
[mysqlvvgg-z2-music-mysqld~]$mysql --protocol tcp -u default -p123456 -P 9004 -h 172.18.4.126 -e status;select version();show databases;select count(*) from db1.hits_replica_all; -vv 2/dev/null
--------------
mysql Ver 8.0.16 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)Connection id: 24
Current database: default
Current user: default
SSL: Not in use
Current pager: stdout
Using outfile:
Using delimiter: ;
Server version: 24.1.8.22-ClickHouse
Protocol version: 10
Connection: 172.18.4.126 via TCP/IP
Server characterset: 0
Db characterset: 0
Client characterset: 0
Conn. characterset: 0
TCP port: 9004
----------------------------
select version()
-------------------------
| version() |
-----------
| 24.1.8.22 |
-----------
1 row in set (0.01 sec)
Read 1 rows, 1.00 B in 0.000272 sec., 3676 rows/sec., 3.59 KiB/sec.--------------
show databases
----------------------------------
| name |
--------------------
| INFORMATION_SCHEMA |
| db1 |
| default |
| information_schema |
| system |
| tutorial |
--------------------
6 rows in set (0.00 sec)
Read 6 rows, 114.00 B in 0.000443 sec., 13544 rows/sec., 251.31 KiB/sec.--------------
select count(*) from db1.hits_replica_all
-----------------------
| count() |
---------
| 8873898 |
---------
1 row in set (0.00 sec)
Read 2 rows, 32.00 B in 0.004355 sec., 459 rows/sec., 7.18 KiB/sec.Bye
[mysqlvvgg-z2-music-mysqld~]$