…MySQL is a single process with multiple threads. Not all databases are architected this way; some have multiple…that way (I’m looking at you, Java). And many others use persistent connections by … to three are actually running queries on average. These connections originate from dozens to hundreds of…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
…query (single row point select) using standard statement, prepared statement and have it served from query cache. Prepared statements give 2290 queries…from same connection or multiple connections. Do not forget to close prepared statements – Many memory leaks reported in MySQL… about Java MySQL API …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…: Are there similar plugins or resources for Java based applications? A: The recent versions …multiple MySQL servers? Or is it possible to split only read queries (select etc.)? A: You can set up a pair of MySQL instances to replicate from …
Post: Intro to OLAP
July 12, 2010 By 10 Comments
… OLAP with and without aggregation over multiple MySQL storage engines at various data scales…. and quarter. You can create multiple different hierarchies from a single dimension. This allows …query language that looks similar to SQL but is actually very different. Olap4j is an OLAP interface for java…
