…PERFORMANCE_SCHEMA, and paths are unique for basedir and datadir I… mysql> select * from information_schema.global_status where variable_name like ‘%innodb%read%’; …1. row ************************************************ 1. row ******* POOL_ID: 0 * POOL_ID: 0 POOL_SIZE: 8192 *…
Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!
March 4, 2013 By 7 Comments
… what comes back: mysql: SET GLOBAL innodb_ft_server_stopword_table=’…BY 3 DESC LIMIT 1; +——-+—————-+——————–+ | id | full_name | score | +——-+—————-+——————–+ | 62633 | Thomas B Smith |… although Japanese poses its own unique problems for FTS of any…
Post: mk-query-digest, query comments and the query cache
…includes important information, such as the PHP session ID, and the application user name. This allows … will become very frequent when every query is unique and the query cache will use additional …stripping in Percona Server at runtime: mysql> set global query_cache_strip_comments=’ON’; Query OK, 0…