Fri.Oct 12, 2018

article thumbnail

Generating Identifiers – from AUTO_INCREMENT to Sequence

Percona Community

There are a number of options for generating ID values for your tables. In this post, Alexey Mikotkin of Devart explores your choices for generating identifiers with a look at auto_increment, triggers, UUID and sequences. AUTO_INCREMENT Frequently, we happen to need to fill tables with unique identifiers. Naturally, the first example of such identifiers is PRIMARY KEY data.

40
article thumbnail

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

HammerDB

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. As with the previous guides as an Intel employee (#IAMINTEL) the examples are taken from a MySQL 8 on Linux on Intel system and the approach is the same for whatever system you are testing although some of the settings you see may be different.

article thumbnail

Stuff The Internet Says On Scalability For October 12th, 2018

High Scalability

There's good news and bad news. The bad news is I'm out sick so there's won't be a post this week. The good news? There will be that much more for next week! Bored? There are a lot of past issues of Stuff the Internet Says to keep you company.