47 lines
1.1 KiB
SQL
Executable File
47 lines
1.1 KiB
SQL
Executable File
PURGE BINARY LOGS BEFORE NOW();
|
|
|
|
USE market_data;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE analystpricetarget;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE analystratings;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE balancesheet;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE incomestatement;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE cashflowstatement;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE dividendhistory;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE etfholdings;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE fundamentals;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE historical;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE insidertransaction;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE options;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE prices;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE secfilings;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE valuations;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE yieldcurve;
|
|
|
|
use portfolio_data;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE accounts;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE cash;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE trades;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE watchlist;
|
|
|
|
OPTIMIZE NO_WRITE_TO_BINLOG TABLE watchlists;
|
|
|