… Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema CREATE TABLE… the table sizes and an easy way to use the search feature of your browser to zero in on a particular table Constraints…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… objects. Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc) Full page output (relatively… nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort… per/cmd 0.0951 ms range per/cmd InnoDB MySQL Select (same table): Fetching [1,000,000] items: 441573 ms total 0…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 30, 2013 By 10 Comments
…://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-internals.html there are some caching settings to play with: “Table cache… cannot find a key in memory, it searches for the value in an InnoDB table.” I’d like to see the results…
Post: The case for getting rid of duplicate “sets”
May 17, 2011 By 2 Comments
… “search set” table: CREATE TABLE `search_set` ( `val` bigint(20) DEFAULT NULL, `cnt` bigint(20) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; mysql> insert into search… “search set” trick above. Also, notice that it takes a long time to delete. There is no index on this table. mysql> delete…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 8 Comments
… in MySQL mailing list archives I have some recollection that there were few main reasons for the decision to keep exhaustive search… works – it picks value of min(number of tables, 7) essentially limiting search depth to no more than 7 at which complexity… to get even better handling joins of many tables as optimizer heuristics are improved so much higher search depths are feasible now.
Post: BoardReader - Forum Search Engine
November 29, 2006 By 13 Comments
… “manual partitioning” scheme with different forum sites mapped to different “table groups” with each server handling bunch of these. This would… it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search forums from that domain. For example you can use this link to search our MySQL Performance Forums Second…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… improvement because you’re searching data without touching the disk, but I assume the search would necessarily do table-scans. Jessy B. also… customization on the search algorithm. It would have taken me two to three weeks to do something equivalent with MySQL and it wouldn’t be as flexible and customizable as Solr. With Solr, I was able to fine tune search…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… values distribution. The query looks something like this: SELECT * FROM table WHERE deleted = 0 AND group_id IN (62715996, 62716592, 62717660…_cur_search_to_nth_level,btr_p cur_open_with_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql…_cur_search_to_nth_level,btr_p cur_open_with_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… is a tool for visualizing collected data from the MySQL Slow Query Log. The name comes from the instrument …by different query conditions; * graphing reports; * explaining queries; * searching and displaying samples; * displaying table status and CREATE statements; * reviewing and commenting …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… of indexes you can have, which is 64 per table in recent MySQL versions. However it is often too many. Instead of… selection for the same table, not other index, also you only can have equality comparison as a search condition WHERE A=5…. Q: how mysql use index for group by? A: If you have Index on the column MySQL can avoid temporary table or filesort…
