High Performance MySQL ch 7 provides one of the solutions on that.
Look for check_repl.
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html
On Feb 3, 2008 2:58 AM, Brown, Charles [EMAIL PROTECTED] wrote:
Can someone please tell me what is the most effective or preferred
method for monitoring
Have you checked this?
http://www.slideshare.net/sim303/7020-preview/
http://www.freebsd.org/features.html
On Jan 22, 2008 4:05 AM, Mikhail Berman [EMAIL PROTECTED] wrote:
Hi everyone,
Is anyone has experience running MySQL 5.0.41 on FreeBSD 7.0-RC1 AMD64?
If you do would you be able to
Hi,
A silly question.
Is there anybody knowing estimated GA release date for MySQL 5.1?
I heard it was planed to be released in december this year and
the latest release 5.1.22 is RC, but seems that it will not happen soon.
Thanks.
--
MySQL General Mailing List
For list archives:
If exact number isn't important,
you might want to try table_rows in information_schema.tables or show
table status.
On Dec 21, 2007 7:53 PM, Urms [EMAIL PROTECTED] wrote:
Hi,
My task is to limit calculation of total number of items in the database
that satisfy certain conditions. I join two
Oh, I misunderstood,sorry.
Using summary tables doesn't work for you?
On Dec 22, 2007 3:00 AM, Urms [EMAIL PROTECTED] wrote:
The problem is that there are certain conditions after WHERE different for
each query and the results number can be very different.
--
View this message in context:
You might want to use --single-transaction option when mysqldumping innodb
On Dec 1, 2007 1:20 AM, Jeff Mckeon [EMAIL PROTECTED] wrote:
-Original Message-
From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
Sent: Friday, November 30, 2007 11:16 AM
To: mysql@lists.mysql.com
Hello,
I encountered weird problem.
I upgraded MySQL on my database on my app from 5.0 to the latest 5.1.22.
After the upgrade, the app suddenly got very slow.
A query, which was executed within about 0.1 sec, now took longer than
a few minutes.
(Actually, I don't know exactly how long it would
Have you tried optimize table?
On 10/27/07, Josh [EMAIL PROTECTED] wrote:
Hello,
I have a database that is growing at a rate of 4-5 MB per day (that number is
getting larger as well). Not too bad but I'm trying to clean up the tables
to minimize the amount of space they take up.
I have
Hi list,
Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me
wonder how is it possible to replicate AUTO_INCREMENTed value to slaves.
According to the doc,
If you specify an AUTO_INCREMENT column for an InnoDB table, the
table handle in the InnoDB data dictionary contains a special
If After delete from table where id = 4 and restart mysqld on server B,
insert into table (value) values(e) is executed on server A.
Why would you delete data from the slave?
The delete statement is for Master, not slave.
--
MySQL General Mailing List
For list archives:
Thank you for your reply.
But I couldn't under stand how --auto-increment-increment and
--auto-increment-offset
helps me avoid my problem.
Could you please explain?
On 10/24/07, Eric Frazier [EMAIL PROTECTED] wrote:
js wrote:
Hi list,
Reading How AUTO_INCREMENT Handling Works in InnoDB[1
Hello,
Good post, but not what i'm looking for.
Well, Postgresql seems to be the winner, at least for
handling network addresses.
(Don't take me wrong. I'm not saying Postgresql is better RDBMS)
Thanks.
On 5/15/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
js wrote:
Hi Baron.
Thanks
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' inet '192.168.1.5'
http://www.postgresql.org/docs/current/static/functions-net.html
Is there anyway to do this using MySQL?
--
MySQL General Mailing List
For list archives:
Hi Baron.
Thanks for reply.
If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.
On 5/15/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hello,
js wrote:
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet
Hi list,
I have 4 simple table.
---
CREATE TABLE employees(
id INT NOT NULL AUTO_INCREMENT,
name varchar(20) NOT NULL,
PRIMARY KEY(id),
UNIQUE(name)
) ENGINE = InnoDB;
CREATE TABLE skills(
id INT NOT NULL AUTO_INCREMENT,
name varchar(20) NOT NULL,
Additional information.
MySQL Version: 5.0.33
Platform: Mac OS X 10.4.8
Machine Spec: 2.16GHZ Intel Core 2 Duo Memory 2GB MHZ SDRAM
Test was done using the following dummy data.
employees table:
20 ascii chars as employees' name
skills:
INSERT INTO skills
(name)
VALUES
('C'),
('C++'),
Why do you recommend using trigger instead of unique index?
I think when unique index works I don't have any reason to use trigger.
If the field you want to be unique is big one, like char(1000) or TEXT,
You have to use trigger to save the uniqueness, though.
On 3/2/07, Anoop kumar V [EMAIL
Thank you for answering.
I tried your suggestion and it's got fast, but still slow and
could not get rid of Using temporary; Using filesort.
I don't understand why this simple query is so slow...
I agree that my testing data is wrong, but
what I was wondering is why the query gets slow only when using join,
although without join it gives me lightning answer.
BTW, you gave me a big hint!
I didn't know about 'cardinality', so searched on the web with the
word 'cardinality',
which leads me
One thing I don't understand is what MySQL tried to do first.
Why did MySQL chose co.name as a key?
On 3/3/07, Filip Krejci [EMAIL PROTECTED] wrote:
SELECT *
FROM employees2skills e2s FORCE INDEX (mod_time )
INNER JOIN companies c ON c.id = e2s.co_id
ORDER BY e2s.mod_time limit 5;
Yes,
/check-constraints-in-mysql-50.html
http://db4free.blogspot.com/2006/01/emulating-check-constraints.html
http://db4free.blogspot.com/2006/01/emulating-check-constraints-with-views.html
regards.
On 2/13/07, Nils Meyer [EMAIL PROTECTED] wrote:
Hi Js,
js wrote:
Is there any easy way to implement
Hi list,
A silly question.
Is it possible to prevent empty value('') from appearing in a field?
I can solve this by using subquery or trigger,
but it's a little bit painful.
The simpler the better :)
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Thanks for reply and sorry for lack of information.
What I want to know is not how to query,
but how to prevent emtpy data from being inserted in tables.
Let's say I'd like to have a table that doesn't contains any NULL value.
I'd create the table like below.
##
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing MyISAM and InnoDB.
How do you pronunce them?
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, sorry... just ranting here because this has been
going on for weeks now and I'm nearly out of ideas. :-)
Anyway, if you've got any ideas, no matter how ridiculous they might sound,
feel free to pitch them this way. ;)
Thanks,
=js
As always with these things, horses for courses. In my situation,
I have a mysql server mounted off a netapp, It is the backend for
a website serving 10m+ page impressions per month.
I wanted to put the data on a netapp for easy backup ( I can shutdown
the server do a snapshot and bring it
Here's a good one:
When doing an update on a table from the CLI, the query is
done in under a second (0.01 of a second actually).
When I do the _exact_ same query from PHP, the update takes
up to 3 minutes.
The table is large (1GB, 400k rows) but simple (5 columns,
one primary key which is
27 matches
Mail list logo
