Skip to main content

Home/ ProgrammingPages/ Group items tagged http

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Navneet Kumar

MySQL Performance Blog » MySQL Query Cache - 0 views

www.mysqlperformanceblog.com/...mysql-query-cache

caching mysql performance tuning

shared by Navneet Kumar on 26 Sep 07 - Cached
  • It does not cache the plan but full result sets
  • so it looks at first letter of the query and if it is “S” it proceeds with query lookup in cache if not - skips it.
  • Might not work with transactions
  • ...15 more annotations...
  • uses non-deterministic functions such as UUID(), RAND(), CONNECTION_ID() etc it will not be cached.
  • If table gets modification all queries derived from this table are invalidated at once
  • if you have high write application such as forums, query cache efficiency might be pretty low due to this.
  • all queries are removed from cache on table modifications - if there are a lot of queries being cached this might reduce update speed a bit
  • Qcache_free_memory and Qcache_lowmem_prunes
  • number of your selects - Com_select and see how many of them are cached. Query Cache efficiency would be Qcache_hits/(Com_select+Qcache_hits).
  • One portion of query cache overhead is of course inserts so you can see how much of inserted queries are used: Qcache_hits/Qcache_inserts Other portion of overhead comes from modification statements which you can calculate by (Com_insert+Com_delete+Com_update+Com_replace)/Qcache_hits
  • want to set query cache
  • means it is much more efficient as query which required processing millions of rows now can be instantly summoned from query cache
  • It also means query has to be exactly the same and deterministic, so hit rate would generally be less
  • full page caching
  • not using query_cache_wlock_invalidate=ON locking table for write would not invalidate query cache so you can get results evenif table is locked and is being prepared to be updated
  • it can serve responses very fast doing no extra conversion or processing.
  • but it is still not as fast as specially designed systems such as memcached or local shared memory.
  • It is not distributed If you have 10 slaves and use query cache on all of them cache content will likely be the same, so you have multiple copies of the same data in cache effectively wasting memory
  • Navneet Kumar on 26 Sep 07
     
    mysql query caching
Navneet Kumar

mysql query cache - 0 views

jayant7k.blogspot.com/...mysql-query-cache.html

mysql performance tuning

shared by Navneet Kumar on 26 Sep 07 - Cached
  • Navneet Kumar on 26 Sep 07
     
    tuning mysql performance with query caching
Navneet Kumar

Pythian Group Blog » MySQL: Tuning filesorts and temporary tables - 0 views

www.pythian.com/...filesorts-and-temporary-tables

mysql tuning

shared by Navneet Kumar on 20 Sep 07 - Cached
  • Navneet Kumar on 20 Sep 07
     
    filesort and temporary tables in query
Navneet Kumar

SQL Server Data Structure - 0 views

www.akadia.com/...sqlsrv_data_structure.html

data_structure ms-sql sql_server storage

shared by Navneet Kumar on 17 Sep 07 - Cached
  • Navneet Kumar on 17 Sep 07
     
    MS SQL Server Data structures. how data is stored in ms sql  server
Navneet Kumar

Vi for programmers - Program - UNIX - Builder AU - 0 views

www.builderau.com.au/...0,339024638,339129821,00.htm

editors tools unix vim

shared by Navneet Kumar on 10 Sep 07 - Cached
  • Navneet Kumar on 10 Sep 07
     
    taming vim, vim options
Navneet Kumar

10 secret MySQL client startup options you should know - 1 views

articles.techrepublic.com.com/5100-9592-6154202.html

mysql tuning

shared by Navneet Kumar on 06 Sep 07 - Cached
  • Navneet Kumar on 06 Sep 07
     
    mysql client options
Navneet Kumar

MySQL AB :: MySQL 5.0 Reference Manual :: 13 Storage Engines - 0 views

dev.mysql.com/...storage-engines.html

database_engine innodb myisam mysql storage

