Release Automation

Nolio Official KB: Collecting Nolio Schema information

Recommend

Jul 08, 2014 04:54 PM

Anon Anon

This https://docs.google.com/a/noliosoft.com/file/d/0B3kqiA_4g6Y6cktKbkMxOVZIOE0/edit will collect the following information from Nolio Schema: (**Note: SCRIPT IS INTENDED FOR MYSQL DATABASE ONLY**)

1.Date and MySQL version

2.Total size of Nolio's schema (in MBs)

3.Storage Engine used by this schema and the table collation

4.Number of tables

5.Number of rows in each table and its size (in MBs)

In order to execute the script run it from the command line using the following command:

mysql -u[user] -p[password] -v -v -v [nolio-schema-name] < Check-Nolio-Schema-Details.sql > NolioStatistics.txt

This document was generated from the following discussion: Nolio Official KB: Collecting Nolio Schema information

Statistics

0 Favorited

0 Views

0 Files

0 Shares

0 Downloads