Infobright provides a modern data warehousing solution for MySQL users that combines MySQL’s hallmark ease-of-use with support for terabyte-sized data volumes on a single server. With Infobright, no data warehousing expertise is required to build and manage databases that deliver rapid response times for analytic and business intelligence applications.

We query the data, they often need to specify the return a few lines of data. If there is now a B / S structure of the application, each page may only display the 30 records. In order to improve the efficiency of this time show the general requirements of the database to return only thirty record time…

An introduction to using MySQL, from creating databases to modifying tables to creating and deleting rows.The select query is used to retrieve records from a database. The keywords used in a select query are summarised in the following table.

MySQL parameters we introduced the five categories set up, usually we generally have little touch them, making MySQL performance tuning and troubleshooting when these parameters are still very useful.

Very quickly, another thing that I typically like to do on my server boxes is allow root access to my Mysql database from remote computers. I don’t forward the port through my router and I use a very secure password (doesn’t everyone?).

Mysql multi-table query Left Join and Right Join to Use

There are, however, some special circumstances that do require a little more complex tactics.For example, when handling sensitive data, putting the files into a database gives you a little more control over how the data is handled and who has access to it.This article shows a simple way of putting files into a MySQL table, using PHP.

Tungsten is a family of open source technologies for database clustering and replication. Tungsten includes replication, management, SQL routing, and proxying that improve database availability, protect data, and raise application throughput.

Have developed a video sharing site, users upload videos, using FFmpeg convert. Flv and .3 gp format. web site is very simple procedure, the main task is to configure the video server.Now the video server configuration steps, share out.

Mysql automatic backup script,This script only once a day, and only the most recent five-day backup on the server.

Mysql bin log files to remove the shell script, share to everybody

Recently developed a Web site, it is estimated that the maximum online 30000, up to 100 concurrent. Development site can stand the pressure, how to ensure that there is no problem loading the site, after decisions are as follows…

Mysql slow log to record the execution time is longer (more than long_query_time seconds) a log of the sql tools.

Replication can be suspended for an hour after the restart Replication, Slave to observe how long the data can be consistent with the Master. Replication restart from the Master data and agreed to spend the time and the suspension of time Replication is the ratio of the capacity of Replication.

Oracle introduced a simple optimization techniques, a friend may need help