Skip to content

Instantly share code, notes, and snippets.

@phanngoc

phanngoc/gist:db658116481a50190742f49464a967f5

Created August 30, 2018 02:05
Show Gist options
  • Save phanngoc/db658116481a50190742f49464a967f5 to your computer and use it in GitHub Desktop.
Save phanngoc/db658116481a50190742f49464a967f5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> SELECT * FROM performance_schema.setup_instruments
-> WHERE NAME LIKE '%memory%';
+--------------------------------------------------------------------------------+---------+-------+
| NAME | ENABLED | TIMED |
+--------------------------------------------------------------------------------+---------+-------+
| memory/performance_schema/mutex_instances | YES | NO |
| memory/performance_schema/rwlock_instances | YES | NO |
| memory/performance_schema/cond_instances | YES | NO |
| memory/performance_schema/file_instances | YES | NO |
| memory/performance_schema/socket_instances | YES | NO |
| memory/performance_schema/metadata_locks | YES | NO |
| memory/performance_schema/file_handle | YES | NO |
| memory/performance_schema/accounts | YES | NO |
| memory/performance_schema/events_waits_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/events_stages_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/events_statements_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/events_transactions_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/memory_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/events_stages_summary_global_by_event_name | YES | NO |
| memory/performance_schema/events_statements_summary_global_by_event_name | YES | NO |
| memory/performance_schema/memory_summary_global_by_event_name | YES | NO |
| memory/performance_schema/hosts | YES | NO |
| memory/performance_schema/events_waits_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/events_stages_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/events_statements_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/events_transactions_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/memory_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/threads | YES | NO |
| memory/performance_schema/events_waits_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/events_stages_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/events_statements_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/events_transactions_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/memory_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/events_waits_history | YES | NO |
| memory/performance_schema/events_stages_history | YES | NO |
| memory/performance_schema/events_statements_history | YES | NO |
| memory/performance_schema/events_statements_history.tokens | YES | NO |
| memory/performance_schema/events_statements_history.sqltext | YES | NO |
| memory/performance_schema/events_statements_current | YES | NO |
| memory/performance_schema/events_statements_current.tokens | YES | NO |
| memory/performance_schema/events_statements_current.sqltext | YES | NO |
| memory/performance_schema/events_transactions_history | YES | NO |
| memory/performance_schema/session_connect_attrs | YES | NO |
| memory/performance_schema/users | YES | NO |
| memory/performance_schema/events_waits_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/events_stages_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/events_statements_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/events_transactions_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/memory_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/mutex_class | YES | NO |
| memory/performance_schema/rwlock_class | YES | NO |
| memory/performance_schema/cond_class | YES | NO |
| memory/performance_schema/thread_class | YES | NO |
| memory/performance_schema/file_class | YES | NO |
| memory/performance_schema/socket_class | YES | NO |
| memory/performance_schema/stage_class | YES | NO |
| memory/performance_schema/statement_class | YES | NO |
| memory/performance_schema/memory_class | YES | NO |
| memory/performance_schema/setup_actors | YES | NO |
| memory/performance_schema/setup_objects | YES | NO |
| memory/performance_schema/events_statements_summary_by_digest | YES | NO |
| memory/performance_schema/events_statements_summary_by_digest.tokens | YES | NO |
| memory/performance_schema/events_stages_history_long | YES | NO |
| memory/performance_schema/events_statements_history_long | YES | NO |
| memory/performance_schema/events_statements_history_long.tokens | YES | NO |
| memory/performance_schema/events_statements_history_long.sqltext | YES | NO |
| memory/performance_schema/events_transactions_history_long | YES | NO |
| memory/performance_schema/events_waits_history_long | YES | NO |
| memory/performance_schema/table_handles | YES | NO |
| memory/performance_schema/table_shares | YES | NO |
| memory/performance_schema/table_io_waits_summary_by_index_usage | YES | NO |
| memory/performance_schema/table_lock_waits_summary_by_table | YES | NO |
| memory/performance_schema/events_statements_summary_by_program | YES | NO |
| memory/performance_schema/prepared_statements_instances | YES | NO |
| memory/performance_schema/scalable_buffer | YES | NO |
| memory/sql/Locked_tables_list::m_locked_tables_root | NO | NO |
| memory/sql/display_table_locks | NO | NO |
| memory/sql/THD::transactions::mem_root | NO | NO |
| memory/sql/Delegate::memroot | NO | NO |
| memory/sql/sql_acl_mem | NO | NO |
| memory/sql/sql_acl_memex | NO | NO |
| memory/sql/acl_cache | NO | NO |
| memory/sql/thd::main_mem_root | NO | NO |
| memory/sql/help | NO | NO |
| memory/sql/new_frm_mem | NO | NO |
| memory/sql/TABLE_SHARE::mem_root | NO | NO |
| memory/sql/gdl | NO | NO |
| memory/sql/Table_triggers_list | NO | NO |
| memory/sql/servers | NO | NO |
| memory/sql/Prepared_statement_map | NO | NO |
| memory/sql/Prepared_statement::main_mem_root | NO | NO |
| memory/sql/Protocol_local::m_rset_root | NO | NO |
| memory/sql/Warning_info::m_warn_root | NO | NO |
| memory/sql/THD::sp_cache | NO | NO |
| memory/sql/sp_head::main_mem_root | NO | NO |
| memory/sql/sp_head::execute_mem_root | NO | NO |
| memory/sql/sp_head::call_mem_root | NO | NO |
| memory/sql/table_mapping::m_mem_root | NO | NO |
| memory/sql/QUICK_RANGE_SELECT::alloc | NO | NO |
| memory/sql/QUICK_INDEX_MERGE_SELECT::alloc | NO | NO |
| memory/sql/QUICK_ROR_INTERSECT_SELECT::alloc | NO | NO |
| memory/sql/QUICK_ROR_UNION_SELECT::alloc | NO | NO |
| memory/sql/QUICK_GROUP_MIN_MAX_SELECT::alloc | NO | NO |
| memory/sql/test_quick_select | NO | NO |
| memory/sql/prune_partitions::exec | NO | NO |
| memory/sql/MYSQL_BIN_LOG::recover | NO | NO |
| memory/sql/Blob_mem_storage::storage | NO | NO |
| memory/sql/NAMED_ILINK::name | NO | NO |
| memory/sql/String::value | NO | NO |
| memory/sql/Sys_var_charptr::value | NO | NO |
| memory/sql/Queue::queue_item | NO | NO |
| memory/sql/THD::db | NO | NO |
| memory/sql/user_var_entry | NO | NO |
| memory/sql/Slave_job_group::group_relay_log_name | NO | NO |
| memory/sql/Relay_log_info::group_relay_log_name | NO | NO |
| memory/sql/binlog_cache_mngr | NO | NO |
| memory/sql/Row_data_memory::memory | NO | NO |
| memory/sql/Gtid_set::to_string | NO | NO |
| memory/sql/Gtid_state::to_string | NO | NO |
| memory/sql/Owned_gtids::to_string | NO | NO |
| memory/sql/Log_event | NO | NO |
| memory/sql/Incident_log_event::message | NO | NO |
| memory/sql/Rows_query_log_event::rows_query | NO | NO |
| memory/sql/Sort_param::tmp_buffer | NO | NO |
| memory/sql/Filesort_info::merge | NO | NO |
| memory/sql/Filesort_info::record_pointers | NO | NO |
| memory/sql/Filesort_buffer::sort_keys | NO | NO |
| memory/sql/handler::errmsgs | NO | NO |
| memory/sql/handlerton | NO | NO |
| memory/sql/XID | NO | NO |
| memory/sql/host_cache::hostname | NO | NO |
| memory/sql/user_var_entry::value | NO | NO |
| memory/sql/User_level_lock | NO | NO |
| memory/sql/MYSQL_LOG::name | NO | NO |
| memory/sql/TC_LOG_MMAP::pages | NO | NO |
| memory/sql/my_bitmap_map | NO | NO |
| memory/sql/QUICK_RANGE_SELECT::mrr_buf_desc | NO | NO |
| memory/sql/Event_queue_element_for_exec::names | NO | NO |
| memory/sql/my_str_malloc | NO | NO |
| memory/sql/MYSQL_BIN_LOG::basename | NO | NO |
| memory/sql/MYSQL_BIN_LOG::index | NO | NO |
| memory/sql/MYSQL_RELAY_LOG::basename | NO | NO |
| memory/sql/MYSQL_RELAY_LOG::index | NO | NO |
| memory/sql/rpl_filter memory | NO | NO |
| memory/sql/errmsgs | NO | NO |
| memory/sql/Gis_read_stream::err_msg | NO | NO |
| memory/sql/Geometry::ptr_and_wkb_data | NO | NO |
| memory/sql/MYSQL_LOCK | NO | NO |
| memory/sql/NET::buff | NO | NO |
| memory/sql/NET::compress_packet | NO | NO |
| memory/sql/Event_scheduler::scheduler_param | NO | NO |
| memory/sql/Gtid_set::Interval_chunk | NO | NO |
| memory/sql/Owned_gtids::sidno_to_hash | NO | NO |
| memory/sql/Sid_map::Node | NO | NO |
| memory/sql/Gtid_state::group_commit_sidno_locks | NO | NO |
| memory/sql/Mutex_cond_array::Mutex_cond | NO | NO |
| memory/sql/TABLE_RULE_ENT | NO | NO |
| memory/sql/Rpl_info_table | NO | NO |
| memory/sql/Rpl_info_file::buffer | NO | NO |
| memory/sql/db_worker_hash_entry | NO | NO |
| memory/sql/rpl_slave::check_temp_dir | NO | NO |
| memory/sql/rpl_slave::command_buffer | NO | NO |
| memory/sql/binlog_ver_1_event | NO | NO |
| memory/sql/SLAVE_INFO | NO | NO |
| memory/sql/binlog_pos | NO | NO |
| memory/sql/HASH_ROW_ENTRY | NO | NO |
| memory/sql/binlog_statement_buffer | NO | NO |
| memory/sql/partition_syntax_buffer | NO | NO |
| memory/sql/READ_INFO | NO | NO |
| memory/sql/JOIN_CACHE | NO | NO |
| memory/sql/TABLE::sort_io_cache | NO | NO |
| memory/sql/frm | NO | NO |
| memory/sql/Unique::sort_buffer | NO | NO |
| memory/sql/Unique::merge_buffer | NO | NO |
| memory/sql/TABLE | NO | NO |
| memory/sql/frm::extra_segment_buff | NO | NO |
| memory/sql/frm::form_pos | NO | NO |
| memory/sql/frm::string | NO | NO |
| memory/sql/LOG_name | NO | NO |
| memory/sql/DATE_TIME_FORMAT | NO | NO |
| memory/sql/DDL_LOG_MEMORY_ENTRY | NO | NO |
| memory/sql/ST_SCHEMA_TABLE | NO | NO |
| memory/sql/ignored_db | NO | NO |
| memory/sql/PROFILE | NO | NO |
| memory/sql/global_system_variables | NO | NO |
| memory/sql/THD::variables | NO | NO |
| memory/sql/Security_context | NO | NO |
| memory/sql/Shared_memory_name | NO | NO |
| memory/sql/bison_stack | NO | NO |
| memory/sql/THD::handler_tables_hash | NO | NO |
| memory/sql/hash_index_key_buffer | NO | NO |
| memory/sql/dboptions_hash | NO | NO |
| memory/sql/user_conn | NO | NO |
| memory/sql/LOG_POS_COORD | NO | NO |
| memory/sql/XID_STATE | NO | NO |
| memory/sql/MPVIO_EXT::auth_info | NO | NO |
| memory/sql/opt_bin_logname | NO | NO |
| memory/sql/Query_cache | NO | NO |
| memory/sql/READ_RECORD_cache | NO | NO |
| memory/sql/Quick_ranges | NO | NO |
| memory/sql/File_query_log::name | NO | NO |
| memory/sql/Table_trigger_dispatcher::m_mem_root | NO | NO |
| memory/sql/thd_timer | NO | NO |
| memory/sql/THD::Session_tracker | NO | NO |
| memory/sql/THD::Session_sysvar_resource_manager | NO | NO |
| memory/sql/show_slave_status_io_gtid_set | NO | NO |
| memory/sql/write_set_extraction | NO | NO |
| memory/sql/get_all_tables | NO | NO |
| memory/sql/fill_schema_schemata | NO | NO |
| memory/sql/native_functions | NO | NO |
| memory/sql/JSON | NO | NO |
| memory/client/mysql_options | NO | NO |
| memory/client/MYSQL_DATA | NO | NO |
| memory/client/MYSQL | NO | NO |
| memory/client/MYSQL_RES | NO | NO |
| memory/client/MYSQL_ROW | NO | NO |
| memory/client/MYSQL_STATE_CHANGE_INFO | NO | NO |
| memory/client/MYSQL_HANDSHAKE | NO | NO |
| memory/vio/ssl_fd | NO | NO |
| memory/vio/vio | NO | NO |
| memory/vio/read_buffer | NO | NO |
| memory/mysys/max_alloca | NO | NO |
| memory/mysys/charset_file | NO | NO |
| memory/mysys/charset_loader | NO | NO |
| memory/mysys/lf_node | NO | NO |
| memory/mysys/lf_dynarray | NO | NO |
| memory/mysys/lf_slist | NO | NO |
| memory/mysys/LIST | NO | NO |
| memory/mysys/IO_CACHE | NO | NO |
| memory/mysys/KEY_CACHE | NO | NO |
| memory/mysys/SAFE_HASH_ENTRY | NO | NO |
| memory/mysys/MY_TMPDIR::full_list | NO | NO |
| memory/mysys/MY_BITMAP::bitmap | NO | NO |
| memory/mysys/my_compress_alloc | NO | NO |
| memory/mysys/pack_frm | NO | NO |
| memory/mysys/my_err_head | NO | NO |
| memory/mysys/my_file_info | NO | NO |
| memory/mysys/MY_DIR | NO | NO |
| memory/mysys/MY_STAT | NO | NO |
| memory/mysys/QUEUE | NO | NO |
| memory/mysys/DYNAMIC_STRING | NO | NO |
| memory/mysys/TREE | NO | NO |
| memory/sql/Event_basic::mem_root | NO | NO |
| memory/sql/root | NO | NO |
| memory/sql/load_env_plugins | NO | NO |
| memory/sql/MDL_context::acquire_locks | NO | NO |
| memory/sql/Partition_share | NO | NO |
| memory/sql/partition_sort_buffer | NO | NO |
| memory/sql/Partition_admin | NO | NO |
| memory/sql/plugin_mem_root | NO | NO |
| memory/sql/plugin_init_tmp | NO | NO |
| memory/sql/plugin_int_mem_root | NO | NO |
| memory/sql/mysql_plugin_dl | NO | NO |
| memory/sql/mysql_plugin | NO | NO |
| memory/sql/plugin_bookmark | NO | NO |
| memory/csv/TINA_SHARE | NO | NO |
| memory/csv/blobroot | NO | NO |
| memory/csv/tina_set | NO | NO |
| memory/csv/row | NO | NO |
| memory/csv/Transparent_file | NO | NO |
| memory/myisam/MYISAM_SHARE | NO | NO |
| memory/myisam/MI_INFO | NO | NO |
| memory/myisam/MI_INFO::ft1_to_ft2 | NO | NO |
| memory/myisam/MI_INFO::bulk_insert | NO | NO |
| memory/myisam/record_buffer | NO | NO |
| memory/myisam/FTB | NO | NO |
| memory/myisam/FT_INFO | NO | NO |
| memory/myisam/FTPARSER_PARAM | NO | NO |
| memory/myisam/ft_memroot | NO | NO |
| memory/myisam/ft_stopwords | NO | NO |
| memory/myisam/MI_SORT_PARAM | NO | NO |
| memory/myisam/MI_SORT_PARAM::wordroot | NO | NO |
| memory/myisam/SORT_FT_BUF | NO | NO |
| memory/myisam/SORT_KEY_BLOCKS | NO | NO |
| memory/myisam/filecopy | NO | NO |
| memory/myisam/SORT_INFO::buffer | NO | NO |
| memory/myisam/MI_DECODE_TREE | NO | NO |
| memory/myisam/MYISAM_SHARE::decode_tables | NO | NO |
| memory/myisam/preload_buffer | NO | NO |
| memory/myisam/stPageList::pages | NO | NO |
| memory/myisam/keycache_thread_var | NO | NO |
| memory/innodb/adaptive hash index | NO | NO |
| memory/innodb/buf_buf_pool | NO | NO |
| memory/innodb/dict_stats_bg_recalc_pool_t | NO | NO |
| memory/innodb/dict_stats_index_map_t | NO | NO |
| memory/innodb/dict_stats_n_diff_on_level | NO | NO |
| memory/innodb/other | NO | NO |
| memory/innodb/row_log_buf | NO | NO |
| memory/innodb/row_merge_sort | NO | NO |
| memory/innodb/std | NO | NO |
| memory/innodb/trx_sys_t::rw_trx_ids | NO | NO |
| memory/innodb/partitioning | NO | NO |
| memory/innodb/api0api | NO | NO |
| memory/innodb/btr0btr | NO | NO |
| memory/innodb/btr0bulk | NO | NO |
| memory/innodb/btr0cur | NO | NO |
| memory/innodb/btr0pcur | NO | NO |
| memory/innodb/btr0sea | NO | NO |
| memory/innodb/buf0buf | NO | NO |
| memory/innodb/buf0dblwr | NO | NO |
| memory/innodb/buf0dump | NO | NO |
| memory/innodb/buf0flu | NO | NO |
| memory/innodb/buf0lru | NO | NO |
| memory/innodb/dict0dict | NO | NO |
| memory/innodb/dict0mem | NO | NO |
| memory/innodb/dict0stats | NO | NO |
| memory/innodb/dict0stats_bg | NO | NO |
| memory/innodb/eval0eval | NO | NO |
| memory/innodb/fil0fil | NO | NO |
| memory/innodb/fsp0file | NO | NO |
| memory/innodb/fsp0space | NO | NO |
| memory/innodb/fsp0sysspace | NO | NO |
| memory/innodb/fts0ast | NO | NO |
| memory/innodb/fts0config | NO | NO |
| memory/innodb/fts0fts | NO | NO |
| memory/innodb/fts0opt | NO | NO |
| memory/innodb/fts0pars | NO | NO |
| memory/innodb/fts0que | NO | NO |
| memory/innodb/fts0sql | NO | NO |
| memory/innodb/gis0sea | NO | NO |
| memory/innodb/ha0ha | NO | NO |
| memory/innodb/ha_innodb | NO | NO |
| memory/innodb/handler0alter | NO | NO |
| memory/innodb/hash0hash | NO | NO |
| memory/innodb/i_s | NO | NO |
| memory/innodb/ibuf0ibuf | NO | NO |
| memory/innodb/lexyy | NO | NO |
| memory/innodb/lock0lock | NO | NO |
| memory/innodb/log0log | NO | NO |
| memory/innodb/log0recv | NO | NO |
| memory/innodb/mem0mem | NO | NO |
| memory/innodb/os0event | NO | NO |
| memory/innodb/os0file | NO | NO |
| memory/innodb/page0cur | NO | NO |
| memory/innodb/page0zip | NO | NO |
| memory/innodb/pars0lex | NO | NO |
| memory/innodb/read0read | NO | NO |
| memory/innodb/rem0rec | NO | NO |
| memory/innodb/row0ftsort | NO | NO |
| memory/innodb/row0import | NO | NO |
| memory/innodb/row0log | NO | NO |
| memory/innodb/row0merge | NO | NO |
| memory/innodb/row0mysql | NO | NO |
| memory/innodb/row0sel | NO | NO |
| memory/innodb/row0trunc | NO | NO |
| memory/innodb/srv0conc | NO | NO |
| memory/innodb/srv0srv | NO | NO |
| memory/innodb/srv0start | NO | NO |
| memory/innodb/sync0arr | NO | NO |
| memory/innodb/sync0debug | NO | NO |
| memory/innodb/sync0rw | NO | NO |
| memory/innodb/sync0types | NO | NO |
| memory/innodb/trx0i_s | NO | NO |
| memory/innodb/trx0purge | NO | NO |
| memory/innodb/trx0roll | NO | NO |
| memory/innodb/trx0rseg | NO | NO |
| memory/innodb/trx0sys | NO | NO |
| memory/innodb/trx0trx | NO | NO |
| memory/innodb/trx0undo | NO | NO |
| memory/innodb/usr0sess | NO | NO |
| memory/innodb/ut0list | NO | NO |
| memory/innodb/ut0mem | NO | NO |
| memory/innodb/ut0mutex | NO | NO |
| memory/innodb/ut0pool | NO | NO |
| memory/innodb/ut0rbt | NO | NO |
| memory/innodb/ut0wqueue | NO | NO |
| memory/memory/HP_SHARE | NO | NO |
| memory/memory/HP_INFO | NO | NO |
| memory/memory/HP_PTRS | NO | NO |
| memory/memory/HP_KEYDEF | NO | NO |
| memory/myisammrg/MYRG_INFO | NO | NO |
| memory/myisammrg/children | NO | NO |
| memory/federated/FEDERATED_SHARE | NO | NO |
| memory/archive/FRM | NO | NO |
| memory/archive/record_buffer | NO | NO |
| memory/blackhole/blackhole_share | NO | NO |
| memory/partition/ha_partition::file | NO | NO |
| memory/partition/ha_partition::engine_array | NO | NO |
| memory/partition/ha_partition::part_ids | NO | NO |
| memory/sql/tz_storage | NO | NO |
| memory/sql/servers_cache | NO | NO |
| memory/sql/udf_mem | NO | NO |
+--------------------------------------------------------------------------------+---------+-------+
377 rows in set (0.05 sec)
Raw
gistfile2.txt
SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/innodb/buf_buf_pool';
+----------------------------+-------------+------------+---------------------------+--------------------------+----------------+--------------------+-----------------+--------------------------+------------------------------+---------------------------+
| EVENT_NAME | COUNT_ALLOC | COUNT_FREE | SUM_NUMBER_OF_BYTES_ALLOC | SUM_NUMBER_OF_BYTES_FREE | LOW_COUNT_USED | CURRENT_COUNT_USED | HIGH_COUNT_USED | LOW_NUMBER_OF_BYTES_USED | CURRENT_NUMBER_OF_BYTES_USED | HIGH_NUMBER_OF_BYTES_USED |
+----------------------------+-------------+------------+---------------------------+--------------------------+----------------+--------------------+-----------------+--------------------------+------------------------------+---------------------------+
| memory/innodb/buf_buf_pool | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+----------------------------+-------------+------------+---------------------------+--------------------------+----------------+--------------------+-----------------+--------------------------+------------------------------+---------------------------+
1 row in set (0.03 sec)
Raw
gistfile3.txt
First of all be sure what you want to select and erase the '*'
Select * from
with something more specific
Select id, name, ....
There is no Join or anything other in your table so the speed up options are quite small I think.
Check that your mysql Server can use enough memory. Have a look at this confis in your my.cnf
key_buffer_size = 384M;
myisam_sort_buffer_size = 64M;
thread_cache_size = 8;
query_cache_size = 64M
Have a look a max allowed concurrency. mysql recommends CPU's*2
thread_concurrency = 4
You should really thinks about splitting the table depending on informations you use and on standard normalization. If possible.
If it's a productive system with no way to split the tables then think about a caching server. But this will only help if you have a lot of recurring querys that are the same.
This is what I would do when knowing nothing about the underlying implementation or the system at all.
Edit: Making as many columns indexable as you can won't necessarily speed up your system. The more indexes ≠ the more speed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment