If you attended last April’s Percona Live MySQL Conference and Expo in Santa Clara, you know it was a rare opportunity… using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple environments? Are you working with MySQL or… look at the benefits of sponsorship. Questions? Let me know in the comments section. I look forward to hearing from you!
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… involving the McAfee MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL has traditionally been… understand why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of… my config file for the plugin to work (plus one commented line for switching between file and socket for output): plugin…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127…./05/schemaspy.meta.xsd”> <comments> Main Production Database. Percona, Michael Coburn comments> … Index Detection I commented about this on my last webinar, but did not have time to analyze it in-depth. If you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER… explains more in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in the… … on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with… on performance of the benchmark. There was some discussion in the comments and I promised to follow up with more SSB tests… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb… … moving from MySQL to/from Oracle/MSSql/etc is even more painful.) And much of the code was in assembly language for…. The verdicts helped cut back on vendor/service lock-ins (Vadim’s first comments), and made for a more level playing field… with ‘traditional’ business models. Another history note: 100 years ago (in the US), there were 100 auto manufacturers. By the 1970s… … core” plans are announced for MySQL Server – the online backup in MySQL 6.0, it’s to ship in commercial version only. An Innodb Plugin is announced and will be separate from MySQL… moments do you have from you attending MySQL Conference over last 10 years. Please leave comment and share your experiences! Thank you… … is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read on, ponder…_name)+2) (bytes) + length of all comments (in bytes) + length of all intervals (for ENUM, SET) in bytes. If you use that as…).”‘) COMMENT ‘”.cname($_,254).”‘,\n”; } chop $sql; chop $sql; $sql.=”);”; print $sql; So the maximum number of columns for a table in MySQL is… …and breakout session speakers who presented insights into MySQL and MySQL-related technologies in over 110 sessions across four days. Special thanks … enjoyed the Percona Live MySQL Conference keynote presentations this year. I heard very positive comments on the sponsor sessions including … …: MySQL‘s creator on why the future belongs to MariaDB.” To quote that article: “In principle, anyone who has an interest in MySQL and… for Tokutek). To summarize my thoughts: If you are in the MySQL market and your product is under proprietary license (not an…. Everything here is my personal position, but I welcome your comments. Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.
comments=”Parent table”>
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment Comment: Open Source, the MySQL market (and TokuDB in particular)
May 20, 2013 By 13 Comments Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
Percona Webinars
Percona MySQL Training
Percona Careers
