It's gives me correct result (integer value 11) on my FreeBSD 3.5, FreeBSD
4.2 and Debian Linux 2.2 Machine
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "MySQL mailinglist" <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 1:15 AM
Subje
If all tables name are unique, and if you can bear the downtime, just shut
down the server and copy the files of one of the database to another
database will do
- Original Message -
From: "Andrew Dennison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 11:21
You've got 1G Ram!
Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which
folder)
- Original Message -
From: "Matis, Jan" <[EMAIL PROTECTED]>
To: "'Sam Wong'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wed
keybuffer=0?
tablecache=0?
For complicated query, Mysql may search the harddisk for stuff again, the it
holds the query for sometimes...and then some more connection come in, as a
result, more ram and cpu is consumed
May I suggest you to lower down the max connection, and tune up the
caching/buff
The I/O may not be as fast as the CPU, so it can't use up the CPU
- Original Message -
From: "Tim Samshuijzen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 11:03 PM
Subject: idle CPU
>
>
> Hello,
>
> We're running a large database on a dedicated server
> So why isn't the --with-raid option set in the binary download version?
The file will be bigger and slower in result
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
blize already, I think.
BTW, why you want it to span over multiple drive?
- Original Message -
From: "Jason Frisvold" <[EMAIL PROTECTED]>
To: "'Sam Wong'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 7:15 PM
Subject: RE:
Compile mysql with --with-raid option, then use symbolic link to link it to
other drive
- Original Message -
From: "Jason Frisvold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 6:33 PM
Subject: MySQL Tables over Multiple Drives
> I looked through the manua
Personally speaking, if the index > 256, it will lost the meaning of
indexing...
- Original Message -
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 3:06 PM
Subject: Re: ERROR 1170: BLOB column 'Url' used in key specification without
If you've upgraded the perl to 5.6.0, you've to reinstall the modules
- Original Message -
From: "Don Hargroves" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 11:15 AM
Subject: MySQL Perl DBI/DBD
> I have followed the instructions at
> http://
I bet your webserver and database server are seperate machine.
Make sure the hostname of web and db are in the /etc/hosts on both machine,
it's very slow to use DNS to resolve everything
- Original Message -
From: "Leonardo Dias" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, J
00 1MB Cache, with 1G ram on board
It's slow because it contains many files. i.e. Reading a big files is always
faster than reading many small files
- Original Message -
From: "Artem Koutchine" <[EMAIL PROTECTED]>
To: "Sam Wong" <[EMAIL PROTECTED]>; &
It's quite fast for tar, just around 10-20 minutes. But it's unacceptable
slow when untar, more than 3 hours! I just want to know if there's any
efficient way to do that...
- Original Message -
From: "Lars Schioler" <[EMAIL PROTECTED]>
To: "Sa
I know this question may not be mysql related, sorry.
I would like to know what's the faster way to duplicate all database to
another machine. I've over 10 tables in each three database, it's very
slow to use cp, and very slow to when untar (over 3 hours!)
Do you have any solution?
Thx in ad
I've heard that redhat 7 is not that good. They implant many beta version
code inside.
Sam
- Original Message -
From: "Mike Tuller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 27, 2001 9:10 AM
Subject: Error 2002: can't connect to mysql.sock
> I recently upgrade
I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon
400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
The traffic of it is about 300 queries/second on average, and keep staying
at around 400 q/s at night.
The problem is that, it core dumps in 5-10 mins, especially at night (high
traf
I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon
400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
The traffic of it is about 300 queries/second on average, and keep staying
at around 400 q/s at night.
The problem is that, it core dumps in 5-10 mins, especially at night (high
traf
17 matches
Mail list logo
