… to explore new tools using their environments. One tool that I am finding very helpful is called SchemaSpy. SchemaSpy is a Java… is where Metadata files come in to play Creating a Metadata File The format of the metadata file is XML-based. I….xml -o /var/www/schemaspy/ The -o directive tells SchemaSpy where to write the output to, make sure this is a…
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
I am also looking for to the next few releases. I filed several bugs for cases where page flushing wasn’t going as fast… fixes at this point don’t require major changes. So I am hoping that 5.6.12 or 5.6.13 will…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… good amount of reads. A few words about the hardware: I am going to use new the Dell PowerEdge R420 with two… a problem for some users. Now, I understand that my PRIMARY KEY (`hid`,`mid`,`id`) where `id` is sequential, and `hid`,`mid… are all defaults, as I understand from documentation TokuDB comes with good settings out-of-box, but I am ready to tune something…
Comment: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
I am confused about how this tests flashcache. The use case for … some data in flash and much more data on disk. Where/what are the disks in this benchmark? The benchmark database… the flash device is huge (2.2tb). To test flashcache I think you should use a database much larger than the…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… partition can be cached, as opposed to a single table, where probably only recently read records will be cached, resulting in… partition, not the whole table. 3. Insert on Duplicate Key (I dont do replace… ever)… if across partitions, will be slower… happen in a MyIsam environment on similar sized tables). What I am really saying is that its not only about the ‘Selects…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
i would appreciate your comments on this script: taken from: http://… `menu` GROUP BY parent) Deriv1 ON a.id = Deriv1.parent WHERE a.parent=” . $parent); echo “”; while ($row = mysql_fetch_assoc($result…(0, 1); ?> Posted by bikash ranajan nayak at 10:30 AM
Comment: Is Synchronous Replication right for your app?
May 18, 2013 By 18 Comments
… your reasoning it seems as if one of the places where Galera’s optimistic locking gets into trouble is large transactions…_of_large_transaction + RTT. Does this reasoning seem correct or am I missing something?
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… a standard with no custom extensions. I‘m trying to think of an example but am coming up empty off the top of my head. I agree with most of your… association they make is “free”. I‘ve worked under a few different senior management types where the first thing they ask is…
Comment: What to tune in MySQL Server after installation
July 27, 2008 By 118 Comments
… of the sites where I am encountering a problem is: commondreams.org Each time I try to EDIT one of my posts, I am allowed (once) to perform the edit, but I then immediately receive… syntax”? Where does it “reside”? How can I “fix it”? Is there some nifty “patch” that will fix it for me? I am not…
Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE
November 20, 2007 By 51 Comments
Hi, I am working on solving an issue where I am running into some deadlocking. Essentially things look like this (MySQL ….id=12 Transaction-2 ————– UPDATE assets SET mod_date=NOW() WHERE asset.id=12 It appears that the deadlock is occurring… me and I gave it a try and it didn’t fix the deadlocking so I am assuming I am misunderstanding things. Essentially I added a…
