MySQL Forums
Forum List  »  MyISAM

Re: MyISAM only !!
Posted by: Apachez
Date: August 21, 2006 10:20AM

1. You can disable them if you compile it on your own such as:

This has been tested for 4.1.x and optimized for PentiumII cpu:

CFLAGS="-O3 -march=pentium2" CXX=gcc CXXFLAGS="-O3 -march=pentium2 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --without-debug --without-archive-storage-engine --without-geometry --without-berkeley-db --without-csv-storage-engine --without-innodb --without-isam --without-ndbcluster --without-raid --enable-thread-safe-client --enable-local-infile --enable-assembler --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static

2. Named pipes is usually taken care of the api, check the documentation for the api you are using (a common solution is when you connect to localhost pipes will be used while connecting to 127.0.0.1 then tcp will be used).

3. Create proper index for your tables and now and then run OPTIMIZE TABLE specially on tables which changes a lot (like a lot of delete/updates).

Options: ReplyQuote


Subject
Views
Written By
Posted
2358
August 18, 2006 03:28PM
Re: MyISAM only !!
1572
August 21, 2006 10:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.