… and others, it’s easy and familiar for me to use the example of search engine marketing. I’ll do that throughout… null, …. primary key(day, ad, is_blue) ); What can we improve here? Especially assuming that there are indexes other than the primary key, we can shrink the primary key’s width: create table ads_by_day_by_blueness ( day…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… days) Here are some more details. oprofile: 867964 15.1181 mysqld btr_cur_search_to_nth_level 792651 13.8063 mysqld btr_search…_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::index_read,handler::read_ra nge_first,handler…_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::index_read,handler::read_ra nge_first,handler…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… It may be as simple as adding few indexes and tuning MySQL Server settings. It is …good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching for them, Yahoo is also on …very chaotic – we may have work piling or days becoming idle pretty quickly. With customers it …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… they become so large it would take days to do operations on them. Idea for Heikki – it should be possible to implement… of table online. Q38: Seems that adaptive hash indexes are not used for primary key lookups or not showed up in â….00 hash searches/s, 15979.01 non-hash searches/s HT: Strange, primary key equality searches should work through the adaptive hash index! What…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
… into the following thread couple of days ago: Basically someone is using sphinx to perform search simply on attributes (date, group etc… by attributes or sort sphinx does not use indexes – indexes are only used for full text search matching, but it is still extremely fast doing data crunching. I just tested right now performing search of…
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
…. System performance optimization is what I do day to day here at Percona. Looking back at …2 extra servers for search, but that is $20k extra for the servers and $1k/month for colocation. Well, … the question is moving to better hardware, optimizing indexes or queries, tuning MySQL etc. which we …
Comment: Why MySQL could be slow with large tables ?
June 19, 2006 By 141 Comments
… access to make some statistics (sites access per day, ip address, search engine source, search queries, user text entries, …) but most of my… will help since I added indexes after I saw the problem. The index does make it very fast for one of my table… one table per user for messages instead of one big table with all the messages and two indexes (sender id, recipient id…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… which would improve performance of index accesses/index scans. For example retrieving index values first and then accessing …for OLTP applications with queries examining only few rows it is less of the problem. Data retrieval, search…would go from 5 minutes to almost 4 days if we need to do the join….
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
…. For many workloads you would like to get RAID just for the sake of BBU. As Jeremy mentioned RAID is cheap these days… direct disks. For example for BoardReader now indexing almost billion of forum posts we decided to go ahead with raw drives for search index because it… think MySQL is pretty well supported by matching hardware these days. As it does not use many CPUs and many hard…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…lock_wait_timeoutblogpercona.commanual innodb_locks_unsafe_for_binlogblogpercona.commanual innodb_log_buffer_sizeblogpercona….tablesblogpercona.commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona.commanual partitionblogpercona….