shared by Navneet Kumar on 03 Sep 07 - Cached
  • Navneet Kumar on 03 Sep 07
     
    mysql storage engines myisam and innodb
Navneet Kumar

Unusual software bug - Wikipedia, the free encyclopedia - 0 views

en.wikipedia.org/Heisenbug

debugging testing

shared by Navneet Kumar on 30 Aug 07 - Cached
  • Navneet Kumar on 30 Aug 07
     
    heisenbug, bohrbug, mandelbug, schroedinbug
Navneet Kumar

PatHelland's WebLog : Normalization Is for Sissies - 0 views

blogs.msdn.com/...malization-is-for-sissies.aspx

database database_design denormalization normalization slide

shared by Navneet Kumar on 28 Aug 07 - Cached
  • Navneet Kumar on 28 Aug 07
     
    de-normalization is ok if you are not going to update
Navneet Kumar

What about Sun embracing JavaScript? - 0 views

www.russellbeattie.com/...about-sun-embracing-javascript

blog javascript sun

shared by Navneet Kumar on 27 Aug 07 - Cached
  • There's a lot of work being done by the Mozilla foundation and Adobe to integrate a killer JavaScript interpreter into both Flash and Firefox using Adobe's Tamarin engine
Navneet Kumar

SQL Server 7.0: System Error Messages - 0 views

www.microsoft.com/...75528c12.mspx

database error_codes error_messages ms-sql sql sql_server

shared by Navneet Kumar on 27 Aug 07 - Cached
  • Navneet Kumar on 27 Aug 07
     
    All ms-sql system error messages
Navneet Kumar

SQL Server 7.0: Resolving System Error Messages - 0 views

www.microsoft.com/...75528c13.mspx

database debugging mssql sql

shared by Navneet Kumar on 27 Aug 07 - Cached
  • Navneet Kumar on 27 Aug 07
     
    some ms-sql error-code  descriptions
Navneet Kumar

MySQL Reference Manual for version 5.0.3-alpha - 23 Error Handling in MySQL - 0 views

www.browardphp.com/...manual_Error-handling.html

error_codes mysql

shared by Navneet Kumar on 27 Aug 07 - Cached
  • Navneet Kumar on 27 Aug 07
     
    mysql error codes
Navneet Kumar

Bruce Eckel's MindView, Inc: 3-10-04 Generics Aren't - 0 views

www.mindview.net/log-0050

article bruceeckel c++ generics java parameterized_type templating

shared by Navneet Kumar on 22 Aug 07 - Cached
  • Generics seem to only solve the problem of automatically casting in and out of containers.
  • So if we write generic code that actually takes a "type of anything," that type can only be an Object, and our generic code must only call Object methods on it.
  • generics have no advantage. In fact, it's confusing if you see them used, because you scratch your head and wonder "why does he need a generic here? What is the advantage?" Answer: none.
  • ...3 more annotations...
  • Java Generics use "erasure," which drops everything back to Object if you try to say "any type." So when I say <T>, it doesn't really mean "anything" like C++/ADA/Python etc. does, it means "Object."
  • So generics are really "autocasting."
  • That's the way of the Java world, and we are going to miss out on latent typing (it's actually possible to simulate latent typing using reflection, as I do once or twice in Thinking in Java, but it's messy and much less elegant).
  • Navneet Kumar on 22 Aug 07
     
    bruce Eckel article on java generics, and how it does  nothing more than  autocasting. Also templating or parameterized type in C++, Ruby, Python
Navneet Kumar

An Unorthodox Approach to Database Design : The Coming of the Shard | High Scalability - 0 views

highscalability.com/h-database-design-coming-shard

database database_design scalability shards storage

shared by Navneet Kumar on 28 Aug 07 - Cached
  • Navneet Kumar on 28 Aug 07
     
    shard architecture partitions data onto multiple servers, so each server holds a shard of data
« First ‹ Previous 61 - 80 of 97 Next ›
Showing 20▼ items per page