Skip to content

Vettabase

Expert consulting and automation for your database infrastructure

Menu

Menu primario

  • Servizi
    • Monthly Time
    • Database Training
      • MariaDB
      • MySQL
      • Data Analysts Training
    • Health Checks
      • MariaDB
      • MySQL
      • PostgreSQL
      • Cassandra
    • Database Automation
    • Upgrade dei Database
  • Blog
    • Database Automation
    • MariaDB
    • MySQL
    • PostgreSQL
    • Cassandra
  • Resources
    • Ebooks
    • VettaArchive
  • Vettabase
    • Company updates
    • Testimonianze
    • Partners
    • Rassegna Web
    • Carriere
    • Contatti

Archivio di categoria: 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.

3.6 millions MySQL servers accessible from the web. Hints to keep yours secure

Pubblicato il 9 Giugno 2022 da Federico Razzoli — Nessun commento ↓

Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report. Continua a leggere 3.6 millions MySQL servers accessible from the web. Hints to keep yours secure→

Pubblicato in MySQL | Lascia un commento

MariaDB/MySQL: Working with MD5 or other hashes

Pubblicato il 17 Febbraio 2022 da Federico Razzoli — 2 commenti ↓

The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continua a leggere MariaDB/MySQL: Working with MD5 or other hashes→

Pubblicato in MariaDB, MySQL | 2 Risposte

MariaDB: The regexp + LIKE optimisation

Pubblicato il 27 Gennaio 2022 da Federico Razzoli — Nessun commento ↓

MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases. Continua a leggere MariaDB: The regexp + LIKE optimisation→

Pubblicato in MariaDB, MySQL | Lascia un commento

How slow is SELECT * ?

Pubblicato il 18 Settembre 2021 da Federico Razzoli — 4 commenti ↓

The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all columns are needed, they should list their names, because more columns could be created in the future. But developers find this really Continua a leggere How slow is SELECT * ?→

Pubblicato in MariaDB, MySQL, SQL Language | 4 Risposte

Identify useless queries in MariaDB/MySQL

Pubblicato il 7 Settembre 2021 da Federico Razzoli — Nessun commento ↓

Some queries always fail or never return rows. They should be eliminated to improve database performance. Continua a leggere Identify useless queries in MariaDB/MySQL→

Pubblicato in MariaDB, MySQL | Lascia un commento

NULL comparisons in MariaDB, PostgreSQL, and SQLite

Pubblicato il 6 Settembre 2021 da Federico Razzoli — Nessun commento ↓

Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem. Continua a leggere NULL comparisons in MariaDB, PostgreSQL, and SQLite→

Pubblicato in MariaDB, MySQL, Other Databases, PostgreSQL | Taggato null | Lascia un commento

Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL

Pubblicato il 8 Giugno 2021 da Federico Razzoli — Nessun commento ↓

Having many indexes in our databases comes with a cost. It is good to periodically eliminate duplicate and unused indexes. Continua a leggere Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL→

Pubblicato in MariaDB, MySQL | Taggato index | Lascia un commento

The risks of replication filters in MariaDB and MySQL

Pubblicato il 23 Aprile 2021 da Federico Razzoli — Nessun commento ↓

MariaDB/MySQL replication filters may be useful, but they come with some risks that Database Administrators should be aware of. Continua a leggere The risks of replication filters in MariaDB and MySQL→

Pubblicato in MariaDB, MySQL | Lascia un commento

Can we shrink InnoDB Buffer Pool?

Pubblicato il 21 Gennaio 2021 da Federico Razzoli — Nessun commento ↓

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. Continua a leggere Can we shrink InnoDB Buffer Pool?→

Pubblicato in MariaDB InnoDB, MySQL InnoDB | Taggato innodb-buffer-pool | Lascia un commento

Is InnoDB Buffer Pool big enough?

Pubblicato il 6 Gennaio 2021 da Federico Razzoli — 6 commenti ↓

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. Continua a leggere Is InnoDB Buffer Pool big enough?→

Pubblicato in MariaDB InnoDB, MySQL InnoDB | Taggato innodb-buffer-pool | 6 Risposte

Navigazione articoli

← Articoli più vecchi

Primary Sidebar Widget Area

it_IT Italian
it_IT Italian en_GB English
Vettabase Ltd logo

Content License

Creative Commons License
Except where otherwise noted, the content on this site is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Articoli recenti

  • Deploying an Ansible role on a Vagrant machine
  • A summary of MariaDB 10.8: key performance improvements
  • 3.6 millions MySQL servers accessible from the web. Hints to keep yours secure
  • Tuning PostgreSQL Auto-vacuum
  • How to fix git mistakes

Categorie

  • Amazon Redshift
  • Cassandra
  • Company updates
  • Database Automation
  • Databases
  • MariaDB
  • MariaDB Features
  • MariaDB InnoDB
  • MariaDB Storage Engines
  • MySQL
  • MySQL InnoDB
  • Other Databases
  • PostgreSQL
  • SQL Language
  • Stored Procedures
  • Strategy
  • Systems

Servizi

Scopri come Vettabase può massimizzare l'efficienza e l'affidabilitá dei tuoi database!

  • Health Checks
  • Monthly Time
  • Formazione
  • Facebook
  • Twitter
  • Linkedin
  • RSS Feed
  • Instagram
  • Email
Copyright © 2022 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
Cookie 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
Sempre attivato
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.
ACCETTA E SALVA