Percona's MySQL & InnoDB performance and scalability blog
…column name=”id” primaryKey=”true”> column> <column name=”parent_id”>
…versions of MySQL. Q: How do the upcoming changes in MySQL 5.6 change the best practices for index…by the same column as its sort column. You can optimize by adding the grouping column to your index…scope of the search, the index search will be even more efficient than if you were searching for the …
… index before declaring the `FTS_DOC_ID` primary key column properly, MySQL crashed with an out of memory fatal error, and the… total for the search expression. But I don’t know a way to report exactly which rows matched, without doing additional searches for each… customization on the search algorithm. It would have taken me two to three weeks to do something equivalent with MySQL and it…
… comparison as a search condition WHERE A=5 ORDER BY B will use index (A,B) for sorting optimization, for more complicated conditions…: how mysql use index for group by? A: If you have Index on the column MySQL can avoid temporary table or filesort for group by by this column. This works because by scanning data in index order MySQL…
…an *InnoDB* table with a single VARCHAR column named “value”. OK, sounds easy enough: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** …solved the Boolean-mode search issue, but we still have vastly different results with the natural-language-mode search. For those of you…
… The example settings file should work for most MySQL installations which allow connections as root …default config filename to search for. I included it in the earlier examples for illustration purposes. …three additional metadata columns: dml_type, uow_id and fv$server_id. These columns represent …
… with MySQL – it is implementation of the wire protocol from scratch. For this test I was not interesting in the full text search performance, we already know Sphinx is much faster than MySQL build… sec) As you can see Sphinx adds couple of extra columns to result set even if you have not asked it…
…post reviews. Box Anemometer Anemometer is a tool for visualizing collected data from the MySQL Slow Query Log. The name comes … choosing which columns to show; * filtering queries by hosts; * filtering reports by different query conditions; * graphing reports; * explaining queries; * searching and …
… logical volumes – mysql-data for my datadir, and mysql-logs for my binary logs. I also have the latest snapshot of the mysql-data logical….15 sec) mysql> drop table salaries; — Ooops! Query OK, 0 rows affected (0.49 sec) mysql> alter table employees add column age smallint…_Do_DB Binlog_Ignore_DB mysql-bin.000022 336796712 Using the coordinates above, I can start searching for the position of the DELETE…
… database tables where you can add a where clause and search individual columns, and a ton more “database options” beyond just… then combining memcached and MySQL, and about 20% slower then the all memory memcached approach. So for this particular application I… better off not storing my data in MySQL and instead looking outside the database for an answer. Now sure there are…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.