Created
March 4, 2019 08:59
-
-
Save ArtemioVegas/557abbc610980b16d5130258c65e91be to your computer and use it in GitHub Desktop.
mysql usefull commands
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SHOW GRANTS | |
SHOW GRANTS FOR CURRENT_USER; | |
-- выключить кэш для текущей сесси | |
SET SESSION query_cache_type = OFF; | |
SET SESSION query_cache_limit = 0; | |
SET SESSION query_cache_size = 0; | |
SET SESSION query_cache_type = 0; | |
SET SESSION query_cache_size = 0; | |
--- показать текущий тип кэширования | |
SHOW VARIABLES LIKE 'query_cache_type' | |
SHOW VARIABLES LIKE 'have_query_cache' | |
--- показать текущие режим | |
SHOW VARIABLES LIKE 'sql_mode' | |
CREATE UNIQUE INDEX csht_ad_zone_assoc_ad_id_zone_id ON csht_ad_zone_assoc(ad_id, zone_id); | |
CREATE INDEX csht_ad_zone_assoc_ad_id ON csht_ad_zone_assoc(ad_id); | |
CREATE INDEX csht_ad_zone_assoc_zone_id ON csht_ad_zone_assoc(zone_id); | |
---UNINSTALL | |
sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-* | |
sudo rm -rf /etc/mysql /var/lib/mysql | |
sudo rm -rf /etc/mysql | |
sudo apt-get autoremove | |
sudo apt-get autoclean | |
sudo apt-get remove --purge 'mysql-.*' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment