Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to speed up the MySQL database

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 27-02-2010
Member
 
Join Date: Feb 2010
Posts: 155
How to speed up the MySQL database
  

Hi all,

MySQL the native engine is certainly good enough for us, but in some cases, other engines may be used in hand is more suitable than the job done. I want create my own database engine, like punch through the cylinder fitted with its own carburetor. Now let's want to know that how to choose the engine, and how to switch between the available engines. Please suggest. Thanks in advance.

Reply With Quote
  #2  
Old 27-02-2010
Member
 
Join Date: May 2008
Posts: 2,012
How to speed up the MySQL database

You can use the MySQL database engine depends on how the time of the installation was compiled. To add a new engine, you must re-compile MySQL. Just to add a feature and compile apply the concept of process Windows Developers who may be very strange, but in the Unix world, it has become the standard. By default, MySQL supports three engines: ISAM, MyISAM, and HEAP. The other two types of InnoDB and Berkley (BDB), also often can be used. All the best.
Reply With Quote
  #3  
Old 27-02-2010
Member
 
Join Date: Apr 2008
Posts: 2,005
How to speed up the MySQL database

ISAM is a well-defined and the data tables after the test of time management method, it design the time to consider the number of queries to the database have been updated to be much larger than the number of times. Therefore, ISAM implementation of the fast read operations, but do not take up a lot of memory and storage resources. ISAM two main shortcomings is that it does not support transactions, nor can it fault-tolerant. If your hard drive crashes, then the data File can not be restored. If you are the ISAM used in mission-critical applications where, it must always back up all of your real-time data replication, through its properties, MySQL can support such a backup application.
Reply With Quote
  #4  
Old 27-02-2010
Member
 
Join Date: May 2008
Posts: 2,297
Re: How to speed up the MySQL database

You can use MySQL + + to create your own database engine. This API gives you the operation fields, records, forms, databases, connectivity, security, account features, and the establishment of such a DBMS such as MySQL need all the other numerous features. API has been explained in depth beyond the scope of this article, but you need to know about the existence of MySQL + + and its exchangeable engine, the technology behind it and this is very important. It is estimated that the model of plug-in database engine or MySQL can be used to create a local XML provider. All the best.
Reply With Quote
  #5  
Old 27-02-2010
Member
 
Join Date: Oct 2005
Posts: 2,393
How to speed up the MySQL database

InnoDB and Berkley DB database engine is the flexibility to create MySQL Technology Direct products, this technology is that MySQL + + API. The use of MySQL, you are facing almost every challenge from ISAM and MyISAM database engine does not support the transaction does not support foreign keys. Although slower than the ISAM and MyISAM engine, a lot, but the InnoDB and BDB includes a transaction processing and foreign keys to support them, are the first two engines do not have. If you need these features in the design of a person or both, then you have to be forced to use after only one of two engines. Check and reply.
Reply With Quote
  #6  
Old 27-02-2010
Member
 
Join Date: May 2008
Posts: 2,389
How to speed up the MySQL database

HEAP is also allow to reside in memory temporary table. Reside in memory for HEAP faster than the ISAM and MyISAM, but it manages the data is unstable, and if not carried out prior to the shutdown to save, then all data will be lost. In the data row is deleted when, HEAP will not waste a lot of space. HEAP forms you need to use the SELECT expressions to select and manipulate data on the time very useful. Remember to delete the run out table after table. Let me repeat: after you run out of form, do not forget to delete the form. Check and reply.
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to speed up the MySQL database"
Thread Thread Starter Forum Replies Last Post
How to connect PHP to mySQL Database Nathen Tips & Tweaks 2 17-07-2011 03:49 AM
Connecting C# with MySQL database Quattro Software Development 5 05-03-2010 10:13 PM
mysqldump in MySQL database Caden Fernandes Software Development 4 04-03-2010 11:02 PM
Postgresql vs Mysql database Xmen Software Development 4 04-03-2010 10:11 PM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM


All times are GMT +5.5. The time now is 03:10 PM.