To increase or decrease the timeout value in Tomcat, please locate the following section in [Tomcat_home]/conf/web.xml:
The timeout value is specified in minutes.
Restart Tomcat after modifying the file, so the changes can take effect.
To get all the table sizes lile
table_schema, table_name, table_rows, avg_row_length, table_data_size, table_index_size… etc….
testDB is a database name.
SELECT table_schema, table_name, table_rows, avg_row_length, (data_length+index_length)/1024/1024/1024 as total_GB, (data_length)/1024/1024/1024 as data_GB, (index_length)/1024/1024/1024 as index_GB FROM information_schema.tables WHERE table_schema in (‘testDB‘);
do <esc>: %s/^M//g
To get the ^M hold the control key, press V then M (Both while holding the control key) and the ^M will appear. This will find all occurances and replace them with nothing.