Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 9
|
Server version: 10.3.11-MariaDB-log Columnstore 1.2.3-1
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]>
|
MariaDB [(none)]> show databases ;
|
+---------------------+
|
| Database |
|
+---------------------+
|
| a |
|
| calpontsys |
|
| columnstore_info |
|
| foo1 |
|
| foo1_1 |
|
| foo2 |
|
| foo2_1 |
|
| infinidb_querystats |
|
| infinidb_vtable |
|
| information_schema |
|
| mysql |
|
| performance_schema |
|
| test |
|
| tpcds_100 |
|
| tpcds_1000 |
|
| tpcds_2 |
|
+---------------------+
|
16 rows in set (0.001 sec)
|
|
MariaDB [(none)]>
|
MariaDB [(none)]> drop database tpcds_100 ;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [(none)]> drop database tpcds_100 ;
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 9
|
Current database: *** NONE ***
|
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [(none)]>
|
MariaDB [(none)]>
|
MariaDB [(none)]>
|
MariaDB [(none)]> drop database tpcds_100 ;
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 9
|
Current database: *** NONE ***
|
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [(none)]>
|
MariaDB [(none)]>
|
MariaDB [(none)]> show databases ;
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 9
|
Current database: *** NONE ***
|
|
+---------------------+
|
| Database |
|
+---------------------+
|
| a |
|
| calpontsys |
|
| columnstore_info |
|
| foo1 |
|
| foo1_1 |
|
| foo2 |
|
| foo2_1 |
|
| infinidb_querystats |
|
| infinidb_vtable |
|
| information_schema |
|
| mysql |
|
| performance_schema |
|
| test |
|
| tpcds_100 |
|
| tpcds_1000 |
|
| tpcds_2 |
|
+---------------------+
|
16 rows in set (0.002 sec)
|
|
MariaDB [(none)]>
|
MariaDB [(none)]>
|
MariaDB [(none)]>
|
MariaDB [(none)]> us tpcds_100 ;
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'us tpcds_100' at line 1
|
MariaDB [(none)]> use tpcds_100 ;
|
Database changed
|
MariaDB [tpcds_100]> show tables ;
|
+------------------------+
|
| Tables_in_tpcds_100 |
|
+------------------------+
|
| call_center |
|
| catalog_page |
|
| catalog_returns |
|
| catalog_sales |
|
| customer |
|
| customer_address |
|
| customer_demographics |
|
| date_dim |
|
| household_demographics |
|
| income_band |
|
| inventory |
|
| item |
|
| promotion |
|
| reason |
|
| ship_mode |
|
| store |
|
| store_returns |
|
| store_sales |
|
| time_dim |
|
| warehouse |
|
| web_page |
|
| web_returns |
|
| web_sales |
|
| web_site |
|
+------------------------+
|
24 rows in set (0.001 sec)
|
|
MariaDB [tpcds_100]> drop table call_center ;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [tpcds_100]>
|
MariaDB [tpcds_100]> show tables ;
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 9
|
Current database: tpcds_100
|
|
+------------------------+
|
| Tables_in_tpcds_100 |
|
+------------------------+
|
| call_center |
|
| catalog_page |
|
| catalog_returns |
|
| catalog_sales |
|
| customer |
|
| customer_address |
|
| customer_demographics |
|
| date_dim |
|
| household_demographics |
|
| income_band |
|
| inventory |
|
| item |
|
| promotion |
|
| reason |
|
| ship_mode |
|
| store |
|
| store_returns |
|
| store_sales |
|
| time_dim |
|
| warehouse |
|
| web_page |
|
| web_returns |
|
| web_sales |
|
| web_site |
|
+------------------------+
|
24 rows in set (0.002 sec)
|
|
MariaDB [tpcds_100]> drop table web_site ;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [tpcds_100]> Ctrl-C -- exit!
|
Aborted
|
[root@um1 mariadb-columnstore-tpcds]# /usr/local//mariadb/columnstore/mysql/bin/
|
aria_chk msql2mysql myrocks_hotbackup mysql_convert_table_format mysqldumpslow mysql_plugin mysql_upgrade sst_dump
|
aria_dump_log myisamchk mysql mysqld mysql_find_rows mysql_secure_installation mysql_waitpid tokuftdump
|
aria_ftdump myisam_ftdump mysqlaccess mysqld_multi mysql_fix_extensions mysql_setpermission perror tokuft_logprint
|
aria_pack myisamlog mysqladmin mysqld_safe mysqlhotcopy mysqlshow replace
|
aria_read_log myisampack mysqlbinlog mysqld_safe_helper mysqlimport mysqlslap resolveip
|
innochecksum my_print_defaults mysqlcheck mysqldump mysql_ldb mysql_tzinfo_to_sql resolve_stack_dump
|
[root@um1 mariadb-columnstore-tpcds]# /usr/local//mariadb/columnstore/mysql/bin/my
|
myisamchk my_print_defaults mysqladmin mysqld mysqldump mysqlhotcopy mysql_secure_installation mysql_tzinfo_to_sql
|
myisam_ftdump myrocks_hotbackup mysqlbinlog mysqld_multi mysqldumpslow mysqlimport mysql_setpermission mysql_upgrade
|
myisamlog mysql mysqlcheck mysqld_safe mysql_find_rows mysql_ldb mysqlshow mysql_waitpid
|
myisampack mysqlaccess mysql_convert_table_format mysqld_safe_helper mysql_fix_extensions mysql_plugin mysqlslap
|
[root@um1 mariadb-columnstore-tpcds]# /usr/local//mariadb/columnstore/mysql/bin/mysql_upgrade
|
This installation of MySQL is already upgraded to 10.3.11-MariaDB, use --force if you still need to run mysql_upgrade
|
[root@um1 mariadb-columnstore-tpcds]#
|
[root@um1 mariadb-columnstore-tpcds]# /usr/local//mariadb/columnstore/mysql/bin/mysql_upgrade --force
|
Phase 1/7: Checking and upgrading mysql database
|
Processing databases
|
mysql
|
mysql.column_stats OK
|
mysql.columns_priv OK
|
mysql.db OK
|
mysql.event OK
|
mysql.func OK
|
mysql.gtid_slave_pos OK
|
mysql.help_category OK
|
mysql.help_keyword OK
|
mysql.help_relation OK
|
mysql.help_topic OK
|
mysql.host OK
|
mysql.index_stats OK
|
mysql.innodb_index_stats OK
|
mysql.innodb_table_stats OK
|
mysql.plugin OK
|
mysql.proc OK
|
mysql.procs_priv OK
|
mysql.proxies_priv OK
|
mysql.roles_mapping OK
|
mysql.servers OK
|
mysql.table_stats OK
|
mysql.tables_priv OK
|
mysql.time_zone OK
|
mysql.time_zone_leap_second OK
|
mysql.time_zone_name OK
|
mysql.time_zone_transition OK
|
mysql.time_zone_transition_type OK
|
mysql.transaction_registry OK
|
mysql.user OK
|
Phase 2/7: Installing used storage engines... Skipped
|
Phase 3/7: Fixing views
|
Phase 4/7: Running 'mysql_fix_privilege_tables'
|
Phase 5/7: Fixing table and database names
|
Phase 6/7: Checking and upgrading tables
|
Processing databases
|
a
|
calpontsys
|
calpontsys.syscolumn OK
|
calpontsys.systable OK
|
columnstore_info
|
foo1
|
foo1.call_center OK
|
foo1.catalog_page OK
|
foo1.catalog_returns OK
|
foo1.catalog_sales OK
|
foo1.customer OK
|
foo1.customer_address OK
|
foo1.customer_demographics OK
|
foo1.date_dim OK
|
foo1.household_demographics OK
|
foo1.income_band OK
|
foo1.inventory OK
|
foo1.item OK
|
foo1.promotion OK
|
foo1.reason OK
|
foo1.ship_mode OK
|
foo1.store OK
|
foo1.store_returns OK
|
foo1.store_sales OK
|
foo1.time_dim OK
|
foo1.warehouse OK
|
foo1.web_page OK
|
foo1.web_returns OK
|
foo1.web_sales OK
|
foo1.web_site OK
|
foo1_1
|
foo1_1.call_center OK
|
foo1_1.catalog_page OK
|
foo1_1.catalog_returns OK
|
foo1_1.catalog_sales OK
|
foo1_1.customer OK
|
foo1_1.customer_address OK
|
foo1_1.customer_demographics OK
|
foo1_1.date_dim OK
|
foo1_1.household_demographics OK
|
foo1_1.income_band OK
|
foo1_1.inventory OK
|
foo1_1.item OK
|
foo1_1.promotion OK
|
foo1_1.reason OK
|
foo1_1.ship_mode OK
|
foo1_1.store OK
|
foo1_1.store_returns OK
|
foo1_1.store_sales OK
|
foo1_1.time_dim OK
|
foo1_1.warehouse OK
|
foo1_1.web_page OK
|
foo1_1.web_returns OK
|
foo1_1.web_sales OK
|
foo1_1.web_site OK
|
foo2
|
foo2.call_center OK
|
foo2.catalog_page OK
|
foo2.catalog_returns OK
|
foo2.catalog_sales OK
|
foo2.customer OK
|
foo2.customer_address OK
|
foo2.customer_demographics OK
|
foo2.date_dim OK
|
foo2.dbgen_version OK
|
foo2.household_demographics OK
|
foo2.income_band OK
|
foo2.inventory OK
|
foo2.item OK
|
foo2.promotion OK
|
foo2.reason OK
|
foo2.ship_mode OK
|
foo2.store OK
|
foo2.store_returns OK
|
foo2.store_sales OK
|
foo2.time_dim OK
|
foo2.warehouse OK
|
foo2.web_page OK
|
foo2.web_returns OK
|
foo2.web_sales OK
|
foo2.web_site OK
|
foo2_1
|
foo2_1.call_center OK
|
foo2_1.catalog_page OK
|
foo2_1.catalog_returns OK
|
foo2_1.catalog_sales OK
|
foo2_1.customer OK
|
foo2_1.customer_address OK
|
foo2_1.customer_demographics OK
|
foo2_1.date_dim OK
|
foo2_1.household_demographics OK
|
foo2_1.income_band OK
|
foo2_1.inventory OK
|
foo2_1.item OK
|
foo2_1.promotion OK
|
foo2_1.reason OK
|
foo2_1.ship_mode OK
|
foo2_1.store OK
|
foo2_1.store_returns OK
|
foo2_1.store_sales OK
|
foo2_1.time_dim OK
|
foo2_1.warehouse OK
|
foo2_1.web_page OK
|
foo2_1.web_returns OK
|
foo2_1.web_sales OK
|
foo2_1.web_site OK
|
infinidb_querystats
|
infinidb_querystats.priority OK
|
infinidb_querystats.querystats OK
|
infinidb_querystats.user_priority OK
|
infinidb_vtable
|
information_schema
|
performance_schema
|
test
|
tpcds_100
|
tpcds_100.call_center OK
|
tpcds_100.catalog_page OK
|
tpcds_100.catalog_returns OK
|
tpcds_100.catalog_sales OK
|
tpcds_100.customer OK
|
tpcds_100.customer_address OK
|
tpcds_100.customer_demographics OK
|
tpcds_100.date_dim OK
|
tpcds_100.household_demographics OK
|
tpcds_100.income_band OK
|
tpcds_100.inventory OK
|
tpcds_100.item OK
|
tpcds_100.promotion OK
|
tpcds_100.reason OK
|
tpcds_100.ship_mode OK
|
tpcds_100.store OK
|
tpcds_100.store_returns OK
|
tpcds_100.store_sales OK
|
tpcds_100.time_dim OK
|
tpcds_100.warehouse OK
|
tpcds_100.web_page OK
|
tpcds_100.web_returns OK
|
tpcds_100.web_sales OK
|
tpcds_100.web_site OK
|
tpcds_1000
|
tpcds_1000.call_center OK
|
tpcds_1000.catalog_page OK
|
tpcds_1000.catalog_returns OK
|
tpcds_1000.catalog_sales OK
|
tpcds_1000.customer OK
|
tpcds_1000.customer_address OK
|
tpcds_1000.customer_demographics OK
|
tpcds_1000.date_dim OK
|
tpcds_1000.household_demographics OK
|
tpcds_1000.income_band OK
|
tpcds_1000.inventory OK
|
tpcds_1000.item OK
|
tpcds_1000.promotion OK
|
tpcds_1000.reason OK
|
tpcds_1000.ship_mode OK
|
tpcds_1000.store OK
|
tpcds_1000.store_returns OK
|
tpcds_1000.store_sales OK
|
tpcds_1000.time_dim OK
|
tpcds_1000.warehouse OK
|
tpcds_1000.web_page OK
|
tpcds_1000.web_returns OK
|
tpcds_1000.web_sales OK
|
tpcds_1000.web_site OK
|
tpcds_2
|
tpcds_2.call_center OK
|
tpcds_2.catalog_page OK
|
tpcds_2.catalog_returns OK
|
tpcds_2.catalog_sales OK
|
tpcds_2.customer OK
|
tpcds_2.customer_address OK
|
tpcds_2.customer_demographics OK
|
tpcds_2.date_dim OK
|
tpcds_2.household_demographics OK
|
tpcds_2.income_band OK
|
tpcds_2.inventory OK
|
tpcds_2.item OK
|
tpcds_2.promotion OK
|
tpcds_2.reason OK
|
tpcds_2.ship_mode OK
|
tpcds_2.store OK
|
tpcds_2.store_returns OK
|
tpcds_2.store_sales OK
|
tpcds_2.time_dim OK
|
tpcds_2.warehouse OK
|
tpcds_2.web_page OK
|
tpcds_2.web_returns OK
|
tpcds_2.web_sales OK
|
tpcds_2.web_site OK
|
Phase 7/7: Running 'FLUSH PRIVILEGES'
|
OK
|
[root@um1 mariadb-columnstore-tpcds]# mcsmysql -u root -p1
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 21
|
Server version: 10.3.11-MariaDB-log Columnstore 1.2.3-1
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> drop table tpcds_100.web_site ;
|
Query OK, 0 rows affected (0.276 sec)
|
|
MariaDB [(none)]> drop database tpcds_100 ;
|
Query OK, 23 rows affected (4.297 sec)
|
|
MariaDB [(none)]>
|
|