Problem: Too many connections

Hi, I have a live site using mysql. It is heavily used with over thousand users per minute, with 3 select / update  queries per user per minute accounting to over 3000 queries per minute. The problem is that many times connection to this mysql server fails with the error "Too many connection"

insert - select from two different applications race condition?

I have a simple problem... I'm using mysql 4.1.9/innodb table and two small python applications A and B first application A is executed, and do a simple INSERT into a table then application B is executed: - B does a SELECT in the same table, that should return the entry created by application A (

./mysql_install_db: line 86: my_print_defaults: command not found

Hi All, after experiencing trouble with the rpm install on Fedora3, I went with the tar install. All went well, until I got to this part of the install manual, After you complete the procedure and have the server running, you should assign passwords to the accounts created by *mysql_install_db*

./configure issue

Dear Sirs: I attempted another mysql install on an exact same system that failed, although following the same process on server #1 succeeded. Here is the output of ./configure, which tries to start the mysql server, but shuts it down immediately: cabuov02:/opt/apps/mysql# ./configure NOTE: T

Fwd: ./configure issue

Dear Sirs: I attempted another mysql install on an exact same system that failed, although following the same process on server #1 succeeded. Here is the output of ./configure, which tries to start the mysql server, but shuts it down immediately: cabuov02:/opt/apps/mysql# ./configure NOTE: T

mysql error nr.0

Using MySQL version 4.0, I am trying to backup my database using MySQL Administrator. When executing the backup I get error "mysql error nr.0" which doesn't tell me much. I did a Google search on the error and it didn't tell me much. Can anyone shed light on this error message? Thanks. Dari

Re: Better option then polling ?

> There's nothing wrong with polling as long as it's > moderate and it doesn't lock resources. > > On a heavily updated table in a large volumen site, it > scales much better than nasty triggers or events > firing all over the place. > > Triggers are intended to maintain internal database > consi

Re: Lock timeout problem

Mauricio, - Original Message - From: "Mauricio Pellegrini" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, March 11, 2005 9:13 PM Subject: Lock timeout problem Hi, we are using mysql 4.1.4-gamma and a few days ago we started to receive lock wait timeout messages fro

Re: Better option then polling ?

There's nothing wrong with polling as long as it's moderate and it doesn't lock resources. On a heavily updated table in a large volumen site, it scales much better than nasty triggers or events firing all over the place. Triggers are intended to maintain internal database consistency by enforcin

Configure issue

Dear Sirs: I attempted another mysql install on an exact same system that failed, although following the same process on server #1 succeeded. Here is the output of ./configure, which tries to start the mysql server, but shuts it down immediately: cabuov02:/opt/apps/mysql# ./configure NOTE: This i

FW: Configure issue

> Dear Sirs: > > I attempted another mysql install on an exact same system that failed, > although following the same process on server #1 succeeded. Here is > the output of ./configure, which tries to start the mysql server, but > shuts it down immediately: > > cabuov02:/opt/apps/mysql# ./config

Auto loading a table

I have a table fsearch_temp I use it as a memory table to keep things light and fast but after a restart I want to repopulate some data automatically.  So I thought I just said load from TEST2 which would by a myisam table containing the hardbackup I need.  But obviously not the right way of

Lock timeout problem

Hi, we are using mysql 4.1.4-gamma and a few days ago we started to receive lock wait timeout messages from within our application also on other connections via tcp/ip ( from mysql clients ) the same thing happens While we are trying to discover what is causing these errors I've noted this in the

Creating a Strong Brand

Title: KennoMedia Newsletter Dear Sir or Madam,Kenno Media provides all the necessary solutions for branding, corporate ID, web design and web development to create strong brands. Whenever you need to outsource your projects, we are ready to provide

Re: Selecting a 'Constant' result set?

"Fan, Wellington" <[EMAIL PROTECTED]> wrote on 03/11/2005 01:09:13 PM: > Hello MySQL'ers, > > Is there a way to return a simple table of one-column, with *fixed* output? > For example, I would like to return a one-column, 3-record table: > > - > | value | > - > | 'a' | > -

Selecting a 'Constant' result set?

Hello MySQL'ers, Is there a way to return a simple table of one-column, with *fixed* output? For example, I would like to return a one-column, 3-record table: - | value | - | 'a' | - | 'b' | - | 'c' | - Where I have specified 'a','b' and 'c' somewhe

Re: mysql replication with one database

Hello. Use --replicate-do-db=db_name See: http://dev.mysql.com/doc/mysql/en/replication-options.html [snip] I have two mysql server A,B. I'm using the replication between these servers. But i want to the replication work with just one database. Example: A server: database1, da

Re: configuring Mysql Query Browser with charset latin5

Hello. The general way to order a MySQL client to use some encoding is to execute SET NAMES 'encoding'. See: http://dev.mysql.com/doc/mysql/en/charset-connection.html But, as said at: http://bugs.mysql.com/bug.php?id=6982 Query Browser starts a new session for every new query, excep

