… Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries which… from table locks reporting queries can affect web site performance dramatically. Sometimes instead of using slave you may use database version from the… web site users may be suffering when you can’t notice it. Make sure the load is low enough so your complex query…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…so traditional databases were way to complex to use too. All these requirements made traditional databases irrelevant for many web properties – too complex and too…CPU bound complex queries and there are more in development. Though I think most interesting development when it comes from Web Apps come…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… query. Reporting with group by over 10.000.000 of rows in real time is one painful thing to do requiring complex… but we still can’t deny – MySQL does not handle complex queries well, being able to use only one CPU effectively on… about the roots. MySQL has gained its popularity as database for Web but web users do not pay much because they are OK…
Comment: Why you don't want to shard.
August 6, 2009 By 34 Comments
… even though you could have a single web server with 1000 xeon’s in it…database infrastructure. I’d much rather have 4 webservers than 1. Same applies to database infrastructure. – Complexity (…database changes as a part of the application. Our developers write code to change the database, not queries…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…complex constructs like subqueries or views so you rarely would scratch your head thinking what is this query… data structures, handle distributed semantics of web better and are expressive in a different…have their special “database” interfaces which run on top of MySQL or other databases. Other …
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
…tool must generate to answer those queries. Performance challenges with larger databases, and some ways to help …be an ERP application, the logs from a web application, data from manufacturing systems or even …the data will be more complex in this form, but that this complexity is an acceptable trade …
Comment: Are PHP persistent connections evil ?
January 17, 2007 By 32 Comments
…database starts to run out of memory. SQL Relay takes on this burden, freeing the database to focus on running the queries instead of managing a lot of connections. In practice, yes, this middle man does increase overall complexity…
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
… dynamic web page – usually the homepage (it’s the one that gets most traffic) or one representative of typical web page complexity . immediately… translate this to databases, we could replace “static file” with a “simple select”, and “dynamic page” with a query-with-joins. Needless…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… of queries. Honestly I expected more from MySQL 6.0 optimizer improvements effort. 100GB Results are more interesting because this is database size for which you can find results published on TPC Web site. For example These Are….0 in TPC-H Queries post As a Summary: We can see MySQL capabilities to run complex analytics queries, in particular those presented…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…view counter. For smaller single system web site with no caching the … this point we’ve optimized update complexity significantly however sheer volume of updates…+ another mysql instance (or simply the database which is not replicated) to …to run rather complicated group by query ? Sure it does but it …
