Buy Percona ServicesBuy Now!

Things you didn’t know about MySQL and Date and Time and DST

 | April 6, 2021 |  Posted In: MySQL, Open Source Databases, Tools

(based on a conversation with a colleague, and a bit of Twitter) A Conundrum A developer colleague paged me with this:

It is obviously wrong, and weirdly so. It only works for “2 year”, not with other values:

It has to be exactly 730 days (2 * 365 days, 2 years):

The […]

Read More

fork, exec, wait and exit

 | January 4, 2021 |  Posted In: DevOps, Entry Level, Information, Intermediate Level, Tools

This is the english version of a 2007 article. In de.comp.os.unix.linux.misc somebody asked: Are commands in a script executed strictly sequentially, that is, will the next command only be executed when the previous command has completed, or will the shell automatically start the next command if the system has spare capacity? Can I change the […]

Read More

Fixing Common PostgreSQL Performance Bottlenecks

 | December 4, 2020 |  Posted In: PostgreSQL

Overview In this article, I look at how poorly designed sharding systems and replication systems in PostgreSQL affect query performance in high volume situations, and how to ensure data consistency across many servers.  I also discuss how excessive vacuuming generates I/O traffic, and how connection pooling is used to improve transaction throughput by caching connections […]

Read More