Re: Mysql Deamon Stop Automatically

Hello. What is in the error log? See: http://dev.mysql.com/doc/mysql/en/error-log.html "Suresh" <[EMAIL PROTECTED]> wrote: > Hi Team, > > My Server's deamon goes down automatically, what are the basic steps to root > cause. > > Thanks > Suresh > > > -- For technical

Re: where to get a mysql licence

Hello. [EMAIL PROTECTED] "Bungarz, Kai" <[EMAIL PROTECTED]> wrote: > Hi! > I wonder, where i can get answers about mysql licences. > Does anybody know an adress to contact to? > Best regards, > Kai > > http://www.wido.de > > > -- For technical support contracts, goto ht

Re: Reg creating log

Hello. You may use --tee option of mysql to store the results in the file. Or just redirect the output: mysql -uroot db_name < 'input_file' >'output_file'. See: http://dev.mysql.com/doc/mysql/en/mysql-commands.html [EMAIL PROTECTED] wrote: > > Hi, > > What is the comm

Re: Delays in replication and internet latency

Hello. You may use --slave_compressed_protocol=1. See: http://dev.mysql.com/doc/mysql/en/replication-options.html "Andrew Braithwaite" <[EMAIL PROTECTED]> wrote: > Hi, > > We have replication running here and it has been excellent for a number > of years. =20 > > Recently we ha

MySQL 4.0.24 has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.24, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/download

MySQL 4.1.10a has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.1.10a, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloa

Re: Optimizing a big query...

At 09:18 AM 3/11/2005, sam wun wrote: mos wrote: At 07:01 PM 3/10/2005, Chris W. Parker wrote: Homam S.A. on Wednesday, March 09, 2005 5:09 PM said: > If your tables are mostly read-only, you could > pre-generate page numbers on a periodic basis and > select only spec

How to determine how many ibdata files are needed?

Using MySQL 4.1.10, SuSE 8.2 Pro, reiser file system. Hi: I have been trying to locate a reference which would provide guidelines to determine if one ibdata should be used, or when to use several (two, three, etc.), but I can not seem to find anything in the manual. I have tried a single ibdat

Re: Replication only DB

Remember replicate-do-db doesn't look at queries to decide which ones to replicate. It only looks at the USE flag. This is very important: http://dev.mysql.com/doc/mysql/en/replication-options.html> Tells the slave to restrict replication to statements where the default database (that is, the one

Re: Replication only DB

replicate-do-db came in with 3.23.16, and it's in the manual (though the online search engine mishandles a search for 'replicate-do-db'--look under 'Replication startup options'). PB - Steve Buehler wrote: At 02:35 AM 3/11/2005, you wrote: You can simply specify the database: --replicate-do-

Re: Replication only DB

Steve Buehler <[EMAIL PROTECTED]> wrote on 03/11/2005 10:10:57 AM: > At 02:35 AM 3/11/2005, you wrote: > > >You can simply specify the database: > > > >--replicate-do-db=db_name > > Stupid/Not so Stupid question here. What mysql program has that option? I > searched mysql.com and couldn't fi

Re: Optimizing a big query...

mos wrote: At 07:01 PM 3/10/2005, Chris W. Parker wrote: Homam S.A. on Wednesday, March 09, 2005 5:09 PM said: > If your tables are mostly read-only, you could > pre-generate page numbers on a periodic basis and > select only specific ranges WHERE row_number BETWEEN >

Re: Replication only DB

At 02:35 AM 3/11/2005, you wrote: You can simply specify the database: --replicate-do-db=db_name Stupid/Not so Stupid question here. What mysql program has that option? I searched mysql.com and couldn't find it. I have looked at the man pages for mysql, mysqld, mysqladmin and mysqldump and did

Re: error 2002:

