…” mode. What to do? I whish I could say you should use Percona Server with XtraDB. If we were using SSD as storage, then I would recommend…. I am going to followup with results on Percona Server. So first recommendation you may hear in this case from the Oracle/MySQL engineers…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
… MPB. Because of this, I am going to start out …using aggregation. Using materialized views to automate that aggregation process. Comparing the performance of OLAP with and without aggregation over multiple MySQL storage engines at various data scales. What is BI? …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…MySQL 5.6 use the sysbench OLTP workload. I wanted to test a set of queries which, unlike sysbench, utilize joins. I…What usually happens is that the full table scans access the table by primary key. This forces the storage engine… anomaly. I am going to focus on the first query, which uses only …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…use case for the PBXT engine, and how does it compare in performance? Â When would I use PBXT instead of a storage engine…storage engine vendors are able to keep all their code at that layer (Infobright had to make major changes to MySQL itself). Â What…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…file used and the computer hardware specs that produced this benchmark. I am …MySQL/MySQL Server 5.0/” datadir=”C:/Program Files/MySQL/MySQL Server 5.0/Data/” default-character-set=latin1 default-storage-engine=INNODB #default-storage-engine… writing of the insert is what was taking all the time…
Comment: How fast can MySQL Process Data
April 11, 2008 By 3 Comments
…MySQL really needs to scan the table rather then looking at some index (if that is optimized). I am also wondering why you didn’t use an innodb storage engine and using the MEMORY storage type. I…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize | error | Got error -1 from storage engine…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… use > mysql_ functions directly as well – I would go for using … but using prepare/execute is more consistent with what I’ve…using some other storage engine like Archive… > 3. Using multiple databases Honestly I do not see application using > one database per table that often. I… understand why I am…
Post: Friday challange: linking with GPL code
May 8, 2009 By 20 Comments
… (what else to do Friday evening) , but I see how it can be used in current dual-licensed mixed open / closed source storage engines MySQL world… libquickcompress ? What is license of final binary ? May be it is simple question and answer is obvious, but I am not sure what is…
Comment: Partially OpenSourced
April 16, 2008 By 21 Comments
… software. But I am in charge not only of software production but also revenue generation. We are trying to find useful ways to… storage engine-specific drivers) that we will deliver to customers in the MySQL Enterprise product only. We have not yet decided under what licence…
