tag:blogger.com,1999:blog-4196653310473331395.post4256916692084552697..comments2023-07-15T03:25:46.207-07:00Comments on Sarah's thoughts on MySQL: MySQL's query cacheSarahhttp://www.blogger.com/profile/15336146699240103888noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4196653310473331395.post-10869780117025429172009-09-19T16:53:14.532-07:002009-09-19T16:53:14.532-07:00hello sarah, you have a nice blog...
can I transla...hello sarah, you have a nice blog...<br />can I translate to portuguese some parts of your posts and post in my blog?<br />www.freelancersbrasil.com<br /><br />my e-mail: lucas@freelancersbrasil.com<br /><br />thanx =]Lucas Renanhttps://www.blogger.com/profile/06185590061023020630noreply@blogger.comtag:blogger.com,1999:blog-4196653310473331395.post-54514993104929047982009-09-16T06:46:54.029-07:002009-09-16T06:46:54.029-07:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4196653310473331395.post-75637502694685481982009-09-09T22:43:40.397-07:002009-09-09T22:43:40.397-07:00I was google searching for an example of good/bad ...I was google searching for an example of good/bad MySQL indexing/queries and your blog came up. I have an engineer that won't believe that his queries/indexes are messed up and that is why his responses fail. I've cloned his machine to a more powerfull server and the response is the same. Do you know of any examples to prove, in MySQL, the performance loss/impact of a crummy database with bad indexing and queries?Unknownhttps://www.blogger.com/profile/12566304044307254838noreply@blogger.comtag:blogger.com,1999:blog-4196653310473331395.post-62280614265132329642009-09-09T06:07:47.658-07:002009-09-09T06:07:47.658-07:00I would also suggest that you avoid using the quer...I would also suggest that you avoid using the query cache as a generic cache, but instead make use of the SQL_CACHE keyword and the "on demand" mode. That way you can cache just those queries which can make the most out of the cache.Entry 23 Eco of Kristoferhttps://www.blogger.com/profile/08660248305487815756noreply@blogger.comtag:blogger.com,1999:blog-4196653310473331395.post-70157826614464581972009-09-05T23:49:57.615-07:002009-09-05T23:49:57.615-07:00Hi!
nice summary :)
I'd like to point out th...Hi!<br /><br />nice summary :)<br /><br />I'd like to point out that the key for query cache does not consist of only the sql text. Because the query cachce stores the binary resultset as it will be sent over the wire, everything that might result in a different binary result set is included in the key. Among others, <br />- the default database<br />- the characterset of the connection<br />(i forget other things that are included)rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.com