# mysql

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 4

Server version: 10.1.11-MariaDB-1~jessie marispider_tablesadb.org binary distribution

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SELECT table_schema,

    -> sum( data_length ) as "data",

    -> sum( index_length ) as "index",

    -> sum( data_free ) as "data_free" ,

    -> count(1) as "tables",

    -> sum(TABLE_ROWS) as "rows",

    -> DEFAULT_CHARACTER_SET_NAME,

    -> DEFAULT_COLLATION_NAME

    -> FROM information_schema.TABLES a

    -> INNER JOIN information_schema.SCHEMATA b ON a.table_schema = b.SCHEMA_NAME

    -> GROUP BY table_schema;

ERROR 2013 (HY000): Lost connection to MySQL server during query

MariaDB [(none)]> show databases;

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")

ERROR: Can't connect to the server

DROP TABLE backend.sbtest;

CREATE TABLE `sbtest` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `k` int(10) unsigned NOT NULL DEFAULT '0',

  `c` char(120) NOT NULL DEFAULT '',

  `pad` char(60) NOT NULL DEFAULT '',

  PRIMARY KEY (`id`),

  KEY `k` (`k`)

) ENGINE=SPIDER DEFAULT CHARSET=latin1 COMMENT='wrapper "mysql", table "sbtest"'

/*!50100 PARTITION BY KEY (`id`)

(PARTITION pt1 COMMENT = 'srv "backend1"' ENGINE = SPIDER,

 PARTITION pt2 COMMENT = 'srv "backend2"' ENGINE = SPIDER) */