Rodomi pranešimai su žymėmis MySQL. Rodyti visus pranešimus
Rodomi pranešimai su žymėmis MySQL. Rodyti visus pranešimus
2023 m. lapkričio 22 d., trečiadienis

mysql top slowest queries by permormance schema

›
SELECT      schema_name,      digest_text AS query,      COUNT_STAR AS executions,      SUM_TIMER_WAIT / 1000000000000 AS total_seconds,    ...
2023 m. lapkričio 19 d., sekmadienis

mysql memory usage analysis

›
  SELECT SUBSTRING_INDEX (event_name, ' / ' , 2 ) AS        code_area, FORMAT_BYTES( SUM (current_alloc))         AS current_alloc...
2023 m. spalio 26 d., ketvirtadienis

mysql block from remote except localhost

›
sudo iptables -A INPUT -i lo -p tcp --dport 3306 -j ACCEPT sudo iptables -A INPUT -p tcp --dport 3306 -j DROP 
2022 m. kovo 28 d., pirmadienis

xtrabackup - mysql file level backup

›
 https://www.digitalocean.com/community/tutorials/how-to-create-hot-backups-of-mysql-databases-with-percona-xtrabackup-on-centos-7  https://...
2022 m. vasario 28 d., pirmadienis

large mysql db load

›
 zr more
2022 m. vasario 16 d., trečiadienis

mysql connections

›
show variables like "%max_connections%";show global status  like "%Max_used%";show status like "%thread%"; 
2022 m. vasario 15 d., antradienis

mysql memoty tuning

›
  https://www.percona.com/blog/2016/05/03/best-practices-for-configuring-optimal-mysql-memory-usage/

mysql memory calculator

›
  #!/bin/sh# you might want to add some user authentication here mysql -e "show variables; show status" | awk ' { VAR[$1]=$2...
2021 m. gruodžio 22 d., trečiadienis

mysql dump import pagreitintuvas

›
  #!/bin/bash DATA="/db.sql.gz" SIZE="$(du $DATA | awk '{ print $1 }')K" DBNAME="test" DBPASS="Ap...
2020 m. rugsėjo 16 d., trečiadienis

mysql klonavimas per cmd tam paciam serve

›
  https://stackoverflow.com/questions/675289/cloning-a-mysql-database-on-the-same-mysql-instance
2018 m. balandžio 4 d., trečiadienis

kurią mysql strategiją pasirinkti?

›
šaltinis:  https://severalnines.com/blog/mysqldump-or-percona-xtrabackup-backup-strategies-mysql-galera-cluster
2018 m. vasario 27 d., antradienis

mysql backup mysqlduml for large data

›
mysqldum lėtina tai, kad vienu metu ir skaitoma ir rašoma. Rašymą kiek sumažina jei naudojam gzip. Taip pat galima naudoti papildomai pv k...
2017 m. kovo 30 d., ketvirtadienis

mysql panasumo matavimas su levenshtein

›
The Levenshtein distance between two strings is the minimum number of operations needed to transform one string into the other, where an ope...
2017 m. vasario 10 d., penktadienis

mysql config tuning

›
https://github.com/major/MySQLTuner-perl http://www.mysqlcalculator.com/ http://www.tecmint.com/mysql-mariadb-performance-tuning-and-opt...

mysql replication

›
MHA tool - managing master/slave https://code.google.com/p/mysql-master-ha/ https://mysqlstepbystep.com/2015/06/01/mysql-high-available-wi...
2017 m. sausio 30 d., pirmadienis

UUID

›
mysql uuid() arba PHP  https://gist.github.com/dahnielson/508447/b271e314c3c3190b0e31bc7f2f4f35da3c04f91c Version 1 (date-time and MAC add...
2017 m. sausio 1 d., sekmadienis

mysql geo spatial clustering - mysql geo funkcijos

›
https://www.fromdual.com/mysql-spatial-functionality-points-of-interest-around-me https://www.percona.com/blog/2013/10/21/using-the-new-mys...

MySQL Master Slave Database Replication

›
https://support.rackspace.com/how-to/set-up-mysql-master-slave-replication/ https://plusbryan.com/mysql-replication-without-downtime http:...
2016 m. spalio 20 d., ketvirtadienis

MySQL partitioning by column

›
ALTER TABLE `products` DROP PRIMARY KEY , ADD PRIMARY KEY ( `id` , `category` ); ALTER TABLE `products` PARTITION BY KEY(category) PARTITIO...
2016 m. sausio 27 d., trečiadienis

mysql benchmarkt tool - mytop

›
yum install mytop mytop --prompt taip pat padeda sql komanda SHOW GLOBAL STATUS