Hello,
First, I tried searching the mysql list archives, but the archive search
function on mysql.com does not seem to be working.
Second, I'm using the PHP fsockopen() function on port 3306 to test if a
database is up and responsive. If the socket opens, I'm assuming the database
is up, and I
I really need some help/direction, so I'll try to explain this as best I can.
I have a PHP script that involves three very long running queries (2-3 minutes
each). The users of my website kick this off from their webpage, so it runs as
"nobody" from inside Apache. In order to prevent a user f
Hello,
I have a query that will be used alot on my website that involves a 42
million record table being self-joined. The primary table instance will be
limited by an index resulting in 1 to about 50,000 rows being selected, then
joined to the second instance of the table, which will retrieve
Very simple question:
Can I use myisamchk version 2.6 (from mysql 4.0.15) to fix/repair a table from
mysql version 3.23.41 (which includes myisamchk version 1.49)??
The reason is that I have more disk space and processing power on a machine
with 4.0.15 installed, but I'd like to rebuild some tab
Environment:
I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium
with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the
kernel to 2.4.20-19.9smp. I've installed the RPM binary distribution of MySQL
4.0.14 right from the MySQL website. The only thi
Thanks for your attention to this problem!
The files are just about 1GB zipped. I'm on a cable modem, so it would take
quite a while to upload these files, but I would be happy to upload them if
helps solve the problem.
Here are the results you requested:
mysql> SELECT COUNT(*) FROM temp_bill_
Here is the resolved stack trace when the FULLTEXT query crahses my server:
0x807474f handle_segfault + 423
0x82a0ad8 pthread_sighandler + 184
0x82ca717 memcpy + 39
0x82891c3 tree_insert + 483
0x827b037 walk_and_match + 231
0x8289956 tree_walk_left_root_right + 78
0x828992c tree_walk_left_root_ri
Oops.. here's the correct command I used to start mysql:
/usr/bin/mysqld_safe --core-file --core-file-size=100 &
It was not started with "--core-file=" as mentioned in my previous note. Sorry.
-Hank
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use w
Sergei wrote:
>How big is your table?
The MYD file is 2,406,292,556 bytes.
The MYI file is 1,381,827,584 bytes.
There are 21,402,554 records in the database.
This table is static (no writers) and ONLY used for fulltext searching on the
"notes" field.
Here is the structure:
+---+-
The explain plan isn't anything I wouldn't ordinarily expect - a full table
scan:
+---+--+---+--+-+--+-+-+
| table | type | possible_keys | key | key_len | ref | rows| Extra
|
+---+--+---+--+--
I have the following SQL. The source table has 8.1 million rows, and the
resulting table will have about 7.9 million rows. I know that's not much of a
decrease, but the logic is correct as I've tested it on smaller sets. The
problem is that when I run with the full set of 8 million rows, it take
Hello,
While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem
to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any
dynamic tables are limited to 4GB in size? My fixed tables do not show this
problem, and report that their Max_data_length is 4+ bill
>[EMAIL PROTECTED] wrote:
>Henry, can you repeat it with binaries from MySQL site?
Unfortunately, no. This database server runs a very high traffic website, so I
can't easily (nor do I want to) start changing the mysql version and causing
alot of (or any) downtime. Except for this random and m
Hello All,
I have mysql 3.23.41 running on a Dell Poweredge 2550 on standard install of
Red Hat 7.2 (2.4.9-21smp). This version of mysql came with Red Hat. It's been
running my website very smoothly for the last few months, and averages 130
queries per second.
Mysql has crashed twice in t
Hello All,
I recently moved my database from mysql 3.22.29 to 3.23.41, and udated all my
tables to MyISAM tables. Under ISAM, I could take the filesize of the ISD
table and divide by the record length to get the exact number of records
returned by "select count(*)" from that table (or vise-ve
data from
> table TBL_FLAT to TBL_INDX.
>
> INSERT INTO TBL_INDX SELECT * FROM TBL_FLAT;
>
> This will be valid in mysql. The insert will be fast since
> only one insert statement. Let the list know if this works
> for you. Or if your method is valid as well.
>
> David
Hello all,
I'm in the process of building a new mysql db server box to migrate a
database off an existing web server. The webserver is running mysql 3.22.29,
and the new box is running 3.23. The two biggest tables are about 20 million
records and the data and index files are each just over 1
I found the problem. My production server is running mysql 3.22.29, and I
needed to use a SET SQL_BIG_TABLES=1 in many places to prevent a "full temp
table" condition. The new server is running 3.23, and once I removed the
SQL_BIG_TABLES=1 from the script (and allowed mysql to use memory instea
Hello Again - I'm posting this again, since it still is an issue that I can
not resolve - please help!
I've recently installed mySQL on a RH7.2 box without any problems - it runs
great. I've been testing some long running queries (full table scans, etc)
under different scenarios, and get wil
Hello All,
I've recently installed mySQL on a RH7.2 box without any problems - it runs
great. I've been testing some long running queries (full table scans, etc)
under different scenarios, and get wildy differing results. Between each test
case, I was flushing all tables and re-starting the
>> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
That suggests using LOAD DATA INFILE, but I would really like to avoid dumping
a very large ISAM mysql table to a text file, just to load it back into another
table (MYISAM).
I was looking for answers as to why isamchk w
Hello,
Under mysql 3.22.29, I was able to use isamchk to disable all index keys (-r
-k0), do millions of inserts into the table, then re-enable all the indexes
again with "isamchk -r -k4" (4 indexes). I'm testing out a new Redhat 7.2
Linux server with mysql 3.23.41, and am attempting to load
Hello,
I am trying to decide which OS to use for a dedicated mysql server for my
website. I need filesize >2GB support. I really wanted to use Solaris, but
there are no drivers for my RAID adapter (long story). I was considering
NetBSD, but I don't know it well. I was then back to thinking
Hello all,
I just ordered a new server to act as a database-only server for my website
(wheresgeorge.com). I'm currently running mysql 3.22.29 (I'm stuck there due
to my web hosting provider). I plan to upgrade to the latest stable version
of mysql, but have the following questions about the
Hello All,
I'm recently back in the job market, and looking for PHP/MySQL contracting
opportunities. Can some helpful people out there please email with good job
sites and/or real headhunters that specialize in this type of work? I've
already exhausted dice.com, guru.com, monster.com, headhun
25 matches
Mail list logo
