Percona's MySQL & InnoDB performance and scalability blog
… one, which discusses improving bulk insert performance. At…mysql> set global innodb_ft_aux_table=’test/dir_test_innodb’; mysql> set global innodb_optimize_fulltext_only=1; mysql> select… | | last_optimized_word | | | deleted_doc_count | 0 | | total_word_count | | | optimize_start_time | | | optimize_…
… do not need GROUP BY results sorted – it can significantly improve performance in some cases. First I run the query with… enough memory for OS cache to keep temporary table. Results: mysql> select count(*) cnt,c from gtest group by c order by null… (0.00 sec) mysql> set tmp_table_size=1000000000; Query OK, 0 rows affected (0.00 sec) mysql> select count(*) cnt,c from gt…
…_id, db, tbl HAVING COUNT(*) > 1 ) AS qv USING(query_id, db,…mysql> select * from queries where query_id = 7675136724153707161\G *************************** 1. row *************************** query_id: 7675136724153707161 fingerprint: select…things that I want to improve about the canned queries while…
… field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE …First favorite query for any database benchmarker is SELECT count(*) FROM ontime;. Both InforBritgh and MonetDB executes … or check history), the documentation also needs improvements. The fact it does not use the …
… the table into months using the FlightDate column using the improved MySQL 5.5 partitioning options which work directly on columns without… constructs. Q1 – SELECT count(*) from ontime.ontime where FlightDate between ’1988-01-01′ and ’1988-12-31′; Q2 – SELECT DayOfWeek, count(*) AS c FROM…
…, the view is accessed quicky: mysql> select c1, count(*) from v1 where c1 = 10 group by c1; +——+———-+ | c1 | count(*) | +——+———-+ | 10 | 130 | +——+———-+ 1 row in… to make a trade off between increased query complexity for improved view performance.
…`) ); select count(*) from longf; +———-+ | count(*) | +———-+ | 5242880 | +———-+ And simple PHP script which retrieves all rows from the table: < ?php $link = mysql…our script with mysql_unbuffered_query instead of mysql_query. execution time: 54.34 s Good improvement. The identical…
… in MySQL 5.6 code? As MRR was used in both MySQL 5.6 and MariaDB 5.5. Handler_mrr_rowid_refills counts… in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area of improvement in the optimizer, as it is clearly a part of the optimizer’s job to select the best…
… that can improve performance significantly….patch | InnoDB patch to control count of IO threads | 1.0 |… granularity. mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; +—-+——+———–+——+———+——+———–+———————————————-+———+ | ID |…
…instead of actually running the query.. This improves the response time by avoiding the work…last populated. MySQL includes two statements that make this easier: CREATE TABLE .. SELECT and INSERT .. SELECT. These…are deleted. When this happens, decreasing the counts in summary tables may not be …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.