… – Compromising your web server does not directly give access to your database, even though most applications have enough database access permissions to be… use for such extra memory is probably caching – Web page caching, if you do not have separate layer for it, local memory or cacheing type of…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… you design your application as CPU bound and when it scales so much you can’t afford to get enough memory any more, you might have… are high) I would highlight this query as possibly having performance problems. Also do not look just at “typical” case – in many cases… plus you do not want to piss of your most loyal users with slow page load times. So for IO bound applications you will…
Post: Small things are better
October 8, 2006 By 15 Comments
…small, so you do not have to use complicated scenarios to do simple things. Assume for example you need to…indexes will well fit in memory for such small tables. Not to mention splitting 500 …permissions will be good enough. Doing so will ensure you will not have problems once you will really need to…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… enough to pay for the price premium ? The third one is caching. SAN can have a lot of cache though servers can typically have more. If you can afford SAN you should afford 128GB of memory… not just a speculation, some clients really had it) Even if you do not run any “Cluster” having SAN you …
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
…not cleared until you fetch whole result set if you‘re reading from tables directly (if you do not have “using temporary” in EXPLAIN) this was not…you do not fetch data for long enough MySQL Server may think client is dead and close connection. This well may happen if you…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…do the same. This is huge hole in MySQL design, thinking little about users isolations and resource quotas and interesting enough I have not…you do not need a lot of load. You can do this by very light queries which would not show up in the PROCESSLIST or will not…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…you do not have spare hard drive you can often pool the one from the spare server and have…Having spare servers also means you often do not need most expensive support agreements and Business Hours Monday-Friday is good enough for you – you‘re not…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…you can often do much better with denormalized data. You may wish > to use denormalized data as cached lookup table however so you do > not have…have to fix have number of indexing missing which > requires queries to do full table scans. Funny enough this is often > not… amounts of memory and disk. …
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
…you would have 10 16GB boxes your “effective cache” would be still about 14GB not even close 140GB as total amount of cache memory you have… this solution is right for you so you do not have to jump to other schemes…So you it can grow well enough before gibing you trouble. – Few replicas – If you have…
Comment: How much memory can MySQL use in the worst case?
January 21, 2012 By 17 Comments
…the possibility of not having enough memory to complete their task which would lead them to block until memory were freed,…that memory into ram. I guess however doing that now would mean too much of a change in memory… just prefer to say: “you can use up to XXX GB” and have mysqld stick to that, using…
