AM tables" - do any of the other table types
(InnoDB, Falcon, etc) behave differently?
Thanks,
JW
--
--
System Administrator - Cedar Creek Software
http://www.cedarcreeksoftware.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
On Friday 09 May 2008 04:32:10 pm Saravanan wrote:
> --- On Sat, 5/10/08, JW <[EMAIL PROTECTED]> wrote:
> > From: JW <[EMAIL PROTECTED]>
> > Is it correct that mysql 5.0 is threaded in such a way that
> > a DB server taking lots of queries from many clients wil
res a waste?
Thanks,
JW
--
--
System Administrator - Cedar Creek Software
http://www.cedarcreeksoftware.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I assume these are not 64 bit CPUs.
Any idea how I can configure this server to maximize performace?
I think the multiple CPUs are a waste: I'm not looking for lots of
concurrency, I want 1 query done really fast.
Thanks.
JW
--
--
System Administrator -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey,
At various places on the MySQL web site there's mention of 3.23.50 and 3.23.51, and
the new autoextend feature.
However, the most recent on the download page is 3.23.49a.
Was .50/.51 not released because of bugs or something?
- --
- -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
Some time ago I set up a rather large mySQL server with InnoDB and had a hard time
customising my.cnf.
At the time there was some discussion of createing a tool that someone could enter
their hardware info into and get a customised configur
y.
Started it back up, it took a _very_ long time recovering (InnoDB), then started in
with the error message I first posted.
Any ideas? I'm currently restoring from backups we'll see how it goes.
Thanks.
JW >I forgot to point out that this is InnoDB
JW >
JW >I'
Max-3.23.44-5
mysql-devel-3.23.44-5
mysql-navigator-1.2.3-106
mysql-client-3.23.44-5
mysql-3.23.44-5
mysql-bench-3.23.44-5
ccs012:~ #
This is a mission critical DB. Am I the lucky un-fortunate to re-dicover this
supposedly fixed bug?
JW >I'm getting this error messge constantly in my er
020406 18:02:50 ***
I'm getting this error messge constantly in my error log:
InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (200 search iterations)! Consider
InnoDB: increasing the buffer pool size.
InnoDB: It is also possi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
DN >In the last episode (Apr 04), JW said:
DN >Heh. plus the maintenence nightmare of managing 48 servers, 96 mirrored
DN >boot disks, 96 power supplies, etc etc..
DN >
DN >A comparable system to the Dell link you pasted is the Su
On Thursday 04 April 2002 09:48 am, you wrote:
> I think you'll find that the RISC systems have fewer processors and run at
> lower clockspeeds for the same total performance. 100k is a HUGE amount of
> money to drop on a system. You could get 2 full racks of high performance
> 1U systems, includi
d.
We're not done growing yet either...
JW
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Trying to send this again... SPAM filter messing with me...
"this is a query about what hardware might make for a really good sql server"
There :-p
>Hello,
>
>I need some advise.
>
>We are about to purchase a huge system for use as a DB/web application server (mostly
>DB).
>
>I'd like to point
Hello,
We're been running a pretty large MySQLd with InnoDB support, last night it
crashed on us in the middle of the night. I have never sent in a bug report
like this before so please give me a little slack. I do not have any clue as
to what actually caused the crash, I only have the logs an
At 12:22 PM 1/30/2002 -0600, you wrote:
>I sent a reply back to JW about his problem on performance tuning and came up with I
>thought a really good idea. But there weren't any bites so I thought I start it on a
>new thread.
I'd like to point out that I'm pretty sure
M
[myisamchk]
set-variable = key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[mysqlhotcopy]
interactive-timeout
#
# Added by JW 2002-01-26 per MySQL manual.txt suggestion
#
[safe_mysqld]
open-files-limit=256
TIA for any
At 08:27 AM 12/11/2001 +0200, you wrote:
>Hi!
>
>I do not understand how replacing just the executable mysqld can make your
>'mysql start' (or is it 'mysql.server start'?) script or safe_mysqld script
>to search the executable from a different directory than it did before.
I do not understand it
Hello,
We're needing to use MySQL-Max because we need the functionality provided by InnoDB.
According to InnoDB's web site, all I have to do is download the tarball and replace
the /usr/sbin/mysqld with the mysqld in the tarball.
I tried that on SuSE and I had to install a few other things and
Ah, I finally found mention of this in the manual.
Sorry to bother everyone.
Thanks.
---
Hello,
To use InnoDB you have to put how large of a file MySQL is allowed to make by putting
an entry in /etc/my.cnf such as the one I used:
innodb_data_home_dir =
Hello,
To use InnoDB you have to put how large of a file MySQL is allowed to make by putting
an entry in /etc/my.cnf such as the one I used:
innodb_data_home_dir = /var/lib/mysql/innodb
innodb_data_file_path = indb1:200M;indb2:200M
that of course gives us 400M total.
I have not yet found in t
Well, I got around the problem by replacing the old mysql/english directory with a new
one from the tarball. I hope that was an o.k. thing to do.
At 04:35 PM 12/5/2001 -0600, you wrote:
>Using mysql-3.23.33-4 on SuSE Linux 7.1:
>root@fluorite:/usr/sbin > uname -a
>Linux fluorite 2.4.0-64GB-SMP
Using mysql-3.23.33-4 on SuSE Linux 7.1:
root@fluorite:/usr/sbin > uname -a
Linux fluorite 2.4.0-64GB-SMP #1 SMP Wed Jan 24 15:52:30 GMT 2001 i686 unknown
We've been using MySQL for a while and we're trying to test InnoDB. According the
InnoDB page all we need to do is untar the package and ove
22 matches
Mail list logo
