ERROR 1030 (HY000): Got error 127 from storage engine

! Qunfeng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1030 (HY000): Got error 127 from storage engine

No, I didn't shut down mysqld or read lock. Would you please elaborate it a little more on why? Thanks a lot! Qunfeng At 01:05 PM 5/27/2005, Eric Bergen wrote: Did you shut down mysqld or read lock before copying the table? Qunfeng wrote: Hi, I am running MySQL 4.1.8-Max-log on two Linux

Re: ERROR 1030 (HY000): Got error 127 from storage engine

But while I copied all the table files from A (testing machine) to machine B (real server), no data was writing into A's tables.Are you saying that I have to shut down the mysqld on machine A or activate WRITE lock to A before copying over to machine B? Qunfeng At 02:52 PM 5/27/2005

max_rows with largetext field

those records. Any idea why? Here is my server info $ uname -a Linux machinename 2.4.21-9.0.3.ELsmp #1 SMP Tue Apr 20 19:49:13 EDT 2004 i686 i686 i386 GNU/Linux MySQL version is 4.1.8-standard Thanks! Qunfeng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

myql command-line no warning

Warnings: 2 However, if I put the same command into a file and run mysql command-line, no warning or any message was given. I have no idea if there is anything wrong or how many records got changed. $ mysql -p DB test.sql Is there any way I can show the warning and message? Thanks! Qunfeng

Re: myql command-line no warning

Paul, Thanks for your reply. I tried mysql -p -w DB test.sql still no warning. I tried -vw it simply echo the sql statement, no warning. Qunfeng At 05:45 PM 12/21/2004, Paul DuBois wrote: At 17:43 -0600 12/21/04, Qunfeng wrote: Hi, I am using mysql 4.1 on linux. When I execute an mysql command

Re: myql command-line no warning

:-) I see. Thanks! It w(not vv)orks!!! Qunfeng At 10:48 PM 12/21/2004, Paul DuBois wrote: At 20:44 -0600 12/21/04, Qunfeng wrote: Paul, Thanks for your reply. I tried mysql -p -w DB test.sql still no warning. I tried -vw it simply echo the sql statement, no warning. I didn't suggest using -w

table is full

Hi, I am running 4.1.0-alpha on a linux machine. When I use mysqlimport to load a big data file (~7 Gb), I get an error mysqlimport: Error: The table 'mytable' is full, when using table: mytable. I guess the table is too big. Is there any solution for this problem? Thanks a million! Qunfeng

JOIN columns with different types

Hi, MySQL seems to be able to JOIN columns with different types, e.g., one column type is int; the other type is varchar. My question is: how badly does that affect the join performance even though both columns are indexed. Thanks! Qunfeng -- MySQL General Mailing List For list archives: http

Re: Full text search

full text search is different than pattern match. If you want to return stef, you have to use pattern match. Qunfeng --- Steffan A. Cline [EMAIL PROTECTED] wrote: Am I missing something on mysql full text search? I was using a simple statement like select firstname from contacts where

Re: Pattern Match on 3.23

It can perform pattern match on text field. The only draw back is the speed (especially if you are using %pattern% to do the search) when you tables are getting huge, since there is no index to help. Qunfeng --- Frank Peavy [EMAIL PROTECTED] wrote: I would like to use pattern matching

Re: Pattern Match on 3.23

too bad. Maybe you can still use fulltext search for general cases; and use pattern match ONLY when you are searching for 3-char-term. You should be able to make such Switch through your interface. Qunfeng --- Frank Peavy [EMAIL PROTECTED] wrote: Qunfeng, Thanks for the feedback, I surely

Re: Pattern Match on 3.23

. Qunfeng --- Frank Peavy [EMAIL PROTECTED] wrote: Qunfeng, ..millions of records.. seems like a lot... Would you be kind enough to provide me with your hardware configuration? Thanks. At 07:57 AM 12/31/02 -0800, Qunfeng Dong wrote: If you are searching with %pattern%, your speed

replace ... select (why showing duplicates?)

? They are NOT duplicate because the count(*) with the whereclause returns 0 records before the above replace ... select mysql select count(*) from table2 where clause; +--+ | count(*) | +--+ |0 | +--+ I am using mysql3.23.49 Linux redhat7.3 Thanks! Qunfeng Dong

Re: Missing values

