ndb_size.pl — NDBCLUSTER Size Requirement Estimator Format Description Added, Deprecated, or Removed --socket=file_name Specify socket to connect to (Supported in all NDB releases based on MySQL 8.0) --user=string Specify MySQL user name (Supported in all NDB releases based on MySQL 8.0) --password=string Specify MySQL user password (Supported in all NDB releases based on MySQL 8.0) --format=string Set output format (text or HTML) (Supported in all NDB releases based on MySQL 8.0) --excludetables=tbl_list Skip any tables in comma- separated list (Supported in all NDB releases based on MySQL 8.0) --excludedbs=db_list Skip any databases in comma- separated list (Supported in all NDB releases based on MySQL 8.0) --savequeries=file Saves all queries on database into file specified (Supported in all NDB releases based on MySQL 8.0) --loadqueries=file Loads all queries from file specified; does not connect to database (Supported in all NDB releases based on MySQL 8.0) --real_table_name=table Designates table to handle unique index size calculations (Supported in all NDB releases based on MySQL 8.0) Usage perl ndb_size.pl [--database={ db_name |ALL}] [--hostname= host [: port ]] [--socket= socket ] \ [--user= user ] [--password= password ] \ [--help|-h] [--format={html|text}] \ [--loadqueries= file_name ] [--savequeries= file_name ] By default, this utility attempts to analyze all databases on the server. You can specify a single database using the  --database  option; the default behavior can be made explicit by using  ALL  for the name of the database. You can also exclude one or more databases by using the  --excludedbs  option with a comma-separated list of the names of the databases to be skipped. Similarly, you can cause specific tables to be skipped by listing their names, separated by commas, following the optional  -- excludetables  option. A host name can be specified using  --hostname ; the default is  localhost . You can specify a port in addition to the host using  host : port  format for the value of  --hostname . The default port number is 3306. If necessary, you can also specify a socket; the default is  /var/lib/ mysql.sock . A MySQL user name and password can be specified the corresponding options shown. It also possible to control the format of the output using the  --format  option; this can take either of the values  html  or  text , with  text  being the default. An example of the text output is shown here: shell>  ndb_size.pl --database=test --socket=/tmp/mysql.sock ndb_size.pl report for database: ’test’ (1 tables) -------------------------------------------------- Connected to: DBI:mysql:host=localhost;mysql_socket=/tmp/mysql.sock Including information for versions: 4.1, 5.0, 5.1 test.t1 ------- DataMemory for Columns (* means varsized DataMemory): Column Name Type Varsized Key 4.1 5.0 5.1 HIDDEN_NDB_PKEY bigint PRI 8 8 8 c2 varchar(50) Y 52 52 4* 4420