Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.18-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql> LOAD DATA INFILE "Orders.txt" INTO TABLE Orders3 fields terminated by '\t';
ERROR 1045: Access d
With LOCAL, the *client* reads the file on the client's machine. Without
LOCAL, the *server* reeads the file on the server's machine. Even though
the client and server machines are the same in your case, those are still
different operations. There are restrictions on having the server do the
Mysql uses multiple-column indexes from left to right. Multiple-column
indexes are most effective when the column with a range criteria comes as
far to the right as possible. Think of the index as sorting your data into
a book where the first column is the chapter, the second column is the pag
Really? I had no idea. I am pretty sure that only Day will have a range.
Our index is currently, (yearmonth, day, stem_base), so I need to drop
and recreate it.
I think part of the slowness is the size of the table as well. We have
data going back years in there. I am thinking about breaking th
>Description:
When I start up my fresh compiled mysqld it crashes immediately, the error log file
says:
040801 00:07:28 mysqld restarted
040801 0:07:29 Warning: Can't open time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without them
mysqld got signal 11;
I just discovered that two of my tables (out of about 300)
show a very unusual behavior. This is that "select count(*) ..."
and selecting all the rows and counting them do not produce
the same number.
This is on MySQL 4.1.3 on Solaris9. Look at this:
$ mysql -e "select count(*) from pstat.plist
On Sat, 31 Jul 2004 17:50:38 -0500, Keith Thompson <[EMAIL PROTECTED]> wrote:
> I just discovered that two of my tables (out of about 300)
> show a very unusual behavior. This is that "select count(*) ..."
> and selecting all the rows and counting them do not produce
> the same number.
>
> This
Hi Marc,
Thanks for you response. In answer to your questions, there are no
embedded newlines and I did look at index issues. I did not try
rebuilding the index, which would be easy to do in this case since
the tables are small (unlike a couple of my other tables that have
125+ million rows and
At 07:07 PM 7/31/2004, you wrote:
Hi Marc,
Thanks for you response. In answer to your questions, there are no
embedded newlines and I did look at index issues. I did not try
rebuilding the index, which would be easy to do in this case since
the tables are small (unlike a couple of my other tables
Thanks Mike,
I've always ignored CHECK TABLE because I always thought it was
just for MyISAM.
I ran CHECK TABLE. It told me that my table was corrupt. I then
dumped the table with mysqldump and recreated it. After that
CHECK TABLE said it was OK (and in comparing values with the master
server
> I have several MySQL and FreeBSD installs across a few different sites, and
> I consistently have problems with mysqld. It will begin to eat up all of the
> CPU and eventually become unresponsive (or the machine will just burn). I
> can't seem to manually reproduce this, but given enough time a F
11 matches
Mail list logo
