… be down. Basically I have a problem regarding long running select query. A query runs for say 300 seconds and because… ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to the select query) also get hang up. If…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… form. Q: Doesn’t the primary key solution for random selection only work when the IDs for movies are distributed uniformly… storing another column, and reinitializing the sequence after making certain insert/update/delete operations. If you have a dataset that changes…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…,10000) // distributed by pareto distribution $C, $PAD = random_string() BEGIN INSERT INTO sbtest (id, k, c, pad) VALUES ($ID, $K, $C… `hid`,`mid` is low selectivity is not good for fast inserts, but it is suitable for range selects by `id`. However it will… on Launchpad lp:~vadim-tk/sysbench/insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… a normal table as against a partitioned table. 2. The Insert should be quicker on a partitioned table, as it will… come out of the partition, not the whole table. 3. Insert on Duplicate Key (I dont do replace… ever)… if across… am really saying is that its not only about the ‘Selects‘ and Inserts, its also about what you do with the table…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… stay in the buffer_pool.) If I recall correctly, any INSERT/DELETE/etc always opens all partitions, even before thinking about… you find otherwise.) I would argue that single-row queries (SELECT, INSERT, DELETE, UPDATE) are similar in speed between PARTITIONed or non…
Comment: MySQL Partitioning - can save you or kill you
April 25, 2013 By 45 Comments
… increase in your Selects, as you will be querying on a smaller dataset. You shoould have a faster insert as well, as… the DB finding out which ‘chunk’ to work on, then inserting or reading your data. The only area you need to…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… INSERT test? Don’t know if TokuDB handle concurrent workload as well as InnoDB 2) Can you also run benchmark on SELECT… index? I heard that TokuDB is slower than InnoDB on SELECT but it’d be interesting to see by how much.
Comment: MySQL Partitioning - can save you or kill you
April 25, 2013 By 45 Comments
Hello Peter, If i have a table with 20,000,000 rows around 50GB and if i made just simple querys like: select * from table where id = ’1549090′ Creating a partition by key(id) (30 partitions) will increase my performance for selects and inserts? Thanks
Comment: Using Flexviews - part two, change data capture
March 22, 2013 By 26 Comments
…. In my case, insert into r select null, table_name,action,now() from r; Test it with continue try, until select * from binlog…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
Andy, I used 32 concurrent threads to insert data. I plan benchmarks for SELECT, but it is later.
