… 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… the table sizes and an easy way to use the search feature of your browser to zero in on a particular…
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… memcached plugin included in the base plugin directory (/usr/lib64/mysql/plugin/libmemcached.so) that can be stopped and started at… nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort…
Comment: Webinar: MySQL 5.6 Performance Schema
May 16, 2013 By 5 Comments
… a copy of the slides to reference/search in directly while trying out the MySQL Performance Schema tool myself. Thanks for your…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 30, 2013 By 10 Comments
According to http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-internals.html … case, if memcached cannot find a key in memory, it searches for the value in an InnoDB table.” I’d like…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…_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…_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: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…, only the documents included in the Sphinx Search indexes will be returned by Sphinx Search queries. Mike W. also asked: Q: What… 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: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 8 Comments
… performance. Solution for this problem was to use set optimizer_search_depth=0, rarely used option which as per manual will… in MySQL mailing list archives I have some recollection that there were few main reasons for the decision to keep exhaustive search… from optimal plans do we get by using a greedy search. From the same discussion we can learn how automatic selection…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full Text Search project was started over 6 years ago, in addition with many optimizer and replication features. We’re happy to congratulate MySQL… Oracle MySQL, MySQL 5.6 is fully supported by our MySQL Consulting, MySQL Support, MySQL Server Development, and MySQL Remote DBA teams: Our MySQL Consulting Team and MySQL…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary… when using a CMS where DB structure is prepdefined A: MySQL Server will not automatically define any indexes for you. Hopefully… index, also you only can have equality comparison as a search condition WHERE A=5 ORDER BY B will use index…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… a cadre of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the future, and… on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, Big…
