On Mon, Feb 04, 2002 at 04:34:21PM +1300, Ian Collins wrote:
(I originally sent this to sales@mysql, but got no response - thought I'd
try this way).
That's odd. Try [EMAIL PROTECTED] directly.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408)
I just attempted to upgrade a 3.23.41-max server on Linux 2.4.12 to
3.23.47-max. Before starting up 3.23.47-max, I added several Innodb
options to the my.cnf file:
---snip---
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M
innodb_data_home_dir =
On Mon, Feb 04, 2002 at 02:27:01PM +0200, Sinisa Milivojevic wrote:
Jeremy,
It could also be a bug in glibc.
As you are using Linux, can you try out binary ??
That was your binary on Linux.
Strangely, I just started up that exact same copy of 3.23.47-max and
it worked fine after a
On Mon, Feb 04, 2002 at 07:15:33PM +0200, Sinisa Milivojevic wrote:
Yes, this is troubling ...
It could be hardware, though ...
Can you find anything in MySQL log and especially in /var/log/dmesg
or /var/log/messages.
Nope.
Sometimes, not often, Linux kernel is capable of noticing
On Mon, Feb 04, 2002 at 02:33:40PM -0700, Sasha Pachev wrote:
On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
?This does look like a libc bug. How did you build either one of the
binaries?
They're your binaries. ?I don't buld my own binaries on Linux to save
the hassle
On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote:
Hi.
Does somebody know which server hardware I have to buy to realize my following
problem ?
I have 3 tables. They are all connected to each other with some queries.
1st table has momentary 10.000 and should be
On Mon, Feb 04, 2002 at 05:41:46PM -, Robin Keech wrote:
(Please reply directly, I am only on the digest list, thanks)
I have an SQL statement that is taking far too long to run, around
11 minutes (while locking inserts/updates).
We have installed some more RAM, and I need help with
On Wed, Feb 06, 2002 at 06:49:02PM +0200, Sinisa Milivojevic wrote:
Trond Eivind Glomsrød writes:
Vernon A Webb [EMAIL PROTECTED] writes:
Anyone know the difference between MySQL and PostgreSQL?
PostgreSQL has a lot of features MySQL don't have yet (transactions
everywhere,
On Wed, Feb 06, 2002 at 01:57:21PM +, Wiliam Stephens wrote:
Hi
I want to retrieve a row of MySQL data using Perl and DBI, so I do it like
this:
[code]
my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|;
$sth = $dbh-prepare($sqlquery);
On Wed, Feb 06, 2002 at 04:10:33PM -0500, Max Mouse wrote:
Hey all,
Is it possible to copy the contents of one column to another column
using mySQL? I just changed my table structure by adding a few more
columns and I need to be able to move the data from the original
column to 4 new
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
Dear MySQL users,
I have just pushed my latest changes in the replication code in our
4.0 development tree, which change the slave to use two threads -
I/O thread that gets the data from the master and logs it, and SQL
thread
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
So I need your help with field testing of my code. For those of you
who are wondering why you should - this will help us stabilize 4.0 a
lot of faster, and not only replication, but also the general SQL
features. So if you depend
On Mon, Feb 11, 2002 at 03:04:47PM +1300, Ian Collins wrote:
In mysqlhotcopy, function copy_files, there is a line,
my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
(dont you just love perl?).
If the database name in question is, for example, testone_750, a
perfectly legal database name
On Sun, Feb 10, 2002 at 02:53:53PM -0500, Matthew Dougherty wrote:
If I use a REGEXP query on an indexed column using something like:
Field REGEXP '^A|^B|^C'
Will MySQL use the index like it would if I used Field LIKE 'A%' or
Field LIKE 'B%' or FIeld LIKE 'C%' ??
It will not.
Regular
On Sun, Feb 10, 2002 at 10:01:45PM -0600, Paul DuBois wrote:
At 18:07 -0800 2/10/02, Jeremy Zawodny wrote:
On Sun, Feb 10, 2002 at 02:53:53PM -0500, Matthew Dougherty wrote:
If I use a REGEXP query on an indexed column using something like:
Field REGEXP '^A|^B|^C'
Will MySQL use
On Mon, Feb 11, 2002 at 04:48:10PM -0600, David Felio wrote:
Whoops, originally sent this to just Heikki.
On Monday, February 11, 2002, at 12:12 PM, Heikki Tuuri wrote:
for InnoDB 'dynamic rows', that is, rows where you define char columns as
VARCHAR, are faster because tables and indexes
On Wed, Feb 06, 2002 at 06:49:02PM +0200, Sinisa Milivojevic wrote:
Trond Eivind Glomsrød writes:
Vernon A Webb [EMAIL PROTECTED] writes:
Anyone know the difference between MySQL and PostgreSQL?
PostgreSQL has a lot of features MySQL don't have yet (transactions
everywhere,
On Wed, Feb 06, 2002 at 01:57:21PM +, Wiliam Stephens wrote:
Hi
I want to retrieve a row of MySQL data using Perl and DBI, so I do it like
this:
[code]
my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|;
$sth = $dbh-prepare($sqlquery);
On Thu, Feb 07, 2002 at 09:59:52PM -0500, James Riordon wrote:
Hi Again,
I have honed this question pretty well I think (MySQL 3.23.37):
I am using large-my.cnf as my my.cnf file. It is for servers with 512
MB of RAM from what I read. On our server that has 512MB of RAM I
notice in top
On Mon, Feb 11, 2002 at 04:37:39AM -0800, Konstantin Yotov wrote:
Hello there!
I'm using Apache-Session module and it seems that everything work
properly, but in bin log is this query:
DO
RELEASE_LOCK(Apache-Session-0c47492fccde576b180ea37fa07de395);
What could be wrong in it?
I'm
On Mon, Feb 11, 2002 at 03:04:47PM +1300, Ian Collins wrote:
In mysqlhotcopy, function copy_files, there is a line,
my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
(dont you just love perl?).
If the database name in question is, for example, testone_750, a
perfectly legal database name
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
Dear MySQL users,
I have just pushed my latest changes in the replication code in our
4.0 development tree, which change the slave to use two threads -
I/O thread that gets the data from the master and logs it, and SQL
thread
On Sun, Feb 10, 2002 at 10:01:45PM -0600, Paul DuBois wrote:
At 18:07 -0800 2/10/02, Jeremy Zawodny wrote:
On Sun, Feb 10, 2002 at 02:53:53PM -0500, Matthew Dougherty wrote:
If I use a REGEXP query on an indexed column using something like:
Field REGEXP '^A|^B|^C'
Will MySQL use
On Sun, Feb 10, 2002 at 02:53:53PM -0500, Matthew Dougherty wrote:
If I use a REGEXP query on an indexed column using something like:
Field REGEXP '^A|^B|^C'
Will MySQL use the index like it would if I used Field LIKE 'A%' or
Field LIKE 'B%' or FIeld LIKE 'C%' ??
It will not.
Regular
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
So I need your help with field testing of my code. For those of you
who are wondering why you should - this will help us stabilize 4.0 a
lot of faster, and not only replication, but also the general SQL
features. So if you depend
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
* Monitor your slave to make sure it does not crash ( watch error log for
stack trace messages), slave keeps running ( check with SHOW SLAVE STATUS),
and data is consistent.
* If there are problems, I will need the
I'm getting duplicate messages separated by several hours. Am I alone
in this, or are others seeing it too?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 5 days, processed
On Wed, Feb 13, 2002 at 08:19:50AM -0500, Kevin McBrearty wrote:
We are working on a Java web application and are thinking about
using InnoDB. Does anybody know any hosting companies in the
US/Canada that support InnoDB table types in MySQL. Most that I have
checked with don't.
I'm working
On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote:
I see people speaking about mysql 4.0.2... but where you get it?
they write some thing about it on web page but 4.0.2 is not in the
download list...
It's from the MySQL source tree. See this url:
On Sat, Feb 16, 2002 at 03:21:16AM -, Bjorn Swift wrote:
Hi all.
The load on my mysqld server is getting higher by the day and I am
trying to get a better picture of what's going on. I recompiled with
the debug option and have started a trace log.
Is there any tool available that can
On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote:
In that case, i would highly recommend using mysqldump to backup
your databases. Simply compressing the actual DB's could give you
tables in inconsistent states, UNLESS you first shut down your DB
server, then run the backup.
On Sat, Feb 16, 2002 at 02:20:56PM -, Bjorn Swift wrote:
Have you optimized the settings in my.cnf and checked your slow
queries?
No, I haven't optimized my.cnf - looking at it now. Thanks.
Well, that was pretty much what I was hoping this tool could do;
go though the trace log and
On Fri, Feb 15, 2002 at 09:43:28AM +0100, Wolfgang Pichler wrote:
I have to set up a HA-Linux Server with Apache and mysql running on
two machines over load balancing. Apache isn't a problem. But mysql.
AFAIK it is impossible to cluster mysql - it only supports
replication. As I've said
On Fri, Feb 15, 2002 at 10:32:06AM +, Simon Windsor wrote:
Currently, I maintain two mysql server, hosted by separate ISPs, and
keep them synchronised using standard MySQL replication.
Great!
Server A is master+slave to server B, and likewise server B is master
+slave to server A.
On Fri, Feb 15, 2002 at 04:00:11PM +0100, Antoine wrote:
Hello,
Well, for my project at work, I've done some small benchmarking of
different table types for relatively small sizes (some tens or
hundreds of thousands rows - small enough so that key buffer size
and other memory factors
On Fri, Feb 15, 2002 at 09:17:52PM +0300, Mikhail V.Soloviev wrote:
Hello,
I have a problem with mysqld (3.32.46 under Red Hat Linux 7.2,
pIII-800 512K RAM). It starts and works fine until some time is
passed, then it starts eating my memory and CPU.
What does SHOW PROCESSLIST say at that
On Fri, Feb 15, 2002 at 10:08:08AM +0800, [EMAIL PROTECTED] wrote:
Hi,
I still got stuck on a query...so slow...it took a minute or more
How can I improve my server...
Can you tell us what the mysterious query is? And send along the
output of EXPLAIN query as well?
Thanks,
Jeremy
--
On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote:
I'd like to connect a local sql server to a remote server and get 1
database synchronized between them. For various reasons, I need to
try to run this from within the sql protocol (i.e. no ftp, etc.).
Okay.
Replication is not the
On Wed, Feb 06, 2002 at 10:02:02AM -0600, Todd Newbold wrote:
Hi everyone,
When using replicate-ignore-table in mysql, does filtering happen
before or after transmission from the master to the slave?
Is the directive on the slave? If so, that's where it happens.
--
Jeremy D. Zawodny,
On Thu, Feb 21, 2002 at 10:17:52AM -0600, Scalper wrote:
I am a new MySQL user, so forgive my stupidity for asking the
following question (perhaps taboo). What is the latest on NuSphere
vs MySQL AB? What about Gemini. I have searched everywhere for
info, but can't seem to find anything
On Thu, Feb 21, 2002 at 04:10:58PM -0500, Lou Picciano / Essex Systems wrote:
Have a feeling I know the answer already, but here goes! ...
Does anyone know if (and how) MySQL supports raw devices? I¹ve been
searching the docs; can find nothing...
InnoDB can use raw devices.
--
Jeremy D.
On Thu, Feb 21, 2002 at 08:13:51PM -0800, Jeff Kilbride wrote:
For reporting purposes, I usually use a wide index across all the
fields that are relevant to creating the reports. So, for example,
my sales table has this type of data:
sale_id
sale_date
salesperson_id
product_id
On Fri, Feb 22, 2002 at 08:46:37AM -0800, Tim Allwine wrote:
So it appears there is a maximum of 32 keys (indexes) that can be
created on a table. Is there any way to increase this? If so how?
I seem to remember it being a simple soure code change. Check the
mail archives (if you haven't
Why is porting MySQL to BeOS still on the TODO list? The OS is
esentially dead, right?
Just wondering...
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 16 days, processed
On Mon, Feb 25, 2002 at 01:08:49PM +0100, Marek Wysmulek wrote:
Dear all.
I have Debian (kernel 2.4.19) and mysql 3.23.49 updated from 3.22.
Before update everything was working fine. After it seems to also
BUT:
I can not connect from other host then localhost (literally - even
On Fri, Feb 22, 2002 at 08:29:03AM -0500, Anthony W. Marino wrote:
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote:
On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote:
Is there a timeline/status for 4.x functionality available?
No. It'll be ready when it's
On Fri, Feb 22, 2002 at 08:59:41AM +, [EMAIL PROTECTED] wrote:
I would like to second this request. I *really* want the replication
failover functionality targeted for 4.x. In fact, if it isn't
going to arrive by, say, midsummer, I will have to develop my own
failover solutions.
Well,
On Mon, Feb 18, 2002 at 03:05:09PM -0500, Andrew Crum wrote:
As for a filesystem. I wouldn't recommend ext2 or ext3 at all. I
would _highly_ recommend a journaling filesystem such as Reiserfs
(http://www.namesys.com) or XFS (http://oss.sgi.com).
You do know that ext3 is journaling, right?
On Mon, Feb 25, 2002 at 01:29:27PM +0100, Marek Wysmulek wrote:
I can not connect from other host then localhost (literally - even
127.0.0.1
takes no effect)
Iptables rules are wide accepting.
In host name there is name of the host, and in hosts IP is associated.
Are you
On Mon, Feb 25, 2002 at 01:48:13PM +0100, Marek Wysmulek wrote:
(Hmmm. Zawodny Are you related with a polish family ? - I'm polish
too ;-
My grandparents came to the United States from Poland sometime around
1910, I believe. I'm 100% Polish, but cannot speak the language.
Glad
On Mon, Feb 25, 2002 at 02:44:45PM -0800, Eric Mayers wrote:
Oganes,
It sounds like what you want is row-level-locking. This is a
feature of InnoDB tables. It allows users to write to a table while
other users are reading from the same table. Of course, they cannot
read and write the
Are RAID tables supposed to be enabled in the -MAX binaries? They
appear not to be (in 4.0.1), and that surprises me a bit. It thought
that the point of the -MAX binaries was to enable all the bells and
whistles by default.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo -
If I create a merge table:
---snip---
CREATE TABLE mytable0 (
aINTEGER NOT NULL PRIMARY KEY,
bCHAR(18) NOT NULL
);
CREATE TABLE mytable1 (
aINTEGER NOT NULL PRIMARY KEY,
bCHAR(18) NOT NULL
);
CREATE TABLE mytable2 (
aINTEGER NOT NULL PRIMARY KEY,
b
On Mon, Feb 25, 2002 at 11:21:26PM -0800, Steven Roussey wrote:
Are RAID tables supposed to be enabled in the -MAX binaries? They
appear not to be (in 4.0.1), and that surprises me a bit.
I thought RAID tables were retired in MySQL 4.
Hmm. The have_raid variable is still there in SHOW
On Tue, Feb 26, 2002 at 05:43:25PM -0500, Mark Engelhardt wrote:
Hello everyone...
I am looking for some thoughts and recommendations...
We are going to upgrade our production mysql servers
tomorrow... What version of mysql should we run with --It MUST be
stable-- so we can have the best
On Fri, Mar 01, 2002 at 01:21:52PM -0800, Jeff Kilbride wrote:
Hi Jeremy,
Just out of curiosity, what kind of tables are you using on your
production system? MyISAM, InnoDB, a mix of the two, etc...
We're 100% MyISAM right now, but are building some new things on
InnoDB. Based on data
On Sat, Mar 02, 2002 at 11:14:42PM +0100, Steve Rapaport wrote:
I'm seriously considering switching to mysql-max so I can make my
session handling table an Innodb type. Currently the mysql locking
policy allows big traffic jams when several sessions are active
simultaneously, and it's the
On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote:
Hi,
I am planning to have MySQL database backup and recovery from the
web interface. Is it possible to do this. If yes, then what
procedure I should follow. If anybody have any idea about this then
please, do help me. It's
On Sat, Mar 02, 2002 at 06:52:57PM -0800, Jeff Kilbride wrote:
I'm looking to make the move to InnoDB, too. All I've heard is positve.
Here's a reply I got on another list:
If you have a very busy read/write op database, MyISAM can't handle
it. It's very efficient
On Wed, Feb 27, 2002 at 09:14:51PM -0800, Jeff Kilbride wrote:
Is there a rule of thumb for small tables and whether they should be
indexed? I have several small, two column lookup tables with few
rows (100-300) and some very small tables ( 10 rows). I don't plan
on indexing the very small
On Fri, Mar 01, 2002 at 02:41:03PM -0800, Jeff Kilbride wrote:
Does replication hurt MyISAM performance in the same way? If I'm
running a master that takes all the inserts and one or more slaves
to take all the select queries, would it be better implemented in
MyISAM or InnoDB?
It depends.
On Sat, Mar 02, 2002 at 10:32:39PM -0700, Sasha Pachev wrote:
On Monday 11 February 2002 01:01 pm, Jeremy Zawodny wrote:
Okay, I've hit a bug. ?It happened after the slave had replicated
about 5,397,000 queries.
Jeremy:
I have finally gotten around to this and I think I've found
On Sat, Mar 02, 2002 at 09:51:12PM -0800, Jeff Kilbride wrote:
If you cover stuff like this in your book, I'll definitely buy it.
:)
Now that's what I like to hear! :-)
Ok, last question on this subject, I promise! Why not use InnoDB and
replication? I was looking through the manual
On Sun, Mar 03, 2002 at 02:55:24PM +0200, Liivar Paas wrote:
Greetings,
I brought new server and I'd like to copy old database to new server. MySQL
3.23.41 RH7.2 both machines.
I copyed /var/lib/mysql to new machine /var/lib/mysql and seems that
MySQL is working I can use databases and
On Sun, Mar 03, 2002 at 01:25:46PM -0800, Dreamtime.net Inc. wrote:
Hi,
We have mysql 3.23.43 running under FreeBSD 4.2, two-processors and
a Tyan LE S2510 motherboard with 1 gig of ram. After a few peak
loads of the server (load avg. gets higher than 20), mysql starts
eating processor
On Mon, Mar 04, 2002 at 02:42:46PM -0800, destr0 wrote:
filter fodder: mysql, database, sql
whigh one is faster?
REGEXP or LIKE?
LIKE is generally faster. But LIKE can't do everything that REGEXP
can, so that's probably no surprise.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
On Sun, Mar 03, 2002 at 07:51:36PM -0800, Son Nguyen wrote:
Dear all,
If my site has two users try to update the same piece of data in
mySQL at the same time.
* I wonder if I have to create a lock to handle the race condition in
my script or not?
* Or mySQL already provided a
On Mon, Mar 04, 2002 at 10:05:50AM +0530, Chetan Lavti wrote:
I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform.
Now,for this database backup and recovery procedures are given as :
1.Taking 'binary' backup of the database.
2.Using the mysqldump utility
In the
On Mon, Mar 04, 2002 at 11:19:54AM +0100, Takacs Istvan wrote:
Hi,
We use mysql 1.23.47 as a database for our PHP based accounting
system. We use mysql_pconnect() to get a connection to the DB.
This morning we couldn't log in because mysql sent back a 'too many
open connection!' (or
On Mon, Mar 04, 2002 at 12:25:44PM +0100, Angela Harneit wrote:
I've a question concerning negations of regular expressions - e.g. I
want the sentence this is nice to match, while the sentence this
is not nice should not match. I only found possibilities for the
negation of single
On Mon, Mar 04, 2002 at 02:48:06PM -0500, Natividad Castro wrote:
I'm new using mysql. I'm trying to load data from a text file to one
of my table. This text file contains duplicate records. My question
is how do you tell mysql to delete duplicate records and load just
the ones that are not
On Mon, Mar 04, 2002 at 04:29:16PM -0500, Natividad Castro wrote:
Thank you very much!! that was very helpful. By the way, is there
any other way to get rid of duplicate records from a text file?
I can think of others, but they're not nearly as easy or efficient.
Jeremy
--
Jeremy D.
On Mon, Mar 04, 2002 at 03:06:46PM -0500, [EMAIL PROTECTED] wrote:
I am currently implementing a database-ran webserver dll:
Info:
Ms Visual C++
MySQL ++ 1.7.1
MySQL-nt 3.23.47
MyISAM db.
3or 4 Queries in the application
Biggest Query:
66,000 records
using LIKE something%
Question:
On Mon, Mar 04, 2002 at 08:33:27AM -0800, Dreamtime.net Inc. wrote:
We have FreeBSD 4.2-RELEASE and I can't say for sure how much time
it might take to upgrade to 4.3 or higher. It might take anywhere
from one reboot to several hours (if something won't work).
Well, if it stops the problem,
On Mon, Mar 04, 2002 at 01:47:42PM -0600, BD wrote:
Jeremy,
PMFJI, but has anyone done any testing to see if persistent
connections with MySQL and PHP is actually faster in practice?
What's PMFJU?
Without testing, I suspect that it is faster but that the gains are
very small. If
On Mon, Mar 04, 2002 at 09:30:16AM -0500, Ken Menzel wrote:
Hi Heikki,
I don't know if this has been requested, but what about a tool to
'pre-create' dataspace? This tool would allow someone to create a
new dataspace, then a quick restart (After adding the name of the
space to 'my.cnf')
On Mon, Mar 04, 2002 at 02:06:00PM -0700, Lopez David E-r9374c wrote:
Using MySQL 3.23.40
App is logging db with 130 clients to a central MySQL db with 2
million events per day. Aged events of over 7 days are no longer
required. The central table is myisam type with fixed size
(datetime,
On Mon, Mar 04, 2002 at 07:12:32PM -0700, Sasha Pachev wrote:
On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote:
--
P.S. so far, it's helpful bug: I use it as catch
for poor queries!:)
This actually gives me an idea for a
feature. --disable-disk-temp-tables - fail all
On Tue, Mar 05, 2002 at 01:04:50PM +0530, Battini, Chandrashekar wrote:
Hi,
As the entries grows in mysql database in linux intel box, the time
taken to search(select statement) for entries increases
linearly.
If that's true, you may need to use an index to speed up the query.
This
On Sat, Mar 02, 2002 at 09:57:58PM -0800, Jeremy Zawodny wrote:
Murphy's law strikes! Just a few hours ago I blasted the relay logs
on my 4.0.2 slave. It ran out of disk space!
I'll rsync the slave and build a fresh MySQL from the bitkeeper tree
and let you know.
Sasha,
I re-synced my
On Tue, Mar 05, 2002 at 09:19:35AM -0700, Sasha Pachev wrote:
On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote:
When the machine is pounding away on updates (over 300/sec), it can
take a long time to get a response to SHOW SLAVE STATUS. ?I get one,
but it can take between 5 and 30
On Tue, Mar 05, 2002 at 09:58:13PM +0100, Steve Rapaport wrote:
I sure would, thanks Monty and Tobias. In particular some sample
update/insert/delete db code for MyISAM vs. InnoDB, (especially in
the case where you're not adding transactions, just trying to take
advantage of row-locking.)
On Tue, Mar 05, 2002 at 05:30:31PM -0800, Steven Roussey wrote:
Jeremy,
Mytop is simply awesome. Thanks!
Thanks, glad ya like it.
I recently updated to 0.9. I have a request: how about the qps mode show
total qps as well as breaking them out (selects, inserts, updates,
deletes, and
On Tue, Mar 05, 2002 at 09:15:59PM -0800, Amit Lonkar wrote:
hi
Does Mysql support Transat SQL???
Nope.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 26 days, processed
On Tue, Mar 05, 2002 at 12:13:25PM -0800, Jeremy Zawodny wrote:
On Tue, Mar 05, 2002 at 09:19:35AM -0700, Sasha Pachev wrote:
On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote:
When the machine is pounding away on updates (over 300/sec), it can
take a long time to get a response
On Thu, Mar 07, 2002 at 12:08:29AM -0500, Mr. Ozette Brown wrote:
I'm in the process of converting all of my database tables from ISAM
to MYISAM table format. I'll run the mysql_convert_table_format
script which basically does an Alter table. If during this
conversion someone accessed a
On Wed, Mar 06, 2002 at 11:06:18AM -0800, Sam Iam wrote:
We have a very high volume site (3 million page views a day) that's
run on 16 Apache / PHP web servers 2 MySQL servers. We are using
PHP with persistent connections. Each MySQL serves 8 web servers
is supposed to act as a failover
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
All,
How can I notify an application running on the slave server that the
slave database has just updated itself by means of replication. The
reason I ask is that I know MySql currently doesn't support
triggers, but my application
On Thu, Mar 07, 2002 at 09:57:54AM -0700, Sasha Pachev wrote:
On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote:
Do you have any feel for how much slower a debugging version of
MySQL is compared to a normal version? ?I ask because my
replication heartbeat monitor has noticed
On Thu, Mar 07, 2002 at 09:53:51AM -0800, [EMAIL PROTECTED] wrote:
Hi,
I need help in turning on the slow query log option on the my.ini file.
I've tried uncommenting it and when I tried to run the nt-max it
says it couldn't recognize the option. Here's what I have for my.ini
file, any
On Wed, Mar 06, 2002 at 06:19:53AM +0100, Eberhard Lisse wrote:
Hi,
I run SuSe 7.2 and have upgraded to the current suse versions of
mysql.
Server version 3.23.41-Max-log
Protocol version10
Connection linux.lisse.na via TCP/IP
TCP port3306
Hey Sasha,
The 4.0.x slave I had just rebuilt the other day died about 40 minutes
ago and produced a core file each time. It got caught in the cycle of
core dump, restart, core dump, restart...
In any case, here's a backtrace:
#0 0x2839d330 in kill () from /usr/lib/libc_r.so.4
#1 0x283e9ab1
On Thu, Mar 07, 2002 at 09:48:41PM -0800, Jeremy Zawodny wrote:
Hey Sasha,
[snip]
I'll keep it off-line until I hear from you on what data you need.
Oops. Here's the info form the error log:
---snip---
020307 21:39:03 Slave I/O thread initialized
020307 21:39:03 Slave SQL thread
On Fri, Mar 08, 2002 at 10:41:32AM -0700, Sasha Pachev wrote:
On Thursday 07 March 2002 11:39 pm, Jeremy Zawodny wrote:
020307 21:39:03 ?Error in Log_event::read_log_event(): 'read error',
data_len=193,event_type=2
020307 21:39:03 ?Slave SQL thread: I/O error reading
event(errno=-1
On Fri, Mar 08, 2002 at 03:14:31PM -0700, Sasha Pachev wrote:
On Thursday 07 March 2002 10:48 pm, Jeremy Zawodny wrote:
The 4.0.x slave I had just rebuilt the other day died about 40 minutes
ago and produced a core file each time. ?It got caught in the cycle of
core dump, restart, core
On Fri, Mar 08, 2002 at 05:10:02PM -0800, Jeremy Zawodny wrote:
I have tracked down and fixed the assertion failure issue. However,
I am still not certail why the sql thread does partial reads. I have
pushed my fix into the public tree, so let's have you pull it and
try again.
Yeah
On Sat, Mar 09, 2002 at 09:21:35AM -0800, Javier Gonzalo Gloria Medina wrote:
hi everybody:
i was talking with a developer and he told the next
thing:
if you have a database and you need to do joins to
make your quaries between tables... your database and
tables are not full
Sasha,
Running the latest binary I just built, I had a single core dump and
auto-restart early this morning. Here's the backtrace:
---snip---
Core was generated by `mysqld'.
Program terminated with signal 6, Abort trap.
Reading symbols from /usr/lib/libz.so.2...done.
Reading symbols from
On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote:
Anyhow,
Mysql can return data in XML.
The client can, but not the server, right?
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL
On Sat, Mar 09, 2002 at 12:31:20PM -0700, Sasha Pachev wrote:
Jeremy:
I think I now understand what happened, or at least I have a
pausilble theory that explains what I see in the logs.
When I had you kill the broken mysqld last time it went down in the
middle of updating
1 - 100 of 1672 matches
Mail list logo