sorted by: recent | see :
popular
Content Tagged Jay
MySQL Conference Liveblogging: MySQL Performance Under A Microscope: The Tobias And Jay Show (Wednesday 2:00PM)
- Jay Pipes, Tobias Asplund
- Finding out the number of rows that would have been returned (MyISAM and InnoDB)
- SQL_CALC_FOUND_ROWS and FOUND_ROWS()
- COUNT(*)
- MEMORY table
- if query cache is on, then it makes no difference
- if it's off
- Memory MyISAM is fastest
- FOUND_ROWS() is slightly slower than count(*)
- more in the slides that I'll add later
- quite a lot of humor, these guys are fun
- query union vs index_merge union
- SELECT … WHERE a UNION SELECT … WHERE b
vs
SELECT … WHERE a AND b - index_merge wins
- composite index vs index merge
- composite index is faster
- of course, multiple indexes are more flexible than composite index
- sort union vs composite index
- …
- unix time (int unsigned) vs datetime
- query cache disabled
- 100k rows
- now and 20 years back
- retrieval range between 50 and 365 days
- all data fits into memory
- UNIX_TIMESTAMP is worst
- DATETIME in the middle
- strtotime() fastest
- is BENCHMARK() a good simulation test?
- NOW()
- MONTH(NOW())
- MONTH('YYYY-MM-DD')
- DATE_FORMAT()
- SUBSTRING()
- all about the same if php benchmark script is used
- BENCHMARK() is very unreliable, the results vary a lot
- X in Y how many times?
- 3 different methods on mysql forge
- 2 UDFs and 1 using native functions
- query cache off
- 1K rows
- all rows have "/"
- count the number of "/"
- Marcelo's solution "COUNT_CHAR_OCCURRENCE": 4th place
- Garrett Hill's solution "countstring" (it's technically slightly wrong, because it doesn't account for multibyte characters): 2nd place
- Roland Bouman's solution using mysql functions: 1st place
- Jay's way: function in php: 3rd place
- MEMORY engine HASH index vs BTREE index
- BTREE is faster
- HASH uses less memory
- MySQL Conference Liveblogging: EXPLAIN Demystified (Tuesday 2:00PM)
- MySQL Conference Liveblogging: The Future Of MySQL (Tuesday 11:55AM)
- MySQL Conference Liveblogging: Performance Guide For MySQL Cluster (Tuesday 10:50AM)
- MySQL Conference Liveblogging: Benchmarking Tools (Wednesday 4:25PM)
- MySQL Conference: Presentation At The Kickfire Booth
Maatkit t-shirts are here
I’m at the MySQL Conference and the t-shirts I created for Maatkit have arrived. Come get yours! They are high-quality, attractive shirts you’ll be proud to wear, and they are a nice rich wine-red color.
Harrison Fisk (co-author of MySQL Clustering) got the first one, because he told me that he recommends Maatkit to MySQL Support customers about twice a week. I made sure to save one for Jay Pipes too, because his luggage got lost so he has nothing to wear. Unfortunately, I didn’t make any Maatkit underwear, sorry Jay. Now I know what to do for next year…
I’ve already given out a whole bunch of them, and at this rate all 50 of them might not last the day!
Harrison Fisk, Jay Pipes, maatkit, mysqlFormer Bolt.com Owner Gets Into Games
Jay Gould, a former owner of pioneering social network and video-sharing site Bolt.com, has launched Gamers Media, an ad network for casual game sites. It is one of several other startups, such as NeoEdge and Mochi Media, which launched last year, seeking to monetize the hugely popular casual games market.
After the bankruptcy of Bolt.com last year, Gould said he was looking for his next opportunity. He’d noted an advertiser rush to gaming sites while at Bolt, and decided that should be his next endeavor. New York-based Gamers Media reaches 20 million uniques and has about 40 properties on which it can place ads, and it has signed a partnership with Adify to build out its publisher network. So far, Gamers Media is profitable, but Gould said he doesn’t disclose revenue.
He did say the CPMs on his site range from $10 to $20 for brand advertising, with tactics such as page takeovers and custom-built “advergames” netting a higher CPM. The site shares an average of 50 percent of its revenue with publishers that range from Big Fish Games to Lycos’ Gamesville property. I love that the company is making money, and is profitable, but the value of Gamers Media is only as good as its publishers. It needs to corner the market fast — or score some exclusive arrangements with big publishers — in order to compete.
How to get your session accepted to MySQL Conference 2008
I'm on the select board of elite people who were duped into reviewing proposals for the upcoming MySQL Conference and Expo 2008, and I'm here to tell you how to get your proposal accepted. Aside from bribing me with chocolate, that is.