root@ubuntu1604lts:/home/ushastry/Downloads/5615# cat /etc/*release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=16.04 DISTRIB_CODENAME=xenial DISTRIB_DESCRIPTION="Ubuntu 16.04.2 LTS" NAME="Ubuntu" VERSION="16.04.2 LTS (Xenial Xerus)" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 16.04.2 LTS" VERSION_ID="16.04" HOME_URL="http://www.ubuntu.com/" SUPPORT_URL="http://help.ubuntu.com/" BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/" VERSION_CODENAME=xenial UBUNTU_CODENAME=xenial root@ubuntu1604lts:/home/ushastry/Downloads/5615# dpkg -l|grep mysql ii libmysqlclient-dev 5.7.15-1ubuntu16.04 amd64 MySQL development headers ii libmysqlclient20:amd64 5.7.15-1ubuntu16.04 amd64 MySQL shared client libraries ii libmysqld-dev 5.7.15-1ubuntu16.04 amd64 MySQL embedded server library ii mysql-apt-config 0.8.3-1 all Auto configuration for MySQL APT Repo. ii mysql-client 5.7.15-1ubuntu16.04 amd64 MySQL Client meta package depending on latest version ii mysql-common 5.7.15-1ubuntu16.04 amd64 MySQL Common ii mysql-community-client 5.7.15-1ubuntu16.04 amd64 MySQL Client iF mysql-community-server 5.7.15-1ubuntu16.04 amd64 MySQL Server ii mysql-connector-python 2.1.3-1ubuntu15.04 all MySQL database driver written in Python rc mysql-router 2.0.4-1ubuntu16.04 amd64 MySQL Router ii mysql-shell:amd64 1.0.4-1ubuntu16.04 amd64 MySQL Shell rc mysql-utilities 1.6.1-2 all collection of scripts for managing MySQL servers rc mysql-workbench-community 6.3.9-1ubuntu16.04 amd64 MySQL Workbench root@ubuntu1604lts:/home/ushastry/Downloads/5615# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.15 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database test; Query OK, 1 row affected (0.00 sec) mysql> use test Database changed mysql> create database if not exists test; Query OK, 1 row affected, 1 warning (0.00 sec) mysql> use test; Database changed mysql> drop table if exists keyvalue; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> CREATE TABLE `keyvalue` ( -> `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, -> `name1` varchar(250), -> `name2` varchar(250), -> `name3` varchar(250), -> `name4` varchar(250), -> PRIMARY KEY (`id`, name1(10)) -> ) ENGINE=innodb; Query OK, 0 rows affected (0.02 sec) mysql> mysql> set @id:=0; Query OK, 0 rows affected (0.00 sec) mysql> mysql> insert into `keyvalue` values -> (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)); Query OK, 4 rows affected (0.12 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> mysql> insert into `keyvalue`(`id`,`name1`,`name2`,`name3`,`name4`) -> select @id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000) from -> `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9, -> `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit 10000; Query OK, 10000 rows affected (0.67 sec) Records: 10000 Duplicates: 0 Warnings: 0 mysql> \q Bye root@ubuntu1604lts:/home/ushastry/Downloads/5615# apt-get update Hit:1 http://repo.mysql.com/apt/ubuntu xenial InRelease Hit:2 http://us.archive.ubuntu.com/ubuntu xenial InRelease Hit:3 http://ppa.launchpad.net/ubuntu-toolchain-r/test/ubuntu xenial InRelease Get:4 http://security.ubuntu.com/ubuntu xenial-security InRelease [102 kB] Get:5 http://us.archive.ubuntu.com/ubuntu xenial-updates InRelease [102 kB] Get:6 http://us.archive.ubuntu.com/ubuntu xenial-backports InRelease [102 kB] Get:7 http://security.ubuntu.com/ubuntu xenial-security/main amd64 Packages [236 kB] Get:8 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 Packages [503 kB] Get:9 http://security.ubuntu.com/ubuntu xenial-security/main i386 Packages [228 kB] Get:10 http://security.ubuntu.com/ubuntu xenial-security/main Translation-en [100 kB] Get:11 http://security.ubuntu.com/ubuntu xenial-security/main amd64 DEP-11 Metadata [54.3 kB] Get:12 http://us.archive.ubuntu.com/ubuntu xenial-updates/main i386 Packages [493 kB] Get:13 http://security.ubuntu.com/ubuntu xenial-security/main DEP-11 64x64 Icons [42.4 kB] Get:14 http://security.ubuntu.com/ubuntu xenial-security/universe amd64 DEP-11 Metadata [32.2 kB] Get:15 http://security.ubuntu.com/ubuntu xenial-security/universe DEP-11 64x64 Icons [37.0 kB] Get:16 http://us.archive.ubuntu.com/ubuntu xenial-updates/main Translation-en [202 kB] Get:17 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 DEP-11 Metadata [288 kB] Get:18 http://us.archive.ubuntu.com/ubuntu xenial-updates/main DEP-11 64x64 Icons [186 kB] Get:19 http://us.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 Packages [451 kB] Get:20 http://us.archive.ubuntu.com/ubuntu xenial-updates/universe i386 Packages [437 kB] Get:21 http://us.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 DEP-11 Metadata [160 kB] Get:22 http://us.archive.ubuntu.com/ubuntu xenial-updates/universe DEP-11 64x64 Icons [188 kB] Get:23 http://us.archive.ubuntu.com/ubuntu xenial-updates/multiverse amd64 DEP-11 Metadata [2,520 B] Get:24 http://us.archive.ubuntu.com/ubuntu xenial-backports/main amd64 Packages [4,684 B] Get:25 http://us.archive.ubuntu.com/ubuntu xenial-backports/main i386 Packages [4,684 B] Get:26 http://us.archive.ubuntu.com/ubuntu xenial-backports/main Translation-en [3,216 B] Get:27 http://us.archive.ubuntu.com/ubuntu xenial-backports/main amd64 DEP-11 Metadata [3,324 B] Fetched 3,963 kB in 23s (172 kB/s) Reading package lists... Done root@ubuntu1604lts:/home/ushastry/Downloads/5615# root@ubuntu1604lts:/home/ushastry/Downloads/5615# apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libaec0 libdbi-perl libgeos-3.5.0 libgeos-c1v5 libgfortran3 libhdf4-0-alt libhdf5-10 libnetcdf11 libpcrecpp0v5 libpq5 libsz2 libterm-readkey-perl libxerces-c3.1 libzip4 linux-headers-4.4.0-63 linux-headers-4.4.0-63-generic linux-image-4.4.0-63-generic linux-image-extra-4.4.0-63-generic python-crypto python-ecdsa python-paramiko python-six Use 'apt autoremove' to remove them. The following additional packages will be installed: libmysqlclient-dev libmysqlclient20 libmysqld-dev mysql-client mysql-common mysql-community-client mysql-community-server The following NEW packages will be installed: mysql-server The following packages will be upgraded: libmysqlclient-dev libmysqlclient20 libmysqld-dev mysql-client mysql-common mysql-community-client mysql-community-server 7 upgraded, 1 newly installed, 0 to remove and 13 not upgraded. 1 not fully installed or removed. Need to get 19.4 MB/51.6 MB of archives. After this operation, 17.2 MB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://repo.mysql.com/apt/ubuntu xenial/mysql-5.7 amd64 libmysqld-dev amd64 5.7.17-1ubuntu16.04 [17.4 MB] Get:2 http://repo.mysql.com/apt/ubuntu xenial/mysql-5.7 amd64 libmysqlclient-dev amd64 5.7.17-1ubuntu16.04 [1,190 kB] Get:3 http://repo.mysql.com/apt/ubuntu xenial/mysql-5.7 amd64 libmysqlclient20 amd64 5.7.17-1ubuntu16.04 [841 kB] Fetched 19.4 MB in 1min 15s (256 kB/s) Preconfiguring packages ... (Reading database ... 247607 files and directories currently installed.) Preparing to unpack .../mysql-community-server_5.7.17-1ubuntu16.04_amd64.deb ... . Unpacking mysql-community-server (5.7.17-1ubuntu16.04) over (5.7.15-1ubuntu16.04) ... Preparing to unpack .../mysql-client_5.7.17-1ubuntu16.04_amd64.deb ... Unpacking mysql-client (5.7.17-1ubuntu16.04) over (5.7.15-1ubuntu16.04) ... Preparing to unpack .../libmysqld-dev_5.7.17-1ubuntu16.04_amd64.deb ... Unpacking libmysqld-dev (5.7.17-1ubuntu16.04) over (5.7.15-1ubuntu16.04) ... Preparing to unpack .../libmysqlclient-dev_5.7.17-1ubuntu16.04_amd64.deb ... Unpacking libmysqlclient-dev (5.7.17-1ubuntu16.04) over (5.7.15-1ubuntu16.04) ... Preparing to unpack .../libmysqlclient20_5.7.17-1ubuntu16.04_amd64.deb ... Unpacking libmysqlclient20:amd64 (5.7.17-1ubuntu16.04) over (5.7.15-1ubuntu16.04) ... Preparing to unpack .../mysql-common_5.7.17-1ubuntu16.04_amd64.deb ... Unpacking mysql-common (5.7.17-1ubuntu16.04) over (5.7.15-1ubuntu16.04) ... Preparing to unpack .../mysql-community-client_5.7.17-1ubuntu16.04_amd64.deb ... Unpacking mysql-community-client (5.7.17-1ubuntu16.04) over (5.7.15-1ubuntu16.04) ... Selecting previously unselected package mysql-server. Preparing to unpack .../mysql-server_5.7.17-1ubuntu16.04_amd64.deb ... Unpacking mysql-server (5.7.17-1ubuntu16.04) ... Processing triggers for systemd (229-4ubuntu16) ... Processing triggers for ureadahead (0.100.0-19) ... Processing triggers for man-db (2.7.5-1) ... Processing triggers for libc-bin (2.23-0ubuntu7) ... Setting up mysql-common (5.7.17-1ubuntu16.04) ... Setting up mysql-community-client (5.7.17-1ubuntu16.04) ... Setting up mysql-client (5.7.17-1ubuntu16.04) ... Setting up mysql-community-server (5.7.17-1ubuntu16.04) ... Installing new version of config file /etc/apparmor.d/usr.sbin.mysqld ... Installing new version of config file /etc/init.d/mysql ... Setting up libmysqlclient20:amd64 (5.7.17-1ubuntu16.04) ... Setting up libmysqlclient-dev (5.7.17-1ubuntu16.04) ... Setting up libmysqld-dev (5.7.17-1ubuntu16.04) ... Setting up mysql-server (5.7.17-1ubuntu16.04) ... Processing triggers for systemd (229-4ubuntu16) ... Processing triggers for ureadahead (0.100.0-19) ... Processing triggers for libc-bin (2.23-0ubuntu7) ... root@ubuntu1604lts:/home/ushastry/Downloads/5615# dpkg -l|grep mysql ii libmysqlclient-dev 5.7.17-1ubuntu16.04 amd64 MySQL development headers ii libmysqlclient20:amd64 5.7.17-1ubuntu16.04 amd64 MySQL shared client libraries ii libmysqld-dev 5.7.17-1ubuntu16.04 amd64 MySQL embedded server library ii mysql-apt-config 0.8.3-1 all Auto configuration for MySQL APT Repo. ii mysql-client 5.7.17-1ubuntu16.04 amd64 MySQL Client meta package depending on latest version ii mysql-common 5.7.17-1ubuntu16.04 amd64 MySQL Common ii mysql-community-client 5.7.17-1ubuntu16.04 amd64 MySQL Client ii mysql-community-server 5.7.17-1ubuntu16.04 amd64 MySQL Server ii mysql-connector-python 2.1.3-1ubuntu15.04 all MySQL database driver written in Python rc mysql-router 2.0.4-1ubuntu16.04 amd64 MySQL Router ii mysql-server 5.7.17-1ubuntu16.04 amd64 MySQL Server meta package depending on latest version ii mysql-shell:amd64 1.0.4-1ubuntu16.04 amd64 MySQL Shell rc mysql-utilities 1.6.1-2 all collection of scripts for managing MySQL servers rc mysql-workbench-community 6.3.9-1ubuntu16.04 amd64 MySQL Workbench root@ubuntu1604lts:/home/ushastry/Downloads/5615# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.17 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | keyvalue | +----------------+ 1 row in set (0.00 sec) mysql>