Skip to content

Vettabase

Watch your data from the top of a mountain. We take care of the machinery.

Menu

Primary menu

  • Services
    • Database Automation
    • Health Checks
      • MariaDB
      • MySQL
      • Cassandra
      • PostgreSQL
    • Monthly Time
    • Training
      • MariaDB
      • MySQL
      • Analysts Training
    • Upgrades and Migrations
      • Database Upgrades
      • Migration from CentOS
  • Articles
    • Vettabase
    • Automation
    • MariaDB
    • MySQL
    • PostgreSQL
  • Careers
  • About
    • Testimonials
    • On the Web
    • Contact Us

Category Archives: MySQL


MySQL is the most widely used DBMS for OLTP workloads. Here we share hints and insights on its features, optimisations and internals.

This section covers both MySQL and Percona Server. For MariaDB insights, see the MariaDB category.

Can we shrink InnoDB Buffer Pool?

Posted on 21 January 2021 by Federico Razzoli — No Comments ↓

An oversized InnoDB buffer pool will consume too many resources and can be slower than necessary. Let’s see how to check if we can shrink it. Continue reading Can we shrink InnoDB Buffer Pool?→

Posted in MariaDB InnoDB, MySQL InnoDB | Tagged innodb-buffer-pool | Leave a reply

Is InnoDB Buffer Pool big enough?

Posted on 6 January 2021 by Federico Razzoli — 2 Comments ↓

InnoDB buffer pool is the most important memory area to allocate. It contains the most frequently read data and index entries from InnoDB tables. Let’s see how to check if it is big enough. Continue reading Is InnoDB Buffer Pool big enough?→

Posted in MariaDB InnoDB, MySQL InnoDB | Tagged innodb-buffer-pool | 2 Replies

MariaDB/MySQL IS NULL conditions and indexes

Posted on 14 November 2020 by Federico Razzoli — 2 Comments ↓

It is quite common to use an equality condition and an IS NULL condition on the same columns. Unfortunately, this could make queries very slow. Continue reading MariaDB/MySQL IS NULL conditions and indexes→

Posted in MariaDB, MySQL | Tagged null | 2 Replies

Monitoring that AUTO_INCREMENT values won’t reach the limit

Posted on 13 November 2020 by Federico Razzoli — 2 Comments ↓

AUTO_INCREMENT primary keys are useful, because they save usthe trouble to generate a unique value for every row, delegating this task to the database. But when we reach the limit we need to take some action, or we won’t be able to insert more rows. Continue reading Monitoring that AUTO_INCREMENT values won’t reach the limit→

Posted in MariaDB, MySQL | 2 Replies

MySQL/MariaDB: use SQL properly to run less queries

Posted on 29 October 2020 by Federico Razzoli — No Comments ↓

Reducing the number of queries is important with any DBMS. There are two reasons for this: reducing the latency of applications; and reducing the workload for the database servers. Continue reading MySQL/MariaDB: use SQL properly to run less queries→

Posted in MariaDB, MySQL, SQL Language | Leave a reply

The risks of MySQL release policy

Posted on 27 October 2020 by Federico Razzoli — No Comments ↓

MySQL 8.0 and 5.7 follow a new release policy that exposes users to important risks. They broke compatibility with Xtrabackup (again). Continue reading The risks of MySQL release policy→

Posted in MariaDB, MySQL | Leave a reply

READ ONLY transactions in MariaDB and MySQL

Posted on 8 October 2020 by Federico Razzoli — No Comments ↓

Transactions can be read only. This article explains what read only transactions are and why we should use them when appropriate. Continue reading READ ONLY transactions in MariaDB and MySQL→

Posted in MariaDB InnoDB, MySQL InnoDB | Tagged MariaDB-10.0, MySQL-5.6 | Leave a reply

Dropping database objects in a safe way

Posted on 28 August 2020 by Federico Razzoli — 3 Comments ↓

Running DROP statements in production is always dangerous. But there are some measures we can take to make them safer. Continue reading Dropping database objects in a safe way→

Posted in MariaDB, MySQL | 3 Replies

Why Tables need a Primary Key in MariaDB and MySQL

Posted on 10 August 2020 by Federico Razzoli — 3 Comments ↓

In MariaDB and MySQL, all tables should have a primary key – especially InnoDB tables. Here’s why. Continue reading Why Tables need a Primary Key in MariaDB and MySQL→

Posted in MariaDB InnoDB, MySQL InnoDB | 3 Replies

MariaDB/MySQL: Using views to grant or deny row-level privileges

Posted on 7 August 2020 by Federico Razzoli — 4 Comments ↓
A view of the Isle of Skye, Scotland

It is possible to prevent some users from seeing a set of rows in a certain table. Continue reading MariaDB/MySQL: Using views to grant or deny row-level privileges→

Posted in MariaDB, MySQL | 4 Replies

Primary Sidebar Widget Area


en_GB English

en_GB English


it_IT Italian

Vettabase Ltd logo

Recent Posts

  • Can we shrink InnoDB Buffer Pool?
  • Is InnoDB Buffer Pool big enough?
  • CentOS Linux alternatives
  • Creating dynamic configuration files with Ansible
  • Running Ansible inside a dedicated host

Categories

  • Amazon Redshift
  • Database Automation
  • Databases
  • MariaDB
  • MariaDB InnoDB
  • MySQL
  • MySQL InnoDB
  • PostgreSQL
  • SQL Language
  • Stored Procedures
  • Systems
  • Vettabase

Services

Check how Vettabase can maximise the efficiency and reliability of your database infrastructure!

  • Health Checks
  • Monthly Time
  • Training
  • Facebook
  • Twitter
  • Linkedin
  • RSS Feed
  • Instagram
  • Email
Copyright © 2021 Vettabase. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking "Accept", you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, 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 have an effect on 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.