RE: run-all-tests always fails under reiserfs partition
Hi~: I do use a via chipset mother board. Today I tried the option notail, it really works!!! Thanks :) Julian PS: Do you have any idea about sgi's xfs? >From: George Eric R Contr AFSPC/CVYZ <[EMAIL PROTECTED]> >To: Z Julian <[EMAIL PROTECTED]>, [EMAIL PROTECTED] >Subject: RE: run-all-tests always fails under reiserfs partition >Date: Thu, 8 Nov 2001 16:16:15 - > >FWIW, I'm not convinced reiserfs is ready for prime time, at least not on >all hardware (Any chance you're running a Via chipset MB?). I've had some >serious stability problems when trying out reiserfs that magically >disapeared when I went back to ext2 (and now ext3). > >One thing that I've heard helps is to set the notail option when mounting a >reiserfs partition. > > >-Original Message- >From: Z Julian [mailto:[EMAIL PROTECTED]] >Sent: Thursday, November 08, 2001 1:16 AM >To: [EMAIL PROTECTED] >Subject: run-all-tests always fails under reiserfs partition > > >Hi~: >My OS is RH7.1 with kernel version 2.4.2-2. >Yestoday I upgraded my kernel to 2.4.14 with configuring it to support >reiserfs as build-in capability. After that I created a reiserfs partition >and mounted it successfully. Everything seemed to be OK. >Then I installed mysql and located the install directory to the reiserfs >partition. Mysqld started. OK again. >And then I entered the /reiserfs/partition/mysql/sql-bench directory to run >the perl script "run-all-tests", things turned to be weird. I got the >following display: > >* >[root@server sql-bench]# ./run-all-tests --server=mysql >Benchmark DBD suite: 2.13 >Date of test:2001-11-08 15:33:30 >Running tests on:Linux 2.4.14 i686 >Arguments: >Comments: >Limits from: >Server version: MySQL 3.23.41 > >ATIS: Total time: 49 wallclock secs ( 7.95 usr 1.67 sys + 0.00 cusr 0.00 >csys > = 9.62 CPU) >alter-table: unable to handle kErneL paging request >** > >and the machine freezed. >I tries several times, every time I got different result. Sometimes the >kernel infomation displayed, such as register value, stack info and etc. >Sometimes the machine auto rebooted. And sometimes my machine turned to be >a ambulance and made terrible noises. But there is not a single time the >tests finished successfully. > >Once I recovered the partition to ext2 file system. All those problems >vanished and tests finished successfully. > >What's wrong? > > Confused Julian > > >_ >Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail mysql.com> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Ask for Linux+MySQL installation help
try to copy mysql libraries to /usr/local/lib and /usr/lib cp -a /usr/local/MySQL/lib/MySQL/* /usr/local/lib cp -a /usr/local/MySQL/lib/MySQL/* /usr/lib >From: "YANG" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Ask for Linux+MySQL installation help >Date: Fri, 2 Nov 2001 13:43:46 +0800 (CST) > >Dear Sir: > I want to ask some questions about Redhat Linux+MySQL installation. >1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43. Commands is as follws: ># cd /usr/local ># tar ¨Czxvf MySQL-3.23.443.tar.gz ># mv MySQL-3.23.43 /usr/local/MySQL ># cd /usr/local/MySQL ># ./configure ¨Cprefix=/usr/local/MySQL ># make ># make install >Instalation Success; >2. Then, I write a small program test.c to test the mysql database C API. The makefile is as follows: ># gcc ¨CI/usr/local/MySQL/include/MySQL ¨Cc test.c ># gcc ¨Co test test.o ¨CL/usr/local/MySQL/lib/MySQL ¨Cl/MySQLclient >Compile and link all success; >3. But, when I run the program, error occurs. Error message is as follows: ># ./test: error in loading shared libraries:libMySQLclient.so.6 cannot open shared object file: No such file or directory >4. I install MySQL Rpm Package in another computer. The version of Redhat Linux and MySQL is same as that mentioned previously. Instalation command is as follows: ># rpm ¨Ci MySQL-3.23.43-1.i386.rpm MySQL-client-3.23.43-1.i386.rpm MySQL-devel-3.23.43-1.i386.rpm MySQL-shared-3.23.43-1.i386.rpm > I compile and link it with same makefile. This time, everything is OK. > Because I want use Linux+MySQL+Apache+PHP in our system, I want install MySQL database with the first method. So I ask for helping as soon as possible. Thanks. > >My E-mail address is: [EMAIL PROTECTED] > > > > > > > _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
journaled file system
Hi~ I want to use journaled file system on my computer. Can you give me some advice? Furthermore, could journeled file system improve the performance of mysql? If yes, which journeled file system is better for mysql? Thank you~~ :) Julian _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Auto reconnect in application?
Hi~ I have a question. If I do nothing after I use mysql C API to connect to mysql server, how long the connection will be kept? If there is a time limit, what will happen if I execute some queries when the time is out? Will the API function like mysql_query () reconnect to the server and execute the queries automatically like the mysql client does? Thanks. :) Julian _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: high speed insertion required
Hi Mark: "insert delayed" helps little. I think there are two reasons. 1. One reason "insert delayed" speeding up insertion is that the client will return immediately after it issues a "insert delayed" query. I think all those inserts must be stored in a delayed queue and will be executed whenever it is possible or necessary. But since the delayed queue can't hold too many inserts and my program inserts data at a steady and high speed and will run for a long period of time (couple of days or maybe weeks), the queue will be full inevitably. And after the queue is full, I think no inserts can be delayed any longer. At that time, the insertion speed of my program will low down to the normal speed as insertion without "delayed" option chosen. 2. Another reason "insert delayed" speeding up insertion is that inserts from many clients are bundled together and written in one block. But on my server there are no other clients. So the insertion of my program can't be accelerated in this way neither. >Disable or remove indexes. This sometimes speeds it up tremendously >depending on your indexes. Well, index... I do have some indexes in the tables, but I can't give them up because those tables will be accessed at any time during the insertion. >Is the hash table in the same server/database? The hash tables are in the same database. Well, I think maybe I should face the reality, maybe my program has already tried its best, and so have we(us? hehe, poor english :). Any way, thanks for your help. >From: "Mark Rissmann" <[EMAIL PROTECTED]> >To: "Z Julian" <[EMAIL PROTECTED]> >Subject: Re: high speed insertion required >Date: Thu, 13 Sep 2001 11:14:26 -0700 > >I use Delphi and am having a similar problem. But here are some things that >can be done (that I haven't tried). > >INSERT DELAY -- this is supposed to help because my SQL will recognize a >group of inserts into a table and queue them. This should be faster. You'll >have to experiment on how long you allow the queue to build. > >Disable or remove indexes. This sometimes speeds it up tremendously >depending on your indexes. > >Is the hash table in the same server/database? > >Please post your findings to the listserver. Let me know if this works or if >you have any more questions. > >Mark Rissmann >-Drifting Sands LLC > >- Original Message - >From: "Z Julian" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Thursday, September 13, 2001 1:24 AM >Subject: Re: high speed insertion required > > > > Hi: > > Thanks for your reply. :) > > I write that program in C. I get data from a mysql heap table which is >always full of records. That's why I use queries like "insert into table1 >select from table2" to insert data. Obviously table2 is the heap table I >mentioned above. > > I use that program to do some log jobs. Someone tells me to use "insert >HIGH_PRIORIRY" to speed up the insertion, but I think that helps little >since there are no other database clients running on my machine except the >one which fills the heap table for my program. > > Do you have any suggestion? Please mail. Thank you and have a nice day! :) > > > > >From: "Mark Rissmann" <[EMAIL PROTECTED]> > > >To: [EMAIL PROTECTED] > > >Subject: Re: high speed insertion required > > >Date: Thu, 13 Sep 2001 01:02:31 -0700 > > > > > >Hello, > > > > > >What development tool are you programming in? Where are you getting these >records from? > > > > > >Have you received any good tips? > > > > > >Mark Rissmann > > >-Drifting Sands LLC > > > > > > > > > > > >"I do not fear computers. I fear the lack of them." - Isaac Asimov > > > > _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
high speed insertion required
Hi everyone~~ I have a program inserting data into myisam tables continuously by queries like "insert into table1 select * from table2". I need an insertion speed about 1,000 entries per second with the average entry length of about 50 bytes. But the actual speed of the insertion is only about 450 entries per second. If I comment the code doing insertion, the program can reach a speed about 1600 entries per second. So is there any way to tune mysql to improve the insertion speed ? Thanks! :) _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
