Skip navigation links
Showing entries 1 to 20 of 462 Next 20 Older Entries
Articles
Add to Favourites +1 Vote Up -0Vote Down
Tags:
(edit) mysql, Oracle, Julian, date
I use it in Oracle and notice there are 10 days missed, but i didn't see it in MySQL.
Articles
Add to Favourites +1 Vote Up -0Vote Down
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.
Articles
Add to Favourites +1 Vote Up -0Vote Down
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.
Articles
Add to Favourites +1 Vote Up -0Vote Down
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.
Articles
Add to Favourites +1 Vote Up -0Vote Down
why I need utf8?
Articles
Add to Favourites +3 Vote Up -0Vote Down
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.
Articles
Add to Favourites +2 Vote Up -0Vote Down
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.
Articles
Add to Favourites +1 Vote Up -0Vote Down
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.
Articles
Add to Favourites +1 Vote Up -0Vote Down
Stored procedure to add-remove prefix by rename table
Articles
Add to Favourites +0 Vote Up -0Vote Down
A description of the MySQL Cluster startup process and its various phases.
Articles
Add to Favourites +2 Vote Up -0Vote Down
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.
Articles
Add to Favourites +0 Vote Up -0Vote Down
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?
Articles
Add to Favourites +0 Vote Up -0Vote Down
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.
Articles
Add to Favourites +3 Vote Up -0Vote Down
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.
Articles
Add to Favourites +1 Vote Up -0Vote Down
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.
Articles
Add to Favourites +2 Vote Up -0Vote Down
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.
Articles
Add to Favourites +0 Vote Up -0Vote Down
InnoDB at 10,000 IOPS
Articles
Add to Favourites +3 Vote Up -0Vote Down
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.
Articles
Add to Favourites +2 Vote Up -0Vote Down
Interesting article about some gotchas and things worthwhile knowing about MySQL's built-in replication system.
Articles
Add to Favourites +3 Vote Up -0Vote Down
A useful introduction to using SIGNAL with triggers/stored routines.
Showing entries 1 to 20 of 462 Next 20 Older Entries