…). In order to demonstrate the power of Shard-Query it is important to test complex queries involving joins and aggregation. A star schema… memory was selected. The selected operating system was Fedora 14. Oracle VirtualBox OSE was used to create six virtual machines, each… splitting/loading process will be described in another post. Complex queries Shard-Query was tested with the simple single table version of this…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…confused, thinking MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Query Cache is …query cache offering about double performance for simple queries with select done by primary key, obviously there is no upper boundary – Very complex queries…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… for complex expensive queries, for which tracking exact rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries… be done to Query Cache to make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… is different in some respect and what works well for Oracle,MS SQL, PostgreSQL may not work well for MySQL and… are used to compose the complex object which was previously normalized to several tables or perform complex queries finding relationships between objects. Normalized… split query into several, run in parallel and aggregate result sets. So if you’re dealing with large data sets and complex queries…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… were started by beginners so traditional databases were way to complex to use too. All these requirements made traditional databases irrelevant… little choice so most of them instead of “upgrading” to Oracle or other systems which offer more performance features out of… appliance around the corner which more focuses on CPU bound complex queries and there are more in development. Though I think most…
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… run (and still can’t) most of your Oracle/DB2/MS SQL Queries on MySQL because subqueries optimizer weakness. I’m saying…
Comment: What to tune in MySQL Server after installation
June 29, 2009 By 116 Comments
… using oracle for 8+ years now, I am more of a BI engineer who knows to use SQL and write fairly complex queries…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… support any complex constructs like subqueries or views so you rarely would scratch your head thinking what is this query you peer… quickly leaving this Commodity Space in terms of overall feature complexity. MySQL 5.2 will give you many storage engines to… is Open Source puts it in a worse shape than Oracle and other systems here – typically you get charged more for…
Comment: Are PHP persistent connections evil ?
January 17, 2007 By 31 Comments
… connections between 12 Apache Web servers and a handful of Oracle databases. Persistent connections are certainly evil once you have enough… running the queries instead of managing a lot of connections. In practice, yes, this middle man does increase overall complexity and you… is because SQL Relay has already established X number of Oracle (or MySQL) connections and strives to maintain that number continually…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… however came at cost of larger code size and more complex code which had slowed down some things few percent. This… MySQL for certain applications (ie when queries and schema could not be changed migrating from Oracle) more than once or twice, and… benchmarks vendors try to avoid directly comparable results – for example Oracle and Microsoft would run TPC-C on a bit different…
