… any host:port or schema name information. Viewing SchemaSpy output A completed Relationships view of these three tables should look like this…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… to the presentation, it’s currently up and available for viewing over at percona.com. My apologies if we weren’t…
Comment: MySQL Query Patterns, Optimized - Webinar questions followup
June 5, 2013 By 2 Comments
Hi Oleksii, thanks for viewing my webinar and your comments. I use the short index names because the alternative would require the font size on the slides to be very small. I know that abbreviated index names are harder to understand, but hopefully the tradeoff is the right one.
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
May 28, 2013 By 3 Comments
I backed port percona’s perf tuning for read_view to AliMySQL-5.5, with 1K connections case, RO 13187 -> 40797, RW QPS 2W -> 3W TPS 5K-> 8.5K Amazing ~
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… is considered BETA quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended…
Comment: MySQL VIEW as performance troublemaker
May 23, 2013 By 57 Comments
just to add. i am thinking of working with temporary values getting posted immediately after a transaction eg customer balance on the customers table. Then i wont need a view.
Comment: MySQL VIEW as performance troublemaker
May 23, 2013 By 57 Comments
i have been burned by ms access queries. now that i am into mysql… i certainly want to hear all these view stories. even though i have not yet used them.lol.
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for this structure from heap. The problem… Percona Server, for each connection we use a preallocated read view structure, reuse that memory during the entire connection lifetime and… transactions optimization), but it still allocates/frees memory for read view structure and that causes drops at high threads with glibc…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… more common than even the most popular NoSQL database when viewing indicators such as inclusion in LinkedIn bios Oracle MySQL may… Aslett’s summary of 451 Research’s database survey by viewing the research report “451 Research database survey points to MySQL… a single web page, complete the Keynotes Recordings form To view the keynote recordings without slides, visit the Percona MySQL YouTube…
