MySQL Librarian http://http://dev.mysql.com/librarian/ RSS Feed of additions to the MySQL Librarian. The MySQL Librarian collects the best of the web when it comes to information, articles, books, reviews, images and video on MySQL. Copyright 2009 Sun Microsystems Copyright 2009 Sun Microsystems Accessing the same data through LDAP and SQL http://www.clusterdb.com/mysql-cluster/accessing-the-same-data-through-ldap-and-sql/ 886 Lenz Grimmer MySQL Cluster ldap mysql MySQL Cluster CGE OpenLDAP OpenLDAP includes a driver that allows it to store and access data held in MySQL Cluster. It uses the NDB-API to access the database and so the performance is extremely good. One of the great things about the solution is that it lets you simultaneously access the same data through both LDAP and SQL (or the NDB-API or any of the MySQL connectors). This article gives an example of how this can be done.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Fri, 09 Oct 2009 15:35:15 +0000
Resolving “Database page corruption” Error in MySQL http://quizilla.teennick.com/stories/14684938/resolving-database-page-corruption-error-in-mysql 885 Colin Dolly mysql Python repair Beginner Database Recovery For MySQL is recovery software to recover MySQL database files. It supports MySQL .myd and .myi files. It is the ultimate read-only tool, which uses advanced algorithms to recover the corrupted database files and offers optimum disaster recovery for database administrators, business users, database programmers and more.MySQL database repair tool to recover and repair corrupted database generated through SQL.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Fri, 09 Oct 2009 10:38:16 +0000
Taste test: Innobackup vs. Xtrabackup http://www.pythian.com/news/4177/taste-test-innobackup-vs-xtrabackup 878 Sebastien Dejean mysql Backup Hot Backup innobackup innodb Xtrabackup A quick look at some strong points between InnoDB Hot Backup and Xtrabackup
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Thu, 01 Oct 2009 21:55:12 +0000
Shlomi Noach: How NOT to test that mysqld is alive http://code.openark.org/blog/mysql/how-not-to-test-that-mysqld-is-alive 876 Giuseppe Maxia mysql Analysis monitoring mysqld ps pid Testing tip Shlomi shows a real world scenario where the naive approach to monitoring fails spectacularly.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Thu, 01 Oct 2009 11:29:48 +0000
Update: Find Query Per certain Seconds http://mohammadlahlouh.blogspot.com/2009/10/update-find-query-per-certain-seconds.html 875 Mohammad Lahlouh database MySQL Forge GLOBAL_STATUS mysql performance In my old post there is a bug when run in MySQL 5.1.30 and old, because the status variable Queries was added in MySQL 5.1.31. So i change to choose between Queries and Questions status variables, and I think the Queries represent more accurate result.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Thu, 01 Oct 2009 08:19:47 +0000
Sheeri K. Cabral: Free and easy schema diff and patch http://www.pythian.com/news/4162/free-and-easy-schema-diff-and-patch 873 Sakila The Librarian mysql diff gui tools schema tips Workbench Sheeri explains, in practice, how to synchronize schemas using MySQL Workbench
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 30 Sep 2009 14:13:00 +0000
Sheeri K. Cabral: Is the query cache useful? http://www.pythian.com/news/4142/is-the-query-cache-useful 871 Mark Daems mysql benchmark cache query cache performance Sheeri explains why turning on the query cache without thinking about the consequences is bad but also why simple benchmarks proving 'the query cache is bad' may be skewed
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Tue, 29 Sep 2009 07:44:02 +0000
Ronald Bradford: Using the Query Cache effectively http://ronaldbradford.com/blog/using-the-mysql-query-cache-effectively-2009-09-28/ 870 Sakila The Librarian Databases Linux mysql Professional Uncategorized application performance Caching mysql query cache query cache cache performance Maximize your strengths, minimize your weaknesses. You can apply this approach to many things in life, I apply it to describing and using MySQL the product, and it’s components. The Query Cache like many features in MySQL, and indeed features in many different RDBMS products (don’t get me started on Oracle *features*) have relative benefits. In one context it can be seen as ineffective, or even detrimental to your performance, however it’s course grain nature makes it both trivial to disable dynamically (SET GLOBAL query_cache_size=0;), and also easy to get basic statistics on current performance (SHOW GLOBAL STATUS LIKE ‘QCache%’;) to determine effectiveness and action appropriately.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Tue, 29 Sep 2009 07:41:26 +0000
Mark Callaghan: Be nice to the query cache http://www.facebook.com/note.php?note_id=143487095932 869 Sakila The Librarian query cache mysql benchmark sysbench performance Mark Callaghan tests the query cache. "The query cache has had an interesting history with MySQL. I don't have much experience with it. I might want to use it in the future so I enabled it during a run of sysbench readonly on an 8-core server. The results are fascinating."
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Tue, 29 Sep 2009 07:39:17 +0000
A broken MySQL backup is useless - Make sure you test both your backup AND your recovery processes http://swanhart.livejournal.com/129129.html 868 Justin Swanhart mysql Backup restore Replication Disaster Recovery Informative post about backup and restore procedures, disaster recovery plans and load balancing tips.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Thu, 24 Sep 2009 18:59:53 +0000
Jeremy Zawodny: MySQL Sandbox: Treat MySQL Instances like Virtual Machines http://www.linux-mag.com/cache/7442/1.html 867 Sakila The Librarian mysql sandbox Introduction Linux zawodny Install isolated side-by-side MySQL instances right the first time with this time-saving virtual manager. Jeremy Zawodny tests MySQL Sandbox with a thorough description.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Thu, 24 Sep 2009 11:44:19 +0000
MySQL Sandbox by Giuseppe Maxia http://www.youtube.com/watch?v=WwPRLCdo7KI 866 Sheeri Cabral Giuseppe Maxia mysql mysqlug sandbox Giuseppe Maxia speaks at the April 2009 Los Angeles MySQL User Group about MySQL Sandbox and how to use it for simple and complex sandbox scenarios.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 23 Sep 2009 20:09:35 +0000
SPIDER Storage Engine: Database Sharding by Storage Engine http://www.youtube.com/watch?v=scKjO0LnnJo 864 Sheeri Cabral mysql spider storage engine Kentoku Shiba mysqlconf SPIDER Storage Engine: Database Sharding by Storage Engine by Kentoku SHIBA (ST Global.,Inc) The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6837 Download the presentation file (zip archive) at http://assets.en.oreilly.com/1/event/21/SPIDER%20Storage%20Engine_%20Database%20Sharding%20by%20Storage%20Engine%20Presentation.zip
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 23 Sep 2009 20:08:12 +0000
Sphinx, the open-source MySQL storage engine for blazingly fast keyword searches http://www.youtube.com/watch?v=KY_EKcuboaI 863 Sheeri Cabral sphinx Andrew Aksyonoff mysqlug fulltext storage engine Presented at the April 2009 Los Angeles MySQL User Group (see http://www.meetup.com/lamysql/calendar/9882984/ for more details) BIO: Andrew Aksyonoff is a Russian geek who created Sphinx back in 2001 and has been working on the code base ever since. Fluent in C++, less so in human speak, but keeps trying. He lives in Russia. TOPIC: Sphinx Just how do you implement keyword search through that 10-million-row InnoDB table? Meet Sphinx, a blazing fast open source engine that makes it a breeze. We'll talk about what it is, how it works, and when and why use it. INTERESTING FACT: Meetup search is powered by Sphinx.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 23 Sep 2009 20:07:53 +0000
Backups: A Video Presentation By Keith Murphy From the June 2008 Boston MySQL User Group http://www.pythian.com/news/1066 865 Sheeri Cabral mysql Presentations video Backups sheeri Pythian The Boston MySQL User Group got Keith Murphy to speak at the June User Group meeting, about backups. Direct play the video at:http://technocation.org/node/559/playDirect download the video (351 MB) at:http://technocation.org/node/559/downloadLinks referred to in the presentation:MyLVMBackup by
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 23 Sep 2009 20:07:41 +0000
Intro to XtraDB, a Scalable InnoDB-based Storage Engine http://www.youtube.com/watch?v=kTCUZ3s1iIY 861 Sheeri Cabral mysql mysqlcamp Percona xtradb innodb storage engine ewen fortune Presented at MySQL Camp 2009 by Ewen Fortune of Percona. XtraDB is a storage engine for MySQL based on the InnoDB storage engine, designed to better scale on modern hardware, and including a variety of other features useful in high performance environments. It is fully backwards compatible, and so can be used as a drop-in replacement for standard InnoDB. XtraDB includes all of InnoDBs robust, reliable ACID-compliant design and advanced MVCC architecture, and builds on that solid foundation with more features, more tunability, more metrics, and more scalability. In particular, it is designed to scale better on many cores, to use memory more efficiently, and to be more convenient and useful. The new features are especially designed to alleviate some of InnoDBs limitations. We will talk about current status of XtraDB and directions of development.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 23 Sep 2009 20:07:35 +0000
Optimizing MySQL Performance with ZFS http://www.youtube.com/watch?v=a31NhwzlAxs 860 Sheeri Cabral mysql zfs mysqlconf Allan Packer Neelakanth Nadgir Optimizing MySQL Performance with ZFS by Allan Packer (Sun Microsystems), Neelakanth Nadgir (Sun Microsystems) The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7121 which includes the description
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 23 Sep 2009 20:07:06 +0000
Top 10 MySQL Pet Peeves and How to Workaround Them by Matt Yonkovit http://www.youtube.com/watch?v=yxx2XbbTiP0 862 Sheeri Cabral mysql Jeremy Zawodny performance mysqlcamp mysqlconf presented at MySQL Camp 2009.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 23 Sep 2009 20:06:34 +0000
What the MySQL is this, anyway? http://www.pythian.com/news/2007 859 Sheeri Cabral Giuseppe Maxia sheeri sheeri cabral mysql Pythian Giuseppe Maxia and Sheeri K. Cabral give an introduction to what MySQL is. A PDF of the slides can be downloaded at http://technocation.org/files/doc/2009_04_Tour.pdf (21 Mb). Links referred to in the presentation, or related to the presentation: The MySQL forge can be found at http://forge.mysql.com, which contains the Wiki (http://forge.mysql.com/wiki) as well as the worklog, code snippets and tools for use with MySQL. Planet MySQL is an aggregate of MySQL-related blogs, including Giuseppe's and mine -- http://planet.mysql.com The website for the 2009 MySQL User Conference and Expo is at http://mysqlconf.com. MySQL Camp is a free conference at the same time as the User Conference. The details, including the schedule, are at http://forge.mysql.com/wiki/MySQLCamp2009Sessions. A collection of User Group videos is at http://technocation.org/category/areas/user-group. All the videos, including User Group ones, are at http://technocation.org/category/areas/presentationsvideos. The videos from the 2008 MySQL User Conference and Expo are at http://forge.mysql.com/wiki/MySQLConf2008Notes The videos from the 2007 MySQL User Conference and Expo are at http://www.technocation.org/content/2007-mysql-user-conference-and-expo-presentations-and-videos Episodes of the MySQL podcast can be found at http://technocation.org/category/areas/podcasts Learn more about MySQL University, a free, drop-in, weekly in-depth session of technical issues (such as MySQL internals) at http://forge.mysql.com/wiki/MySQL_University. MySQL Proxy information, including a getting started guide, can be found at http://forge.mysql.com/wiki/MySQL_Proxy.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 23 Sep 2009 20:05:50 +0000
Real Time Data Warehousing Presentation and Video http://www.pythian.com/news/1710 858 Sheeri Cabral Jacob Nikom data warehousing real time dw mysql mysqlug data warehouse benchmark At the March 2009 Boston MySQL User Group meeting, Jacob Nikom of MITs Lincoln Laboratory presented Optimizing Concurrent Storage and Retrieval Operations for Real-Time Surveillance Applications. In the middle of the talk, Jacob said he sometimes calls what he did in this application as real-time data warehousing, which was so accurate I decided to give that title to this blog post. The slides can be downloaded in PDF format (1.3 Mb) at http://www.technocation.org/files/doc/Concurrent_database_performance_02.pdf. This talk discussed how to do real-time retrieval operations while doing concurrent high volume insertion, including: * How to keep up with 1.5 Mb/second per server incoming data stream * * server hardware comparison between a multi-core AMD Opteron and a multi core Intel Xeon * MySQL/Postgres comparison * schema design * design of the storage/retrieval benchmark * tuning MySQL Jacob showed the insertion time from the number of applied indexes. He also demonstrated the excellent responsiveness of the MySQL server both in simulated and actual surveillance. At about 7 minutes into the presentation, Jacob begins to discuss marshalling, which is converting the XML to data and back. After the 20-minute mark, an audience member asks about what marshalling is, so I wanted to make sure that folks have the definition ahead of time.
MySQL Librarian Voting: Vote UP / Vote DOWN]]>
Wed, 23 Sep 2009 20:05:20 +0000