June 19, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

…where even under just a moderate load on the host system, DRBD can… you can connect and run a simple query and receive a response back in …MySQL is up and running. That said, there are plenty of other MySQL and OS-level status variables…-tables and insert a few rows into an InnoDB table, but trying to…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | … the queries which cause the greatest load on …Queries can be rewritten. Indexes and data types and table structures can be changed. Queries can be broken into…

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…claims that you can speed up bulk loading into an InnoDB FT index by declaring … setting these variables, and then let’s push some additional data into the table, …mysql> insert into dir_test_innodb (full_name, details) SELECT reverse(full_name), details FROM dir_test_innodb WHERE id < 500000; Query…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Load management Techniques for MySQL

May 6, 2012 By 3 Comments

… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing… problem from happening ? The answer is easy. Throttle the side load so it does not consume too much system resources. Here… too much in this case throttling by having relatively short queries and introducing “sleeps” between them can be a good idea…

Filed Under: Insight for DBAs, MySQL

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

… the expand_fast_index_creation system variable which is OFF by default. Let’…Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO t(c) VALUES (RAND()); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO…the secondary indexes after the data is loaded.” mysqldump in Percona Server supports the …

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

April 4, 2012 By 4 Comments

… the same page multiple times into the buffer pool. So considering this…variables in case of MariaDB 5.5. You can read more about these variables here. The query…that the relevant pages were already loaded in the buffer pool. Note …status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , , , , , , , , ,

Comment: Using MyISAM in production

July 6, 2006 By 36 Comments

…query cache variables and status +——————————+———–+ | Variable_name | Value | +——————————+———–+ | have_query_cache | YES | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 524288000 | | query…

Filed Under: Insight for DBAs Tagged With: ,

Post: read_buffer_size can break your replication

June 6, 2012 By 12 Comments

… read_buffer_size and how this variable together with max_allowed_packet can break…load the 4 million rows with LOAD DATA INFILE: MasterA (test) > LOAD DATA INFILE ‘/tmp/data’ INTO TABLE t; Query… MasterB: masterB> mysqlbinlog data/mysql-bin.000004 | grep block_len #Begin_load_query: file_id: 1 block_…

Filed Under: MySQL

Post: Side load may massively impact your MySQL Performance

November 13, 2011 By 7 Comments

…MySQL interactive performance – serving simple standard web traffic is drastically impacted when some heavy queries…into changing how buffer pool is split into young and old sublists via innodb_old_blocks_pct variable…

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: ANALYZE: MyISAM vs Innodb

September 3, 2008 By 9 Comments

…mysql> insert into antest_innodb select * from antest; Query OK, 245760 rows affected (54.29 sec) Records: 245760 Duplicates: 0 Warnings: 0 mysql…

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts