…. Finally your own sequences allow you to generate multiple sequence values on demand with single statement for one or more sequences, which also can… this sequence generation requires serialization, though it is short term but it may still become the bottleneck for application with high sequence use…
Comment: Stored Function to generate Sequences
May 8, 2008 By 15 Comments
[...] Stored Function to generate Sequences | MySQL Performance Blog – You could combine this with an INSERT trigger and get even more auto_increment like functionality. Tags: database mysql sequence [...]
Comment: Returning to InnoDB scalability
August 7, 2006 By 42 Comments
… =================================================== =================MySQL error log=================== 060804 20:56:56 InnoDB: Started; log sequence number 45 3475747758 060804 20:56:56 [Note] /opt/mysql… assertion: (buf_pool->flush_list).count > 0 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to… on checkpoint at InnoDB: log sequence number 45 3501426558. InnoDB: Doing recovery: scanned up to log sequence number 45 3501428038 060804 21…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
… but use certain partitioned sequences, for example you can have 256 growing sequences (with high byte used for sequence number) which will have… auto_increment and which could be used to have values generated at same point in time physically local in BTREE index…
Comment: ORDER BY ... LIMIT Performance Optimization
September 2, 2006 By 93 Comments
… approach would be to pre-create sequence of ordered values and use it. For example generate 1.000.000 of random rows… is enough to run in circles for other you can generate more rows as soon as they are used. The good…
Comment: Stored Function to generate Sequences
April 3, 2008 By 15 Comments
kL, even with a sequence generator stored in MyISAM you would not see the same number in different threads.
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… benchmarks. SysBench by default has repeatable sequence of requests, because it does not initialize random generator. If you’re doing multiple runs…
Comment: To UUID or not to UUID ?
March 14, 2007 By 28 Comments
… few key points. One. UUIDs are about as pointless as sequence generators for my goals. UUIDs don’t have to be centralized…
Comment: ORDER BY ... LIMIT Performance Optimization
September 27, 2006 By 93 Comments
… you – you can have separate pre-creaed table which has sequence of random row ID something like: id rnd 1 456… is enough for others you need to make sure you generate enough random data.
