Automatically warm up your disk after resuming workspace

1import pandas as pd2import singlestoredb as s23s2_conn = s2.connect()4s2_cur = s2_conn.cursor()

1database_name = input('Enter database name:')

1query = """SELECT table_name FROM information_schema.tables WHERE table_schema = '{}' AND table_type = 'BASE TABLE' AND storage_type = 'COLUMNSTORE';""".format(database_name)2result = s2_cur.execute(query)3result_df = pd.DataFrame(list(s2_cur))4list_of_tables = result_df[[0]].values

1# get queries to warm up columm files2column_queries_df = pd.DataFrame()3
4for table_name in list_of_tables:5    query = """ WITH t1 AS (SELECT c.column_name, c.ordinal_position, MAX(c.ordinal_position) OVER (ORDER BY c.ordinal_position DESC) AS last_row FROM information_schema.columns c JOIN information_schema.tables t ON c.table_catalog = t.table_catalog AND c.table_schema = t.table_schema AND c.table_name = t.table_name WHERE c.table_schema = '{0}' AND c.table_name = '{1}') SELECT CASE WHEN ordinal_position = 1 AND ordinal_position = last_row THEN CONCAT('SELECT ', 'AVG(LENGTH(`',column_name,'`)) FROM ', '{1}') WHEN ordinal_position = 1 and ordinal_position != last_row THEN CONCAT('SELECT ', 'AVG(LENGTH(`',column_name,'`)),') WHEN ordinal_position != last_row THEN CONCAT('AVG(LENGTH(`',column_name,'`)),') ELSE CONCAT('AVG(LENGTH(`',column_name,'`)) FROM ', '{1}') END AS query_text FROM t1 ORDER BY ordinal_position; """.format(database_name, table_name[0])6    result = s2_cur.execute(query)7    result_df = pd.DataFrame(list(s2_cur))8    result_df['table_name'] = table_name[0]9    column_queries_df = pd.concat([column_queries_df, result_df], axis=0)10
11column_queries_df.rename(columns = {0:'query_text'}, inplace = True)12final_column_df = column_queries_df.groupby('table_name')['query_text'].apply(' '.join).reset_index()13final_column_df['query_text'] = final_column_df['query_text'].astype(str) + ';'14
15# run column file warm up queries16for query in final_column_df[['query_text']].values:17    s2_cur.execute(""" {} """.format(query[0]))

1# get queries to warm up index files2index_queries_df = pd.DataFrame()3
4for table_name in list_of_tables:5    query = """ SELECT DISTINCT CONCAT("OPTIMIZE TABLE ", table_name, " WARM BLOB CACHE FOR INDEX ", "`", index_name, "`", ";") FROM information_schema.statistics WHERE TABLE_SCHEMA = '{}' AND index_type = 'COLUMNSTORE HASH' AND table_name = '{}'; """.format(database_name, table_name[0])6    result = s2_cur.execute(query)7    result_df = pd.DataFrame(list(s2_cur))8    index_queries_df = pd.concat([index_queries_df, result_df], axis=0)9
10# run index file warm up queries11for query in index_queries_df.values:12    s2_cur.execute(""" {} """.format(query[0]))