replace missing value (NULL) as \N in your .txt file --- Gianluca Carnabuci [EMAIL PROTECTED] wrote: Hi, I've been trying to import a huge .txt file into a MySql table. In the .txt file, missing values are recorded as empty cells (it might be that there's some hidden character instead, but

Thanks! Re: Can MySQL handle 120 million records? - Ok, If you guys really can handle tens of millions records, you have to help me to enjoy MySQL too :-)

was not all numerical for different type of Sequences; but I managed to assign numerical code to those non-numerical ones now. Qunfeng CREATE TABLE NewSequence ( Seq_ID varchar(50) NOT NULL, GenBank_Acc varchar(10), Organismvarchar(50

RE: Can MySQL handle 120 million records? - Impressive! How do you guys do that?

you spend on fine-tune the performance? Qunfeng --- Peter Vertes [EMAIL PROTECTED] wrote: Hi, I've been using MySQL intercompany for a while now with great results. Even the diehard MSSQL people are amazed at how fast it can be at time. One of the things I use it for is to store

Re: Can MySQL handle 120 million records? - Ok, If you guys really can handle tens of millions records, you have to help me to enjoy MySQL too :-)

NOT NULL, Homolog_Descvarchar(50) NOT NULL, Homolog_Species varchar(50), PRIMARY KEY (Seq_ID, Homolog_PID) ); --- Michael T. Babcock [EMAIL PROTECTED] wrote: Qunfeng Dong wrote: not-so-good performance (join on tables much smaller than yours takes

Re: Can MySQL handle 120 million records? - Ok, If you guys really can handle tens of millions records, you have to help me to enjoy MySQL too :-)

into /etc/my.cnf. Qunfeng --- Michael T. Babcock [EMAIL PROTECTED] wrote: Qunfeng Dong wrote: not-so-good performance (join on tables much smaller than yours takes minutes even using index) and I seem to read all the docs I could find on the web about how to optimize but they are not working

Re: Can not write to a file in /home/.....

chown -R mysql:mysql /home/medic/ and make sure there is no outfile.txt already in that dir. --- sam [EMAIL PROTECTED] wrote: I executed the following statement: SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM fool; I get the error meassge Can't create/write to file

Re: Can MySQL handle 120 million records?

. MySQL seems to store each of its table as single file. You need to choose a file system without that limit. Qunfeng Dong --- B.G. Mahesh [EMAIL PROTECTED] wrote: hi We are evaluating few databases for developing an application with following specs, 1.OS not very important. Leaning

How can I speed up the Left Join on big tables?

| NULL | NULL|NULL | NULL | 2684094 | | | h | eq_ref | PRIMARY | PRIMARY | 50 | s.Seq_ID | 1 | | +---++---+-+-+--+-+---+ 2 rows in set (0.00 sec) Thanks! Qunfeng Dong

Re: How can I speed up the Left Join on big tables?

table create table testTable( Seq_ID char(20), Title varchar(100) ); Qunfeng --- Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] wrote: Qunfeng, A simple left join on two big table took 5 mins to finish. These lines tell about the cause of the problem: | table | type

Re: mailing list problem?

I also got that msg and I did seem to receive all the emails from the list. Qunfeng --- Bill Rausch [EMAIL PROTECTED] wrote: I just got a message from the ezmlm program telling me that the mysql digests have been bouncing and it is going to remove me from the list. In fact, the digests

Re: Tuning MySQL Server Parameter

are varchar(11) and indexed. Table B has about 34,000 records and Table A has about 2,500,000 records. The above query took about 3 hours to finish. Something is just not right. Qunfeng Dong --- David Bordas [EMAIL PROTECTED] wrote: I wish to tune our MySQL Server Parameter to increase the speed

Tuning MySQL Server Parameter

sort_buffer=4M -O read_buffer_size=1M My questions: if I run the above command (as root), should I run it every time when the server starts? If so, how can I set the above option automatically when server starts. Thanks! Qunfeng Dong __ Do you

Re: mysql NULl value in perl problem

Isn't NULL value in MySQL stored as '\N'? If so, you can check that in your perl script. Qunfeng --- David Wu [EMAIL PROTECTED] wrote: Hi guys, Running into a frustrating problem. When I have a empty table in mysql database, i tried run a select statement in my perl script

multiple mysql query in PHP mysql_query?

Hi, Can anybody give me a simple example of using PHP's mysql_query to perform mulitple mysql queries. I am using MySQl 3.23, trying to use create temporary table and insert ... select to overcome the lack of union operation in that verion of MySQL. Thanks!Qunfeng Dong