Nolio Official KB: Collecting Nolio Schema information

Document created by MaryGreening on Jul 8, 2014
Version 1Show Document
  • View in full screen mode
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

Attachments

    Outcomes