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 2010, Oracle Corporation and/or its affiliates. Copyright 2010, Oracle Corporation and/or its affiliates. http://mohammadlahlouh.blogspot.com/2010/03/is-mysql-support-julian-dates.html 954 Mohammad Lahlouh mysql Oracle Julian date I use it in Oracle and notice there are 10 days missed, but i didn't see it in MySQL.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Wed, 17 Mar 2010 15:06:31 +0000 http://thinkdiff.net/mysql/how-to-get-rank-using-mysql-query/ 953 Md. Mahmud Ahsan mysql PHP query RANK user rank Some days ago I was working in a quiz project. Where user will play quiz and for each correct answer they will earn points. One of the task of this quiz application was, to get rank of a particular user. Now I am showing how could I solve this problem using mysql query.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Sun, 28 Feb 2010 17:31:48 +0000 http://thinkdiff.net/mysql/getting-rank-today-this-week-and-this-month/ 952 Md. Mahmud Ahsan mysql calculation CURDATE date DATE_SUB month query time today week If you want to retrieve result based on today, this week or this month then you should visit the article to learn the mysql techniques.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Sun, 28 Feb 2010 17:22:11 +0000 http://thetechnib.blogspot.com/2010/02/apache-access-log-mods-redirecting-logs.html 951 Sakila The Librarian Apache mysql logs redirection There are times when you require that your Apache server logs the request made to it, in a customized location. In my case, i wanted it to log all the incoming requests in a MySql database, so i made some experiments based on the things told by many people and yes, finally i got it.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Wed, 24 Feb 2010 07:20:02 +0000 http://mohammadlahlouh.blogspot.com/2010/02/can-i-use-latin1-to-store-utf8-data.html 950 Mohammad Lahlouh mysql charset tuning utf8 latin1 why I need utf8?
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Tue, 23 Feb 2010 11:13:02 +0000 http://www.pythian.com/news/8633/how-to-tell-when-using-information_schema-might-crash-your-database/ 947 Sakila The Librarian mysql Technical Blog crash information_schema MySQL Gotchas optimization performance Pythian There are those that are very adamant about letting people know that using INFORMATION_SCHEMA can crash your database. For example, in making changes to many tables at once Baron writes: “querying the INFORMATION_SCHEMA database on MySQL can completely lock a busy server for a long time. It can even crash it. It is very dangerous.” Though Baron is telling the truth here, he left out one extremely important piece of information: you can actually figure out how dangerous your INFORMATION_SCHEMA query will be, ahead of time, using EXPLAIN.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Tue, 16 Feb 2010 22:13:54 +0000 http://code.openark.org/blog/mysql/to-not-yum-or-to-not-apt-get 946 Sakila The Librarian mysql configuration installation Linux I’ve written shortly on this before. I like yum; I love apt-get; I prefer not to use them for MySQL installations. I consider a binary tarball to be the best MySQL installation format (source installations being a different case altogether). This article explains why.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Tue, 16 Feb 2010 12:05:54 +0000 http://kedar.nitty-witty.com/blog/mydumpsplitter-extract-tables-from-mysql-dump-shell-script/ 943 kedar vaijanaupurkar Technical mysql shell script This shell script will be grabbing the tables you want and pass it to splitted.sql It’s capable to understand regular expressions as I’ve added sed -r option. Also MyDumpSplitter can split the dump in to individual table dumps.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Thu, 11 Feb 2010 11:12:01 +0000 http://kedar.nitty-witty.com/blog/stored-procedure-to-add-remove-prefix-by-rename-table-mysql/ 942 kedar vaijanaupurkar Technical mysql stored procedure Stored procedure to add-remove prefix by rename table
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Mon, 08 Feb 2010 12:06:33 +0000 http://blogs.sun.com/LinuxJedi/entry/mysql_cluster_start_phases 941 Lenz Grimmer mysql cluster startup documentation A description of the MySQL Cluster startup process and its various phases.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Mon, 01 Feb 2010 14:47:57 +0000 http://marcalff.blogspot.com/2010/01/performance-schema-overview.html 939 Giuseppe Maxia mysql performance_schema 5.5 performance monitor monitoring This paper is an introduction to the new 'performance schema' feature, which will be part of the upcoming MySQL 5.5 release. Covering in details every part of the performance schema would require much, much more than a simple article. The pace of this teaser is voluntarily fast, to have a quick overview of the new landscape, and help users already familiar with MySQL to understand by examples what the performance schema provides.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Sat, 23 Jan 2010 03:54:59 +0000 http://www.mysqlperformanceblog.com/2010/01/21/when-should-you-store-serialized-objects-in-the-database/ 938 Sakila The Librarian mysql tips eblob friendly serialize A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the technique has gotten more popular with Ruby gems now around to do this for you automatically. So when is it a good idea to use this technique?
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Fri, 22 Jan 2010 17:45:02 +0000 https://blogs.secondlife.com/community/technology/blog/2010/01/11/diary-of-a-paranoid-mysql-upgrade 936 Lenz Grimmer mysql upgrading update version secondlife lindenlabs Sysadmin Insightful report by Linden Labs (the company behind Second Life) on how they prepared to update their central database from MySQL 4.1 to 5.0.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Wed, 20 Jan 2010 20:52:04 +0000 http://www.pythian.com/news/7129/text-vs-varchar/ 935 Sakila The Librarian mysql Technical Blog data type Pythian storage text varchar On first glance, it looks like TEXT and VARCHAR can store the same information. However, there are fundamental differences between the way TEXT fields and VARCHAR fields work, which are important to take into consideration.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Wed, 20 Jan 2010 20:38:59 +0000 http://datacharmer.blogspot.com/2010/01/multi-dimensional-cubes-in-mysql.html 934 Sakila The Librarian pivot gearman crosstab mysql udf cube perl Sample explanation and code to create data cubes in MySQL using a Gearman UDF and a perl worker. No need to know Perl. This method allows anyone to create crosstabs in SQL, regardless of the programming language used to query the database.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Wed, 20 Jan 2010 05:18:01 +0000 http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server/ 933 kedar vaijanaupurkar Technical mysql load data csv Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost everytime LOAD DATA INFILE come into rescue. In this article we will try to understand some of the very common scenarios for loading data into MySQL Database.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Thu, 14 Jan 2010 14:08:45 +0000 http://www.facebook.com/note.php?note_id=217851170932 931 Wane cooper mysql innodb performance InnoDB at 10,000 IOPS
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Mon, 04 Jan 2010 12:23:41 +0000 http://dev.mysql.com/tech-resources/articles/mysql_55_partitioning.html 928 Giuseppe Maxia 5.1 5.5 mysql partitioning partitions usability The release of MySQL 5.5 has brought several enhancements. While most of the coverage went, understandably, to the semi-synchronous replication, the enhancements of partitioning were neglected, and sometimes there was some degree of misunderstanding on their true meaning. With this article, we want to explain these cool enhancements, especially the parts that were not fully understood.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Thu, 24 Dec 2009 19:53:07 +0000 http://mmatemate.blogspot.com/2009/12/hard-look-into-replication-for-some.html 926 Lenz Grimmer mysql Replication status sarsql Interesting article about some gotchas and things worthwhile knowing about MySQL's built-in replication system.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Tue, 15 Dec 2009 19:25:42 +0000 http://rpbouman.blogspot.com/2009/12/validating-mysql-data-entry-with_15.html 925 Lenz Grimmer mysql Database Stored Procedures signal stored routine trigger A useful introduction to using SIGNAL with triggers/stored routines.
MySQL Librarian Voting: Vote UP / Vote DOWN]]> Tue, 15 Dec 2009 17:52:33 +0000