FedericoRazzoli

5 ms·

1.
Hints to optimise SQL queries with LIKE(vettabase.com)
1 points by FedericoRazzoli 4y ago|1 comments
2.
by FedericoRazzoli 4y ago
I wrote some hints on how to optimise #SQL queries containing LIKE. More ideas, including unconventional ones, are very welcome - just comment here or on the website.
3.
MariaDB 10.8: A Review(vettabase.com)
2 points by FedericoRazzoli 4y ago|0 comments
4.
How to test database backups(vettabase.com)
3 points by FedericoRazzoli 5y ago|0 comments
5.
How Slow Is Select *?(vettabase.com)
39 points by FedericoRazzoli 5y ago|25 comments
6.
Are RIGHT JOINs ever necessary?(sql-bits.com)
7 points by FedericoRazzoli 5y ago|0 comments
7.
by FedericoRazzoli 5y ago
This is a great explanation! I wonder many times why we had to play with obscure xargs instead of being able to pipe a command output to an argument.
8.
by FedericoRazzoli 5y ago
The problem, though, is that SQL standard treats NULL as unknown or as missing. One word for two meanings. For example, AVG(col) and COUNT(col) treat it as a missing value (NULLs do not alter the average or the count), but 1 + NULL treats i
9.
by FedericoRazzoli 5y ago
You are right, though (some?) DBMSs allow to use HAVING for columns that appear in the GROUP BY clause.
10.
by FedericoRazzoli 5y ago
You are correct, HAVING is essentially syntax sugar. But to be fair, I'm glad it exists.
11.
SQL: The difference between WHERE and HAVING(sql-bits.com)
117 points by FedericoRazzoli 5y ago|132 comments
12.
MariaDB Ignored Indexes(vettabase.com)
2 points by FedericoRazzoli 5y ago|0 comments
13.
Basic practices for optimizing read and write performance in PostgreSQL(vettabase.com)
3 points by FedericoRazzoli 6y ago|0 comments
14.
Is InnoDB Buffer Pool big enough?(vettabase.com)
1 points by FedericoRazzoli 6y ago|0 comments
15.
CentOS Linux Alternatives(vettabase.com)
1 points by FedericoRazzoli 6y ago|0 comments
16.
CentOS Alternatives: Rocky, Lenix and Oracle Linux(theregister.com)
2 points by FedericoRazzoli 6y ago|0 comments
17.
Creating dynamic configuration files with Ansible(vettabase.com)
1 points by FedericoRazzoli 6y ago|0 comments
18.
Ensuring Data Reaches Disk(lwn.net)
2 points by FedericoRazzoli 6y ago|0 comments
19.
Running Ansible inside a dedicated host(vettabase.com)
1 points by FedericoRazzoli 6y ago|0 comments
20.
Logging All MariaDB and MySQL Queries into the Slow Log(vettabase.com)
2 points by FedericoRazzoli 6y ago|0 comments
21.
Minimizing read-write MySQL downtime(engineeringblog.yelp.com)
1 points by FedericoRazzoli 6y ago|0 comments
22.
Benefits of Infrastructure as Code(vettabase.com)
2 points by FedericoRazzoli 6y ago|0 comments
23.
Stored Procedures Instrumentation in MariaDB 10.5(mysqlentomologist.blogspot.com)
2 points by FedericoRazzoli 6y ago|0 comments
24.
by FedericoRazzoli 6y ago
Still work in progress and the topics are not too in-depth... but it's interesting, thanks.
25.
by FedericoRazzoli 6y ago
Fantastic videos! Thanks for the links! Yes, Kubernetes uses cgroup too. Systemd units are also based on cgroups.
26.
A Linux sysadmin's introduction to cgroups(redhat.com)
343 points by FedericoRazzoli 6y ago|69 comments
27.
Cassandra 4.0-Beta3 Released(gitbox.apache.org)
2 points by FedericoRazzoli 6y ago|0 comments
28.
The risks of MySQL release policy(vettabase.com)
1 points by FedericoRazzoli 6y ago|0 comments