…read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator…(Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator…(Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…memory table The output of a SQL query, and what we normally think of as a result set is really a virtual table…MySQL even includes a SQL statement that makes this perfectly clear: CREATE TABLE…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…t fit in memory anymore. How does …64 per table in recent MySQL versions. …creating an index in every table you create? Example: CREATE TABLE user_competition_entry user_id (INT), competition_id(INT); The table…table or external sort. Q: How can we manage indexes on servers from DBA point of view…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…memory for me from several years ago. I’ve since discovered the blog post in which I mention it: drop table…CREATE TABLE statement that took over four minutes to execute and get a more complete view…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting …000 rows. This creates a table+index data size approximately twice as big as memory, so the workload …table with 400 million rows. Here is the chart of rows inserted per minute (click on the image for a bigger view…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… also create temp tables; the same applies to views and probably some other things I’m forgetting. Let’s not forget about the memory… * 1024 * 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ | 1…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…memory…create a database and a userfor it. mysql> create database sbtest; Query OK, 1 row affected (0.01 sec) mysql…mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp-table…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… The “result set” is a SET created by the output of a relational…table from each node correspond logically to a records in a Flexviews materialized view delta table…in resources in a cluster (cpu, memory, disk, power,etc) then split … SQL, but right now only MySQL storage nodes are supported. Amdahl’…
