… for next year’s event: April 22-25, 2013. The dates are confirmed and final, and this is not a “maybe… momentum, and we had to work with the space and dates that were available. In 2013 we have none of those… a kind offer from Box, we are creating a custom site to host the speaker slides in a central repository so…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
… I do SELECT * FROM sites ORDER BY date_created DESC LIMIT 10; I would use index on (date_created) to get result set… SELECT * FROM sites WHERE category_id=5 ORDER BY date_created DESC LIMIT 10; In this case index by date_created may also… columns, with worse then perfect selectivity. Various social networking and dating sites are perfect example of such queries SELECT FROM people where…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
Hi. We have a really fantastics dating site serving 8000 logged in users. However the service goes down …’ ‘Com_prepare_sql’, ’0′ ‘Com_purge’, ’0′ ‘Com_purge_before_date‘, ’0′ ‘Com_rename_table’, ’0′ ‘Com_repair’, ’0′ ‘Com_replace…
Comment: How to find wrong indexing with glance view
August 22, 2008 By 27 Comments
Nacho, For cases like you mentioned – Dating site search I would rather go with Sphinx all together. It …
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
… counting number of links (and number number of distinct forum sites) pointing to the given URL or graphs showing number of… of data. You might point out if we had link_date between X and Y and link like “prefix%” kind of… decided to use Sphinx for other part of the web site – Forum Site Profile. This uses some pre-generated data such as…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
We have a lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and… with this: create table ads_by_day_by_blueness ( day date not null, ad int unsigned not null, is_blue tinyint…’s width: create table ads_by_day_by_blueness ( day date not null, ad int unsigned not null, clicks int unsigned…
Comment: MyISAM concurrent insert
August 23, 2011 By 12 Comments
… much with this setting, or ever actually, but the stock site I manage is about 170 gig on drive, daily does… ID,Date, and indexed Date, with the Select statements always: Select from table where ID = ###### Order by Date with sometimes AND Date >= 20100101 and Date <= 20110101 (for ranges of between specific dates)
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…(‘html’,'video’,'mp3′,’image’,'pdf’,'other’) NOT NULL, `message_day` date NOT NULL, `mod_is` tinyint(3) unsigned NOT NULL default…`,`from_site_id`,`message_published`), KEY `revert_domain` (`revert_domain`,`url_prefix`(80)), KEY `from_site_id` (`from_site_id`,`message_published`), KEY `site_message` (`from_site_id`,`message_day`,`isexternal`), KEY `from…
Comment: MySQL Partitioning - can save you or kill you
November 17, 2011 By 14 Comments
…, I have a couple of tables on a high transaction site (4000 queries per second), that are in excess of 50m… schema together. The idea was/is to partition on date ( To_day(date field)), so we can access the latest quickly , and… , which doesn’t fall in line with the date syntax . Adding in the date field as the primary key would negate the…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
… is currently in beta according to release info on the site) was released just 2-3 days ago. My previous observations… common words along with -b -l 200 –sort=date (in boolean mode sorting by date descending returning top 200 matches): — PROFILE — root… most common words along with only -l 200 –sort=date (sorting by date descending (equal to my previous benchmark when there were…
