On Thu, Mar 01, 2007 at 08:29:09PM -0800, Gary W. Smith wrote:
> > The table is MyISAM. I searched on google a bit for info on slow
> > updates with MyISAM and didn't really hit it on the nose. Can I ask
> > you to elaborate?
> >
>
> In /etc/my.cnf try adding:
>
> long_query_time = 1
> log-slo
> The table is MyISAM. I searched on google a bit for info on slow
> updates with MyISAM and didn't really hit it on the nose. Can I ask
> you to elaborate?
>
In /etc/my.cnf try adding:
long_query_time = 1
log-slow-queries=/var/lib/mysql/mysql-slow.log
Restart and then watch the file. If a a
On Thu, Mar 01, 2007 at 03:46:56PM -0800, Gary W. Smith wrote:
> > 1) Does increasing the number of replication slaves increase query
> > latency on the master? We're considering tiering the replication if
> > it might help - replicate the master to two slaves, each of which
> > replicates to ten
I'm having trouble with a stored proc. The problem is that the first
table is in a different database. Here is the test stored proc below.
Where I run this I get " ERROR 1327 (42000): Undeclared variable: s". I
have tried it by declaring "clientdev.servers s" and just by using
"clientdev.server
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 5.0.5 a new version of the Type-IV pure-Java JDBC driver for
MySQL has been released.
This is a bug fix release for the current production branch of Connector/J.
Version 5.0.5 is suitable for use with any MySQL version includi
declare the two fields you want unique as such? unique index.
alec
Kory Wheatley wrote:
I have a database called accountcreation, and I want to setup a table called accountinfo.
This table will require that two out of the three fields need to be "UNIQUE",
I don't want duplications in these
I would suggest you put an after insert trigger which does the validation
for you. If 2 fields are already null then it will just return an error and
rollback else it will allow the insert to be committed.
regards,
Anoop
On 3/1/07, Kory Wheatley <[EMAIL PROTECTED]> wrote:
I have a database cal
> Also, what type of database are you using? INNODB? MyISAM? If you
> are
> running MyISAM then things can get slow on updates.
Sorry, I missed where you said you were using MyISAM.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
I could be wrong BUT...
> 1) Does increasing the number of replication slaves increase query
> latency on the master? We're considering tiering the replication if
> it might help - replicate the master to two slaves, each of which
> replicates to ten clients.
The slaves should only be pulling fr
Hi guys,
We have a MySQL database that we replicate to about a dozen clients
and we hope to be increasing that number to about 15-20. The database
has two tables. One is negligably small and changes maybe once a
month. The second is about 1.3 million rows and grows at the rate of
about 800-1000
On Thu, March 1, 2007 1:37 pm, Brian Dunning wrote:
> I host at Rackspace, and one thing that their monitoring service does
> NOT catch is a problem when too many connections hit MySQL, and for
> some reason it remains hung up until the service is manually
> restarted. In the meantime, this is happ
Le 1 mars 07 à 20:46, Chris McKeever a écrit :
On 3/1/07, Brian Dunning <[EMAIL PROTECTED]> wrote:
Is there such a thing as a PHP script that I can put on a cron job to
run every minute and make a test query, and upon failure, restart the
service and maybe send an email to Rackspace support?
On 3/1/07, Brian Dunning <[EMAIL PROTECTED]> wrote:
Is there such a thing as a PHP script that I can put on a cron job to
run every minute and make a test query, and upon failure, restart the
service and maybe send an email to Rackspace support? I don't know
how you'd check that the query was re
I host at Rackspace, and one thing that their monitoring service does
NOT catch is a problem when too many connections hit MySQL, and for
some reason it remains hung up until the service is manually
restarted. In the meantime, this is happening to us once or twice a
month. It gets hammered
Dear MySQL users,
We are proud to present to you the MySQL Server 5.1.16 Beta
release, a new Beta version of the popular open source database.
Bear in mind that this is a beta release, and as any other pre-production
release, caution should be taken when installing on production level
systems or
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thu, 1 Mar 2007 11:47 AM
Subject: Re: [inbox] Re: Breaking Up Tables
>Hope this helps.
Sure does! Thanks a bunch :))
Tony
AOL now offers f
Kévin Labécot wrote:
Le 21 févr. 07 à 14:17, Kévin Labécot a écrit :
Hi,
I know this problem is already on forums and archives but I don't
understand mine !
My MySQL Server works well, there are many scripts and website using
it, without any problem.
Since few days I'm working on a new pro
> I have an unusual problem. My current production server's OS is
corrupt
> and I'm building a new one. However, due to the corruption, I can't
> move files out of it. I have a "back door" through Zope, but I can
only
> move files of a certain size (I don't know how large ;). I need to
back
> up a
Le 21 févr. 07 à 14:17, Kévin Labécot a écrit :
Hi,
I know this problem is already on forums and archives but I don't
understand mine !
My MySQL Server works well, there are many scripts and website
using it, without any problem.
Since few days I'm working on a new project and if a do (ph
It's nothing to do with MySQL. split is a command that you can find under
many flavors of Linux, and Linux-like OSes.
At the shell prompt, type:
man split
to see the documentation.
However, if you have bzip2 on your system, I would recommend running that
first, in order to compress it as much
Oops - I should have done /etc/init.d/mysql restart
Things are now working just fine. Thanks for the tip about restarting the
server!
UNIX_TIMESTAMP('2007-03-11 02:00:00') | UNIX_TIMESTAMP('2007-03-11
03:00:00')
--+-
-
I'm still not having any luck. I did
shell> /etc.init.d/mysql reload
my @@global.time_zone is still SYSTEM, and yet I still get
UNIX_TIMESTAMP('2007-03-11 02:00:00') | UNIX_TIMESTAMP('2007-03-11
03:00:00')
--+-
-
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thu, 1 Mar 2007 10:35 AM
Subject: Re: [inbox] Re: Breaking Up Tables
>if you have shell access on the server, why not just use
>split? Create your big dump file, split it into smaller
>chunks and use cat on the ot
[EMAIL PROTECTED] wrote:
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thu, 1 Mar 2007 10:00 AM
Subject: Re: Breaking Up Tables
It's nothing to do with mysqldump - it's part of the SELECT syntax for regular
queries.
Then I'm confused as to what you're sugge
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thu, 1 Mar 2007 10:00 AM
Subject: Re: Breaking Up Tables
It's nothing to do with mysqldump - it's part of the SELECT syntax for regular
queries.
Then I'm confused as to what you're suggesting I do. I ne
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thu, 1 Mar 2007 10:00 AM
Subject: Re: Breaking Up Tables
>It's nothing to do with mysqldump - it's part of the SELECT syntax for regular
>queries.
Then I'm confused as to what you're suggesting I do. I need to crea
On Thursday 01 March 2007 13:43:38 [EMAIL PROTECTED] wrote:
> >Otherwise you're looking at perhaps select limit 0,1000, 1000,1000,
> > 2000,1000
> >
> >etc ..
>
> Can you clean up this command? I can't find documentation on the select
> limit part of a mysqldump command.
It's nothing to do with my
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thu, 1 Mar 2007 6:01 AM
Subject: Re: Breaking Up Tables
>Otherwise you're looking at perhaps select limit 0,1000, 1000,1000, 2000,1000
>etc ..
Can you clean up this command? I can't find documentation on the sel
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 01, 2007 4:57 AM
> To: mysql@lists.mysql.com
> Subject: Breaking Up Tables
>
> Hi;
> I have an unusual problem. My current production server's OS is corrupt
> and I'm building a new one. Howe
On Thursday 01 March 2007 09:56:41 [EMAIL PROTECTED] wrote:
> Hi;
> I have an unusual problem. My current production server's OS is corrupt and
> I'm building a new one. However, due to the corruption, I can't move files
> out of it. I have a "back door" through Zope, but I can only move files of
>
Hi;
I have an unusual problem. My current production server's OS is corrupt and I'm
building a new one. However, due to the corruption, I can't move files out of
it. I have a "back door" through Zope, but I can only move files of a certain
size (I don't know how large ;). I need to back up a cer
Thanx for all the messages but I wasn't talking about the list
"mysql@lists.mysql.com"... I get all those mails... I was talking
about the speficic certification list "[EMAIL PROTECTED]".
(Sorry for not being that clear !)
And still no words about maximum space between DEV1 and DEV2 !!!
Thanx
-
SQLServer2000:Item ColorQuantity
--
TableBlue 124
TableRed 223
Chai
33 matches
Mail list logo
