> 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
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
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
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
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
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
>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;
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
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
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
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
11 matches
Mail list logo
