Release Automation

  • Private Community
Back to discussions
Expand all | Collapse all

Nolio Official KB: Collecting Nolio Schema information

  • 1.  Nolio Official KB: Collecting Nolio Schema information

    Posted Dec 18, 2013 04:44 PM
    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