John Trammell wrote: Is the mysqld daemon running? (It should be.) What does the command ps aux | grep mysqld say? -Original Message- From: Mark Sargent [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 8:52 AM To: mysql@lists.mysql.com Subject: error 2002: Hi All, I get the

Re: Multiple 1-1 tables better performance

"Richard Lynch" <[EMAIL PROTECTED]> wrote on 03/10/2005 05:13:09 PM: > Apologies if this comes through twice... > I *think* I fargled the To: the first time... > > My boss is claiming that having multiple 1-1 tables, with an index on the > keys, is better performance. > > Example of his claim:

RE: error 2002:

Is the mysqld daemon running? (It should be.) What does the command ps aux | grep mysqld say? > -Original Message- > From: Mark Sargent [mailto:[EMAIL PROTECTED] > Sent: Friday, March 11, 2005 8:52 AM > To: mysql@lists.mysql.com > Subject: error 2002: > > Hi All, > > I get the f

error 2002:

Hi All, I get the following error in Fedora3 when trying to run mysql from the cli, [EMAIL PROTECTED] mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I installed mysql via yum. I'm rather new to Linux and even more so to MysSQL. Cheers

Delays in replication and internet latency

Hi, We have replication running here and it has been excellent for a number of years. Recently we have been having lag in replication from London to Palo Alto (Plenty of bandwidth but a latency of 300ms round trip). The replications binlogs are being written at a rate of about 100MB to 200MB

Re: mysql_install_db problem

jose wrote: I´ve problems with mysql_install_db I´m trying to install mysql (last version 4.1.10) in a x86 solaris 10 release. I prove with other version of solaris like 9 or 8 and always is the same result. The system return a core file but give me none log error. One strange thing is that was abl

Re: How does one choose between MySQL and MaxDB?

Hello Darrell, all, this is a question which cannot be answered completely IMO. Also, as people's backgrounds differ, I may fail to find words which you understand the way I meant them - please take this into account. Am Do, den 10.03.2005 schrieb Darrell A. Sullivan, II um 17:17: > Hello, > >

mysql_install_db problem

I´ve problems with mysql_install_db I´m trying to install mysql (last version 4.1.10) in a x86 solaris 10 release. I prove with other version of solaris like 9 or 8 and always is the same result. The system return a core file but give me none log error. One strange thing is that was able to install

Security Flaw

Hi, i've found a security flaw on mysql server for windows, but i'm not sure that the exploitation is possible in a real life condition. This bug allows an authenticaded user to cause the service to fail. In order to exploit this vulnerability, an user must own well-defined privileges on *.*. My qu

Reg creating log

Hi, What is the command to create log file while executing mysql command. I.e I want to run a file using mysql as follows Mysql -uroot db_name < "Inputfile" I want to log the above results into a log file, to do the same what option I have to use here with mysql

Re: Problem in a very simple SQL statement

Arghh... shame on me forever. I'm speachless. Mikhail Entaltsev wrote: Missed FROM clause... ;) Best regards, Mikhail. - Original Message - From: "Mário Gamito" <[EMAIL PROTECTED]> To: Sent: Friday, March 11, 2005 1:49 PM Subject: Problem in a very simple SQL statement Hi, Why do i get

RE: Problem in a very simple SQL statement

[snip] select count(email) where email='[EMAIL PROTECTED]'; [/snip] select count(email) FROM TABLE where email='[EMAIL PROTECTED]'; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem in a very simple SQL statement

Missed FROM clause... ;) Best regards, Mikhail. - Original Message - From: "Mário Gamito" <[EMAIL PROTECTED]> To: Sent: Friday, March 11, 2005 1:49 PM Subject: Problem in a very simple SQL statement > Hi, > > Why do i get an error on this statement: > > select count(email) where email

Problem in a very simple SQL statement

Hi, Why do i get an error on this statement: select count(email) where email='[EMAIL PROTECTED]'; The error is: "ERROR 1064: You have an error in your SQL syntax near 'where email='[EMAIL PROTECTED]'' at line 1" The statement seems pretty clear to me, but obviously something's wrong. What can it

Problem with source distribution in installation

Most respectfully, I would like to get support regarding my problem. Description: I have installed Linux RedHat 9 (Shrike) now i am going to install Mysql-3.23.54a in Linux by compiling source code of respective package which has been downloaded from this site http://downloads.mysql.com/archives.

Re: Better option then polling ?

On 11.03.2005 08:18 (+0100), Michael Gale wrote: > I have a table in a database that is constantly being updated with new > information. I would like to be notified if certain information gets > committed. > > Lets say for example the table gets updated every time a login attempt > happens rega

Re: Better option then polling ?

Hello, > I am fairly new to mysql and have a strange request I am not sure > if "stored procedures" will solve this. > > I have a table in a database that is constantly being updated with new > information. I would like to be notified if certain information gets > committed. > > Lets say for

Re: Better option then polling ?

Michael Gale wrote: Hello, I am fairly new to mysql and have a strange request I am not sure if "stored procedures" will solve this. I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed. I thin

mysql replication with one database

Hi All! I have two mysql server A,B. I'm using the replication between these servers. But i want to the replication work with just one database. Example: A server: database1, database2, database3 B server: database1, database4, database5 The A.database1 and B.database1 is same! I want replic

Re: Replication only DB

You can simply specify the database: --replicate-do-db=db_name On Fri, 11 Mar 2005 09:24:38 +0100, Arcangelo Casavola <[EMAIL PROTECTED]> wrote: > Hi, > > I've master with mysql 4.1.10 > slave with mysql 4.0.18 > > On my two servers i have many database, can I do a replication of only 1 DB? >

Replication only DB

Hi, I've master with mysql 4.1.10 slave with mysql 4.0.18 On my two servers i have many database, can I do a replication of only 1 DB? thank Arcangelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]