… a method for creating materialized views for MySQL data sets. The tool is for MySQL, but the methods are database agnostic. A… not aware of research into combinatorial algebra and developed these techniques in isolation from other researchers as I am an amateur…
Post: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We also want to know… use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log…’s true workload. At the moment there is no other technique that approaches the amount of information a Percona build can…
Post: Followup on performance metrics: slides, video
July 11, 2011 By 6 Comments
… into a more complete description of how to analyze MySQL’s performance and scalability through nothing more than TCP/IP packet headers… first draft of a white paper that lays out the techniques and the results very clearly; in watching the video, I… interested, I believe that a set of powerful tools and techniques is emerging from this research. Stay tuned — there is more…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
…causes problems if you would like to use MySQL Slave as it can contain stale data. …and better cached in something like memcache. This technique especially works great with caching things in …from the slaves, reducing master load and improving scalability by use of simple replication. If using …
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…can post their favorite techniques in the comments. I’ll show you one technique that is interesting, and… maybe a bit longer. This is common in MySQL servers I work with when they’re …a system’s performance (via measuring response times), scalability (via the four fundamental metrics I mentioned in…
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
…to MySQL and InnoDB Fernando Ipar: PHP Object-Relational Mapping Libraries In Action Baron Schwartz: Read-Write Splitting: Techniques, Challenges,…Performance and Scalability Peter Zaitsev: Choosing Hardware and Operating Systems for MySQL Peter Zaitsev: Instrumenting your Application for MySQL and …
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… post’s “sister post” which describes the distributed set processing technique. Also, remember that Percona can help you get up and…. This prevents the system from being overloading and provides a scalable average response time under increased concurrency. Another queue in front…
Page: Presentations
May 3, 2006 By
… Techniques for Scaling Web Applications (Russian) HighLoad 2007 , Moscow, Russia, September 2007 Presentations covers basic principle of building scalable … and in other places. MySQL Performance Landscape MySQL Users Conference 2006, Santa Clara, CA MySQL was benchmarked on different platforms …
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
… folks hit the InnoDB auto-inc scalability issue with MySQL 5.0 and older versions, employing other techniques to maintain the PK auto… OK, 0 rows affected (0.00 sec) — 3. mysql> ^Z [1]+ Stopped mysql test # mv huge_table.frm huge_table_old.frm…_table_new.frm # fg mysql test — 4. mysql> UNLOCK TABLES; Query OK, 0 rows affected (0.00 sec) mysql> SHOW CREATE TABLE `huge…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result… to use MySQL Stored Procedures which can be fit to do this simple job. The downside of using these techniques if of… original tables on the same server which can limit your scalability. Using FEDERATED Tables can work for some cases in others…
