• Home
  • Back to “freeideas.cz”
mySQL small notes
  • Home
  • Back to “freeideas.cz”
Select Page

  • Ansible
    • Create new MySQL database with predefined collation and encoding
    • Ansible – install Prometheus mysql-exporter on remote instance
    • Install latest MySQL 5.7 on remote instance using ansible
  • Backup + Restoration
    • Bash script – restore non-replica from data files backuped with Percona XtraBackup
    • Bash script: create backup with Percona XtraBackup
    • Clone database with Percona xtrabackup
  • Data manipulations
    • Load data from text file – using command LOAD DATA INFILE
  • Database design
    • How to change data type of column used in foreign key
    • Tiny fun with TINYINT data type
    • Partitioning
    • String types
  • Global Status
    • Global status – table open cache
    • Global status – tmp tables
  • information_schema
    • get comma separated list of columns for table
    • Show all constraints
  • Locks
    • Investigation of locks on MySQL tables
    • Locking strategies
  • mySQL on Linux
    • How to install MySQL 5.7 on Debian 9
    • Linux bash script for drop of all tables
  • Performance
    • MySQL 5.7 parameter range_optimizer_max_mem_size
    • Move MySQL data files / log files / temp directory to the different disk on Ubuntu / Debian
    • Linux hugepages and MySQL – Ubuntu / Debian
    • Experiences with high availability in MySQL cluster
    • InnoDB buffer pool
    • Query cache
    • Configuration parameters for Optimizer
    • Optimizer hints
    • Cost based optimizer / server statistics
  • Replication
    • Settings for parallel replication workers
    • Relay log read failure: Could not parse relay log event entry – binary log is corrupted
    • Setting MySQL chain replication
    • How to handle heavy changes in MySQL replication with ansible
    • Error ‘You cannot ‘ALTER’ a log table if logging is enabled’ on query. Default database: ‘mysql’. Query: ‘ALTER TABLE slow_log
    • Switch the binlog format at runtime
    • MySQL replication troubleshooting – replication error on replica
    • Experiences with tuning of MySQL 5.7 replicas
    • Create new replica by copying data and log files on OS level
    • MySQL 5.7 investigate replication lags
    • How to create new MySQL master database
    • Clone new MySQL replica on Google Compute Engine
    • How to manually set MySQL replication
    • MySQL replication troubleshooting – Lags on replicas
    • MySQL replication small cheat sheet
  • Settings
    • MySQL memory usage / settings
    • Useful settings
    • mySQL and more CPUs
    • Memory settings
  • Storage engines
    • FEDERATED engine – small notes
    • Memory
    • MyISAM
    • InnoDB
  • Transactions
    • InnoDB REDO log
    • Binary log
    • Rollback / Undo segment
    • Isolation Levels
    • Multiversion Concurrency Control
    • Transactions
  • Troubleshooting
    • How to clean or resize the ibtmp1 file in MySQL
    • Check MySQL slow log from command line
    • How to handle errcode 28 – no space left
    • What can happen when you try to use very big VARCHAR columns
    • Message “Could not increase number of max_open_files” in MySQL error log
    • Problems with remote login into MySQL caused by performance_schema tables
    • Gotchas in MySQL replication
    • Table corruption / table fragmentation
    • Full disk !
  • Useful small hints
    • Export and import existing users
    • Find size o MySQL database
    • Allow remote access to mysql database
    • kill process / session on database
  • Usefull scripts
    • Check size of tables and indexes for all storage engines
    • Dump from one machine using ssh and restore on other machine
    • Check differences in settings between master and replicas – golang program

Recent Posts

  • How to install MySQL 5.7 on Debian 9
  • Investigation of locks on MySQL tables
  • Settings for parallel replication workers
  • How to clean or resize the ibtmp1 file in MySQL
  • Check MySQL slow log from command line
  • Relay log read failure: Could not parse relay log event entry – binary log is corrupted
  • How to change data type of column used in foreign key
  • Tiny fun with TINYINT data type
  • How to handle errcode 28 – no space left
  • What can happen when you try to use very big VARCHAR columns
  • Message “Could not increase number of max_open_files” in MySQL error log
  • MySQL 5.7 parameter range_optimizer_max_mem_size
  • Setting MySQL chain replication
  • MySQL memory usage / settings
  • Problems with remote login into MySQL caused by performance_schema tables
  • How to handle heavy changes in MySQL replication with ansible
  • Error ‘You cannot ‘ALTER’ a log table if logging is enabled’ on query. Default database: ‘mysql’. Query: ‘ALTER TABLE slow_log
  • Switch the binlog format at runtime
  • Bash script – restore non-replica from data files backuped with Percona XtraBackup
  • MySQL replication troubleshooting – replication error on replica

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Home
  • Back to “freeideas.cz”
  • Facebook
  • Twitter
  • RSS

Designed by Elegant Themes | Powered by WordPress

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT