June 18, 2013

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

June 18, 2013 By Leave a Comment

Percona XtraDB Cluster (PXC) was released over a year ago and since then there has been tremendous interest and adoption.  There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and such the need …

Filed Under: Events and Announcements, Percona XtraDB Cluster Tagged With: , , , , , ,

Comment: Percona Server 5.6.11-60.3 first Release Candidate now available

June 18, 2013 By 3 Comments

does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

… with MySQL, then this is an event you can’t afford to miss… :)   So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL University and…

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

Post: Call for papers: Percona Live London

June 14, 2013 By 1 Comment

… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… are gold! And you owe it to the MySQL community to share them. Don’t worry about being fancy. Some of the… sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs…

Filed Under: MySQL, Percona Live Tagged With:

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

… you don’t want to use this. Please see “Highly selective columns only” section for examples where it doesn‘t work well for…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

June 17, 2013 By Leave a Comment

… wrappers/scripts around this to make life easier, however, wouldn’t it be nice if this was built into the system… hostname – should be known in advance (the node itself needn’t be up), which may not be feasible in a cloud… (Note, the wsrep_sst_xtrabackup in 5.5.30 can’t do those except parallel, the one in 5.5.31…

Filed Under: MySQL, Percona XtraDB Cluster, XtraDB Cluster Tagged With: , , , , , , , ,

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 17, 2013 By 3 Comments

Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Comment: Performance Schema overhead

June 12, 2013 By 22 Comments

Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering :) Thanks for sharing.

Filed Under: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

Comment: Converting Character Sets

June 12, 2013 By 22 Comments

… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For…

Filed Under: Insight for Developers Tagged With: , ,

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

…Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/…id — this might make sense to Developers but it doesn‘t help SchemaSpy at all.  This is where Metadata …of all columns in the schema, really handy to sort by name to see if you have any …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,
« Older Posts