On Fri, Sep 12, 2003 at 09:58:03AM +0200, Lenz Grimmer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
(please Cc: me directly, if you want to catch my attention - I don't
always follow this list very closely)
Oops. Good point.
It's always felt like FreeBSD became a
On Thu, Sep 11, 2003 at 09:29:27AM -0700, Mark Kaufer wrote:
I've looked and looked but really can't find an answer to this question.
In my my.cnf file, these are some of the things that are specified in
[mysqld]:
set-variable = key_buffer=256M
set-variable = table_cache=64
set-variable =
On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote:
Linux reports the threads of a process as processes. You really only
have one process, with 31 threads. (Probably because a bunch of clients
have connected.) So your resources are shared among the threads of
the server process.
On Thu, Sep 11, 2003 at 11:30:20AM -0700, Mark Kaufer wrote:
By the way, Jeremy's original answer was more correct than mine, because
he noted where I did not that the sort buffer is a per-client resource
and is allocated once for each client -- or at least for each client that
issues
On Thu, Sep 11, 2003 at 02:30:59PM +1000, Daniel Rossi wrote:
when is it a good time to do the set auto commit=0 , while doing the
update or insert query or sometime before that in the application ?
Whenever you need explicit transactions.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux
On Thu, Sep 11, 2003 at 04:10:21PM -0400, Pierre-Luc Soucy wrote:
Hi again,
Does any of you have an idea on this? I get the same error in 4.0.15. I
could find that the problematic code was in mysql-test/mysql-test-run.sh:
sleep_until_file_created $MASTER_MYPID $wait_for_master
On Thu, Sep 11, 2003 at 10:08:18AM -0400, Luc Foisy wrote:
Are there packages for java to include a standalone mysql database?
No.
Or are there plans for such?
Last time I saw Mark discuss it, no. There was significant overhead
in coming up with a Java-to-embeeded-MySQL bridge. Check the
On Thu, Sep 11, 2003 at 03:41:21PM -0700, [EMAIL PROTECTED] wrote:
Ok, here's another question. Given effective external locking by the OS, could
MyISAM tables achieve this?
Yes.
If so, do you know any operating systems that would have reliable
external locking?
I'm not sure what the
On Thu, Sep 11, 2003 at 10:22:13AM -0400, Peter Koutsoulias wrote:
I couldn't find an appropriate mailing list for compiling MySQL, so I
thought I'd try here.
anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
libmysql.c during the make step. Google doesn't reveal a
On Thu, Aug 28, 2003 at 04:20:50PM -0400, Nick Gaugler wrote:
Ken,
Thanks for the response. I really wish MySQL AB would compile FreeBSD
binaries with LinuxThreads. It's really a pain when you find a bug, the
first thing they ask is have you compiled this yourself when in this
case you
On Thu, Sep 11, 2003 at 04:27:10PM -0400, Brent Baisley wrote:
Have tried using the --opt parameter on mysqldump? This is supposed
optimize the dump speed and create a file optimized for reloading. I
haven't played with this option, so I don't know what kind of
difference it makes.
It
improperly shut down
- threads are not being killed off
Pattern emerged:
High Traffic DB up for a month or greater doing a constant 300
queries/sec
Question: What is the cause of a Record-file crash? How can this be
prevented? Jeremy Zawodny do you have any thoughts on a root cause
On Wed, Sep 10, 2003 at 11:01:00AM -0700, Dathan Vance Pattishall wrote:
Well I don't feel that 4.0.x is mature enough for my environment quite
yet, although some replication features are actually needed (2 threads
are better then one).
I might do a small deploy for some search system and
On Wed, Sep 10, 2003 at 11:50:43AM -0700, Bill Todd wrote:
Using MySQL and InnoDB, are there system tables or other tools that I can
use to see which statements that are executing have consumed the most CPU
time and find out which user, transaction and/or connection those statements
belong to?
On Tue, Sep 09, 2003 at 01:30:51AM -0500, Matt W wrote:
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 1 days, processed 47,861,708 queries (374/sec. avg)
Off topic: Been wondering about
On Tue, Sep 09, 2003 at 02:56:56PM -0700, [EMAIL PROTECTED] wrote:
This seemed like an ideal case to DISABLE KEYS, insert the data and
then ENABLE KEYS based on the MySQL documentation. And running some time
tests proves that this approach runs much faster.
However, in doing so, the log
On Mon, Sep 08, 2003 at 03:26:34PM -0700, Bill Todd wrote:
What transaction isolation level(s) does BDB support? I can't find any
information on BDB transactions section 7.6 of the manual.
BDB only does READ COMMITTED.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,
On Mon, Sep 08, 2003 at 10:42:33PM -0500, Paul DuBois wrote:
See:
http://www.mysql.com/doc/en/System.html
Note the part about Linux.
Paul, you might update that page. It's extoling the virtues of the
2.2 kernel and SMP. But 2.4 is clearly superior in that department.
And the 2GB file
On Tue, Sep 02, 2003 at 10:23:42PM -0400, Adam wrote:
Anyone ever get super-smack to compile on this system?
I get tons of warnings/errors that look like syntax errors almost. Not
sure what I am doing wrong.
Funny you mention that. I'm about to post version 1.2 that may work
for you.
Stay
On Sun, Aug 31, 2003 at 12:02:20AM -0400, K Old wrote:
I ran across this tool the other day and it is awesome. Basically it is
like the top utility for *nix, but it's for mysql. It basically gives
you a live look into the database and what queries it's processing, etc
in real time.
Glad
On Sun, Aug 31, 2003 at 07:14:12AM -0400, Albert wrote:
Can this tool be used on Windows and if so what version do I need to DL and
does it need anything else besides the software (e.g. Perl - which I see
listed for the nix versions.
When I last had a Windows box at work, mytop worked with
On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote:
So, we have a webmail application that uses a mysql server for holding
it's session information. Obviously this causes many
reads,updates,inserts, and deletes to happen. Here are my lock
statistics.
| Table_locks_immediate|
show your key
buffer hit percentage:
http://jeremy.zawodny.com/mysql/mytop/
See the sample my.cnf files that come with MySQL. One of them will
likely be a good starting point for you.
Jeremy
On Tue, 2003-09-02 at 10:50, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 10:37:34AM -0700, James
On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote:
Whoa, ok. Sorry. I didn't read the questions about the data and index
files. I'm, uh, not exactly sure how to tell that, can you give me a
hint there as well? *look sheepishly around*...
Sure.
First you need to figure out where
On Tue, Sep 02, 2003 at 11:45:21AM -0700, Mark wrote:
Hi,
I'm having problems with a fulltext indexed table where it takes a
long time return from a query where many rows match. I noticed that
when I run a query like
select count(*) from table where keywords like '%x%';
it takes a long
On Tue, Aug 26, 2003 at 07:38:04PM -0600, Twibell, Cory L wrote:
All,
I have a query that is inner joined with another table based on
country codes Select distinct Name.* from Name inner join Location
on Location.key = Name.key and Location.cc in ('list of countries
here');
The problem
On Tue, Aug 26, 2003 at 04:18:26PM +0200, Stefan Kuhn wrote:
Hi everybody,
I want to establish replication between multiple (currently three)
servers. Updates/inserts/deletes may happen on all of them. The
idea I came up with was to do a circle-replication. The problem
with this is, that if
On Sun, Aug 24, 2003 at 02:45:01PM -0400, Eric Frazier wrote:
Hi,
That makes a lot of sense, in fact we are using two servers as
Masters replicating to each other in a circle, but one has an
extra slave which is in our office. So in effect that does what this
guy was looking for, without
On Sun, Aug 24, 2003 at 09:03:16PM +, [EMAIL PROTECTED] wrote:
Hi,
I am running MySQL V4.0.14 with replication.
I want to replicate specified databases from 2 different masters into one
slave. Is this possible?
No.
A slave may only have one master.
--
Jeremy D. Zawodny |
On Sun, Aug 24, 2003 at 02:02:06PM -0400, Eric Frazier wrote:
Sounds very biblical. :)
Yeah, I have it etched on a pair of stone tablets around here
somewhere... :-)
Wouldn't there be a way to do this with two copies of mysql that
share a common data dir?
Maybe. But that's not what he's
On Fri, Aug 22, 2003 at 10:55:49AM +0530, Rupak Banerjee wrote:
Hi,
We are using MySql version 3.27.53 on a Red Hat Linux platform version
7.2. For the past couple of months we are noticing that the performance
of the server has gone down very badly. Every, single insertion is
taking a
On Fri, Aug 22, 2003 at 09:20:08AM -0500, Christensen, Dave wrote:
This may seem like a stupid question, but I haven't been able to track down
an answer yet. We're going to try to access a remote MySQL server that is
protected behind a firewall. I know that we need to open a port, such as
On Thu, Aug 21, 2003 at 01:03:16AM +, gord barq wrote:
I have this query which does a left outer join and it takes forever (like
half a day). Here are the results of an explain analysis.
mysql explain SELECT count(searchresult.title) AS number,
campaigntrack.title, tracknum, trackid
On Wed, Aug 20, 2003 at 10:41:54PM -0500, Dan Nelson wrote:
In the last episode (Aug 20), Michael S. Fischer said:
In a word, no. The way MySQL organizes its datafiles is trivial by
comparison: one directory per database, two files per table (table.MYI
and table.MYD), one is the datafile,
On Tue, Aug 19, 2003 at 01:52:26PM -0700, Sanya Shaik wrote:
I am unable to find any information about master-master replication. I
need to replicate 1 mysql server over to other as a standby master
server.
If the second server is merely standby, you probably want master/slave
rather than
On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon Miller wrote:
We've run out of disk space and would like to move either the entire
MySQL system or if possible move the databases. Can this be done
without any difficulties?
Yes. If you're on a Unix-like platform, you can symlink one or more
On Tue, Aug 19, 2003 at 04:10:12PM +1000, Chris Nolan wrote:
Thanks. :-)
On another note, do you automate your sig in some way?
Yup, I use mysig:
http://jeremy.zawodny.com/mysql/mysig/
But I havne't posted the code yet. Hmm. I've been meaning to do that
for about a year now. Bug me
On Mon, Aug 18, 2003 at 02:33:04PM -0500, Miguel Perez wrote:
I have an ibdata file that its size is 4.5GB, and it will increase
every day the max size of the hard disk is about 330GB, the question
is should I split this ibdata file in several files in a way that I
can reach this size?
Does
On Tue, Aug 19, 2003 at 09:12:03AM -0400, Jason McCormick wrote:
Hello all,
Sorry to post this again, but I go not response and was really hoping
someone can help me as this is a mission-critical problem.
Please don't take this the wrong way, but mission-critical problems
should be sent
On Tue, Aug 19, 2003 at 02:51:28PM -0400, [EMAIL PROTECTED] wrote:
I am having another problem with replication in mysql 4.0.13. The
slave server crashed and upon re-starting there was a new relay-bin
log file created and the old relay-bin log file remained.
Right. It needs to finish with
On Mon, Aug 18, 2003 at 10:41:55AM -0700, [EMAIL PROTECTED] wrote:
Hello,
I just have a question about the table locking in 3.23.56. If I am inserting a
row into a table that is MyISAM type, is the entire table locked?
Yes.
And, if so, what does this mean for concurrent selects?
An
On Mon, Aug 18, 2003 at 11:15:31AM -0700, [EMAIL PROTECTED] wrote:
I could fix this if I changed the table type to InnoDB, correct?
Yes.
InnoDB uses a very different locking model. You'll get very good
read/write concurrency with InnoDB.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL,
On Mon, Aug 18, 2003 at 12:10:16PM -0400, Tom Mattison wrote:
Greetings List,
I'm running a dedicated MySQL server on a Dell PE 2550, dual proc. 4GB
RAM. Its using the Dell PERC 3/Di Scsi RAID controller with 18GB disks. I
running RH 7.3 with the latest updates(Kernel 2.4.20-19.7smp).
On Mon, Aug 18, 2003 at 01:34:59PM +0100, Andrew Braithwaite wrote:
Hi All,
I have a database with many files in it and our research tells us that
disabling the recording of atime (access time) for that DB may have
significant performance improvement.
2 questions:
1. Has anyone done
On Mon, Aug 18, 2003 at 09:42:51AM -0500, mos wrote:
External RAM disks that are around 8g are extremely
expensive. Some have built in in battery protection and operate
independently from the OS so if the OS reboots, you still have your data. A
couple of years ago I priced these
On Mon, Aug 18, 2003 at 10:30:31PM +0200, Jan Josefowicz wrote:
Hi all,
I get following output from mysqlbinlog mylog-bin-file.001:
# at 4
#030818 13:38:00 server id 1 Start: binlog v 4, server v created
700101 1:00:00
The file mylog-bin-file.001 contains many queries but
On Mon, Aug 18, 2003 at 11:53:29AM -0700, Michael S. Fischer wrote:
I'm using MySQL 4.0.13 for a web application, and one of my queries
is sufficiently complex such that it might take several seconds to
return the results to the user. I'd like to return a please wait
page if the query is not
On Mon, Aug 18, 2003 at 04:51:17PM -0700, Michael S. Fischer wrote:
Jeremy Zawodny writes:
Perhaps you could tell us more about the queries that take
too long. Maybe there are some things you can do to reduce that time?
You don't want to go there.
But because you do... :-)
Uh oh
On Fri, Aug 15, 2003 at 03:45:40PM -0700, Dathan Vance Pattishall wrote:
Replicating queries where re-written to fix various bugs, most notably
time and auto-increment bugs.
Hm? I didn't quite pars that sentence.
Why doesn't replication also enforce rewriting INSERT INTO into
INSERT
On Mon, Aug 18, 2003 at 04:09:01PM +1000, Chris Nolan wrote:
Hi all,
I was wondering, does anyone know if there are any plans to add FULLTEXT
indexes to the almighty InnoDB such that it catches up with the funky
MyISAM in terms of things you can pass to ALTER TABLE?
If you check the list
On Mon, Aug 18, 2003 at 04:14:21PM +1000, Chris Nolan wrote:
Hi all!
Currently, one of my clients has a MySQL+InnoDB database that they use for
storing stuff. My question is, even though I know it will take more time
and will slow down operations for everyone, will mysqldump with the single
On Thu, Aug 14, 2003 at 11:35:18AM -0700, Jennifer Goodie wrote:
Setting skip-name-resolve will avoid this code path and the bug. It
looks like some DNS funkyness...
I've implented this and so far I can't get the box to hang in authentication
no matter how mean I am to it. I feel so
On Wed, Aug 13, 2003 at 09:54:51PM +, Michael Welsh wrote:
On Wednesday 13 August 2003 02:11 pm, Matthew McNicol wrote:
see section '4.8.2 mysql, The Command-line Tool' in the manual
Thank you Matthew, but, the prompt feature is not available until v4.02.
From the docs:
From MySQL
On Thu, Aug 07, 2003 at 09:07:41PM -0500, Dan Nelson wrote:
In the last episode (Aug 07), Jeremy Zawodny said:
I've been on the box at the mysql prompt quite a few times when it
has happened and there was always a large amount of threads waiting
for a lock to clear, and as soon
On Thu, Jul 31, 2003 at 10:33:21AM -0700, Richard Sumilang wrote:
Anyone know when it will be considered production stable?
When it's stable.
http://www.mysql.com/doc/en/Release_philosophy.html
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
On Thu, Aug 07, 2003 at 01:00:12PM -0700, Ian Neubert wrote:
I was trying to design it so that the slaves wouldn't know they had
connected to a different master, as they both masters would have the same IP
address that gets failed over based on the Linux Virtual Server software and
VRRP (like
On Fri, Aug 01, 2003 at 01:00:13PM -0400, Jack Coxen wrote:
Since starting up RTG not quite 3 months ago, my database has grown to over
10GB in size. If I can get the drive space to keep the 2 years worth of
data I want to, my database will be edging upward toward 100GB. There are
On Tue, Aug 05, 2003 at 02:14:11PM +0100, [EMAIL PROTECTED] wrote:
See the command LOAD DATA FROM MASTER (
http://www.mysql.com/doc/en/LOAD_DATA_FROM_MASTER.html ). This should do
what you want - it does it for me.
As I understand it, this puts a read lock on each table as it copies it.
On Thu, Aug 07, 2003 at 03:58:37PM -0700, Jennifer Goodie wrote:
One of my coworkers insists that this is due to corrupt indexes, stating
that if an index points to a location outside of the record set
mysql gets
confused and hangs.
Does he have any evidence whatsoever for that?
On Wed, Aug 13, 2003 at 04:07:24PM -0500, sean peters wrote:
Hi all, i've been weighing the pros and cons of running multiple concurrent
mysqld's on one server, to have better control over what databases are on
what physical disks.
System: 4 processor sun box running solaris with eighteen
On Thu, Aug 07, 2003 at 07:54:24PM +0100, Gary Broughton wrote:
Hi all
I continue to have problems with the CPU usage with MySQL and PHP
under IIS 5 (Win2000). I recently rewrote our messageboards in PHP
(from ASP). I now have both online separately, and if I look at the
processlist, the
On Tue, Aug 12, 2003 at 02:32:00PM +0800, Ariz Jacinto wrote:
i've created a simple UDF (for testing) that returns a string.
my problem is that the string that it returns, contain some
of the characters of the longest string in the column.
example:
Table
+-+
|
On Fri, Aug 08, 2003 at 04:18:51PM -0700, Jeremy Zawodny wrote:
On Thu, Aug 07, 2003 at 09:07:41PM -0500, Dan Nelson wrote:
In the last episode (Aug 07), Jeremy Zawodny said:
I've been on the box at the mysql prompt quite a few times when it
has happened and there was always a large
On Fri, Aug 08, 2003 at 09:25:31AM -0700, Steven Roussey wrote:
It looks like Igor comitted it to the 4.1 tree on the 2nd of this
month:
I'd assume that this change is necessary but not sufficient for the
MySQL table type table locking issue...
What issue is that?
Jeremy
--
Jeremy D.
On Thu, Aug 14, 2003 at 09:43:46AM +0100, Steve Childs wrote:
http://bugs.mysql.com/bug.php?id=346
Jeremy
Cheers Jeremy - I just noticed that the version reported was 4.0.12-max, I'm
running 4.0.12-log - is that going to affect anything?
Nope.
Secondly, they said they would turn off
On Wed, Aug 13, 2003 at 02:22:32PM +0200, Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Jeremy Zawodny [EMAIL PROTECTED] writes:
Query is:
Select * from table where keywords like '%blah%' or caption like '%blah%' or
headline like '%blah%' or cat like '%blah%' limit 20,10
On Thu, Aug 14, 2003 at 09:05:50AM +0100, Steve Childs wrote:
Number of processes running now: 1
mysqld process hanging, pid 28646 - killed
030813 10:27:35 mysqld restarted
Warning: Ignoring user change to 'mysql' because the user was set to 'mysql'
earlier on the command line
On Wed, Aug 13, 2003 at 03:26:24PM +0200, Mechain Marc wrote:
First of all, thank you Jeremy for your answer.
You said:
It's the amount of time that thread has been in its current state.
Is it the current state column value (which is in fact nothing or
the text of the running SQL
On Tue, Aug 12, 2003 at 11:43:50AM +0200, Mechain Marc wrote:
I would like to know (if possible, there is no explanation in the
documentation) the exact meanning of the column time in the show
processlist command.
It's the amount of time that thread has been in its currnet state.
--
Jeremy
On Wed, Aug 13, 2003 at 12:58:06AM +0530, Binay Agarwal wrote:
Hi
While using OR in the query, Mysql doesn't use indexes.. right? Hence takes more
time.
If queries have to be ORed on various coloumns (demand of the application) what one
can do to speed it up.
Table structure:
On Fri, Aug 08, 2003 at 12:10:18PM -0400, Adam Nelson wrote:
Also, one has to work out the cost of high availability. If you're
talking about a situation where you reduce downtime from 4 hours/yr to
.5 hours/yr and it costs you x dollars, you have to make sure that the
extra 3.5 hours of
On Fri, Aug 08, 2003 at 04:30:21PM -0500, Jackson Miller wrote:
I am going to have to put MySQL on it's own box, and I am wondering what makes
the biggest difference with hardware.
I am hoping to set max_connections to 1000 at least (and I will probably use
at least 500 several times a
On Fri, Aug 01, 2003 at 03:31:02PM +0100, Khaled D Elmeleegy wrote:
I am studying the scalability of MYSQL on SMPs on Linux. I am
wondering if any one has performed scalability studies. If so, I
would be interested in a pointer to the results; if not, I am
curious if there is interest in
On Thu, Aug 07, 2003 at 03:22:58PM -0700, Ian Neubert wrote:
Good question :)
I got a message from a person off the list that suggested I use
network disk mirroring or a NAS/SAN/NFS system to handle that. I'm
not sure if the mirroring would be 100% perfect, but the NAS/SAN
solution should
On Thu, Aug 07, 2003 at 05:42:12PM -0400, Bernd Jagla wrote:
Dear list,
does anyone know what it means when it says state = NULL doing the show
processlist?
Usually you see this when the 'command' is sleep. That means the
thread is idle.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux
On Wed, Jul 16, 2003 at 03:49:51PM -0700, Cory Lamle wrote:
Contents are Direct Alliance Corporation CONFIDENTIAL
-
I have a table with 10 cols. 8 of which all need to be searched on
independently of each other.
Does creating 8 separate indexes for that table affect the speed of how
mysql
On Wed, Jul 30, 2003 at 12:34:54PM +0800, unplug wrote:
I use rpm to update the previous version. I can use innodb in redhat 9
with version 2.23.56. But it failed in redhat 7.2. I wonder it is the
kernel problem.
Why would you suspect the kernel? How did it fail?
BTW, I want to ask
On Thu, Aug 07, 2003 at 01:41:57PM -0700, Jennifer Goodie wrote:
I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
but I think it's a P3 1GHz. It has several tables with 20-40 million rows
and a
On Thu, Aug 07, 2003 at 10:27:38PM -0700, Steven Roussey wrote:
MyISAM performance is limited right now by a global lock in the key
cache. However, I believe there is work going on to fix that in the
4.1 tree.
Really? I thought it was going to be fixed in the 5.1 tree, which will
be
On Thu, Jul 31, 2003 at 02:51:10PM -0400, [EMAIL PROTECTED] wrote:
Hopefully jeremyz will toll in.. he's probably hit it before ;)
I've been up to 2000 connections on a 1GB FreeBSD box. With some
tweaking, I'm sure you could go quite a bit higher.
Jeremy
--
Jeremy D. Zawodny | Perl,
On Thu, Jul 31, 2003 at 08:36:02PM +0200, NEWMEDIAPLAN wrote:
Can mysql handle 5000 concurrent webusers sending queries to the db through
a web search engine.
Is it possible (with a very big server/hw) ?
What OS are you using? And how much hardare?
--
Jeremy D. Zawodny | Perl, Web,
On Tue, Jul 29, 2003 at 03:08:42PM +0800, unplug wrote:
Hi all,
I am trying to use mysql with innodb. After I set it up as follow.
The db start failed.
I wonder why it failed to use innodb. Does anyone can tell me?
OS: redhat 7.2 with kernel 2.4.20-18.7
mysql version: 3.23.56
On Wed, Jul 23, 2003 at 04:47:35PM -0400, Joe Gainey wrote:
Currently we have a web based application that is mostly reads (4:1
r/w). It is using a single MySQL database server. Is there any way to
have two database servers in a master/master configuration such that
writes to
On Tue, Jul 29, 2003 at 01:41:00AM -0400, Asif Iqbal wrote:
Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on
how to improve it ?
Get a faster CPU.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
On Thu, Jul 24, 2003 at 11:14:51AM -0400, Jeff McKeon wrote:
Is there a way to issue a REPAIR TABLE table_name command to all
tables at once? Something like REPAIR TABLE *
No.
However, you could use myisamchk with the server off-line. Then you'd
be able to script it and/or use shell wildcard
On Wed, Jul 23, 2003 at 08:31:21PM -0700, Jamie Krasnoo wrote:
Will placing Apache::RequestRec Apache::RequestIO APR::Table in
startup.pl to load them up for multiple handlers have any bad side
effects? I noticed that when I load them via startup.pl the handlers
that use them don't complain
On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file. The
format of video is either avi or mpg. However I can not successfully
insert the video file into the cooresponding field of a table by
using
On Sun, Jul 06, 2003 at 10:10:22PM -0600, Jim McAtee wrote:
Jim McAtee wrote:
David Lloyd wrote:
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about
On Mon, Jul 07, 2003 at 10:57:52AM -0500, Dan Nelson wrote:
In the last episode (Jul 07), Nils Valentin said:
Thank you for the superfast reply. I actually was looking for other
information. I understood the actual feature difference of the
standard and f.e max version. Sorry if this didnt
On Wed, Jul 09, 2003 at 01:08:56PM -0400, Dave [Hawk-Systems] wrote:
load). Is there a known issue (running on FreeBSD 4.8,
MySQL 3.23.55 MyISAM)?
its been a known issue for quite a long time
use linuxthreaded version and it should work fine.
although much of work has been done on
On Wed, Jul 09, 2003 at 11:51:01PM -0500, Paul DuBois wrote:
At 14:14 +0700 7/9/03, Dominicus Donny wrote:
Sorry, my mistake. It's reindexing then.
Once i should add 2 key indexes on a huge table.
But instead of alter the table in 1 single query,
I build each index 1 by 1.
Generally, it is
Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x
and handling more than 950 connections?
If so, did you need to do anything special to make it work? I'm
seeing this:
Can't create a new thread (errno 35). If you are not out of available
memory, you can consult the manual for
On Wed, Jul 16, 2003 at 03:16:26PM -0500, Dan Nelson wrote:
In the last episode (Jul 16), Jeremy Zawodny said:
Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x
and handling more than 950 connections?
If so, did you need to do anything special to make it work? I'm
On Tue, Jul 08, 2003 at 12:49:54PM -0700, Christian Nelson wrote:
Greetings...
We're eagerly awaiting 4.0.14 since it fixes the SET FOREIGN_KEY_CHECKS
bug.
http://www.mysql.com/doc/en/InnoDB_news-4.0.14.html says it should be
released in June... it's now July 8th.
When can we expect
On Thu, Jul 03, 2003 at 01:35:51PM -0700, Dathan Vance Pattishall wrote:
The 3rd approach was to write software with some pointers from a book
called MySQL The definitive guide to using, programming, administering
MySQL databases 2nd edition that I picked up at the last convention. I
On Thu, Jul 03, 2003 at 10:49:59PM +0200, awarsd wrote:
Hi,
I think MySQL uses binary tree, but my question is that what happens when we
delete record. Does the binary regenerate itself??
MySQL handles tree (re-)balancing when necessary.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL,
On Fri, Jul 04, 2003 at 08:48:37AM -0400, Paul Chvostek wrote:
I've been looking at Apache's mod_log_mysql and mod_mylo, and if I don't
need the extended featureset offered by mod_log_mysql, I can't help but
wonder if I'd get any better performance than with something like:
LogFormat
On Fri, Jul 04, 2003 at 02:35:15AM -0700, Dathan Vance Pattishall wrote:
I'm looking for help to formalize this process as well as present my
findings at the next mysql convention in Orlando. Do you think this would
be a valid topic? If so would the mySQL team allow me to present it?
It's
On Thu, Jul 03, 2003 at 06:51:28PM +, Mike Lucente wrote:
Hello,
I have nine process that import data to tables with the same structure
within about 1000 databases on a server. Each process fires at the same
time, every 5 minutes.
Lately I'm seeing these inserts hang, all waiting
On Fri, Jul 04, 2003 at 07:26:54PM -0500, Mike Blezien wrote:
Hello,
Happy 4th to all :)
Anyway, I am attempt to temporarily disable InnoDB tables. We just
setup on a new RH/Linux 7.3 server that had the MySQL version 4.0.13
from RPM's, pre-installed... but we currently don't need the
301 - 400 of 1672 matches
Mail list logo