replication problem if network delay

Hi All, I need small help from you. I am using Replication, i am using this technique to give live support to Support team. But my Server and Slave are not in LAN. So some times i am getting network delay. Can anybody tell me a good suggestion to over come this. regards, balaraju

Re: Trouble with using "IN" for a sub-query statement

Chris White wrote: On Monday 07 August 2006 12:13 pm, William DeMasi wrote: I meant to have it say : "select * from c2iedm_dev2.act where act_id IN (select obj_act_id from c2iedm_dev2.act_functl_assoc where subj_act_id =24);" What does the output of (the subselect): select obj_act_id from c2

Re: mysqld won't start

Charlie Stanton wrote: From: root To: mysql@lists.mysql.com Subject: mysqld won't start >Description: In an attempt to upgrade to MySQL 5.0.24 it was necessary to use "rpm -e ..." to remove version 5.0.22 then "rpm -U ..." to install the shared,server and client modules. When I

MySQL App development

Hi All, I need to develop an utility in C++ (don't want to use mysql++ lib) which provides services to other modules in the system like createTable( ), createRow( ), updateAttr( ) Etc. wherein these APIs are called dynamically by the other modules to do the DB operations. Is

Re: Transactions and testing an Insert statement

Chris W. Parker wrote: Hello, Me again. Excuse for sending two questions so closely together. I'm looking through the MySQL manual (as well as searching Google and the PHP site's MySQL functions) trying to find out how to test an Insert statement (or any other statement for that matter). Altho

Transactions and testing an Insert statement

Hello, Me again. Excuse for sending two questions so closely together. I'm looking through the MySQL manual (as well as searching Google and the PHP site's MySQL functions) trying to find out how to test an Insert statement (or any other statement for that matter). Although I haven't found a dir

RE: Delete one record, automatically delete other records...

Chris on Monday, August 07, 2006 6:19 PM said: > Foreign keys with an "on delete cascade" should do it. > > http://dev.mysql.com/doc/refman/5.1/en/example-foreign-keys.html Thanks everyone! -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: Delete one record, automatically delete other records...

Chris W. Parker wrote: Hello, I'm not sure if this is possible (or what it's called, and how to search for it) at the db layer or if this has to be done at the application layer... I would like to be able to delete one record in one table and then automatically (without making an extra call to t

RE: Delete one record, automatically delete other records...

You want cascade deletion via foreign keys. http://dev.mysql.com/doc/refman/5.1/en/ansi-diff-foreign-keys.html is one such place to learn more. Tim > -Original Message- > From: Chris W. Parker [mailto:[EMAIL PROTECTED] > Sent: Monday, August 07, 2006 9:11 PM > To: mysql@lists.mysql.com

Re: Delete one record, automatically delete other records...

On 8/7/06, Chris W. Parker <[EMAIL PROTECTED]> wrote: Hello, I'm not sure if this is possible (or what it's called, and how to search for it) at the db layer or if this has to be done at the application layer... I would like to be able to delete one record in one table and then automatically (wi

Re: MySQL SQL statistics

On 8/7/06, 古雷 <[EMAIL PROTECTED]> wrote: Thanks a lot for your reply. I need know SQLs that consume most resources(CPU time, disk IO etc.) of database server. If its an application, you can use EXPLAIN to find out how MySQL is processing the most used queries, and use this knowledge to optim

Delete one record, automatically delete other records...

Hello, I'm not sure if this is possible (or what it's called, and how to search for it) at the db layer or if this has to be done at the application layer... I would like to be able to delete one record in one table and then automatically (without making an extra call to the db) delete other recor

Re: MySQL SQL statistics

Thanks a lot for your reply. I need know SQLs that consume most resources(CPU time, disk IO etc.) of database server. Sometimes the same SQL could be executed many times to hold most time of CPU. Sometimes executed only one time. Maybe I can say I am looking for something like STATSPACK of Orac

Re: Is MySQL 5.0 MyISAM table format backward compatible with 4.1?

At 05:00 PM 8/7/2006, you wrote: Mike, if this data is at all important to you, I'd highly recommend doing your testing on copies of your data files, rather than your originals. If it's not important, then I'd go ahead and try it. The MyISAM storage engine is pretty mature and stable. For safe

Load Data Infile and newlines

I'm trying to use LOAD DATA INFILE to read a csv formatted file into a mysql 5.0.22 table. Some of the fields contain text that has newline characters in it. After reading the manual to learn how special characters are treated, I altered the csv file so newlines are represented by '\\n', that

Re: Database design question

On 8/7/06, James Tu <[EMAIL PROTECTED]> wrote: If I create a table for each user (I can potentially have hundreds of thousands of users), will MySQL be able to handle this? If I just have one table, I could potentially have millions of records in one table. Will MySQL be able to handle this?

Re: Is MySQL 5.0 MyISAM table format backward compatible with 4.1?

Mike, if this data is at all important to you, I'd highly recommend doing your testing on copies of your data files, rather than your originals. If it's not important, then I'd go ahead and try it. The MyISAM storage engine is pretty mature and stable. For safety's sake once you get it back to

Re: MySQL Load Balancing

Ed Pauley II wrote: Continuent's m/cluster will not work for me as it does not allow replication across a WAN. We have an offsite backup that needs to be in the replication (2-way to make switching back and forth easy) chain. I am thinking of a master, slave setup at each location where

Is MySQL 5.0 MyISAM table format backward compatible with 4.1?

I'm planning on installing MySQL 5.0 today and will try rebuilding some of the indexes for one of my tables to conduct some benchmarks. I will probably reboot back to MySQL 4.10 and continue using the database. Have the table formats changed from 4.10 to 5.0? Or can I create/modify tables in 5.

Re: Database design question

Wow, I didn't know that can happen. I'll definitely take that into consideration. Thanks Brent. On Aug 7, 2006, at 4:26 PM, Brent Baisley wrote: If you're looking to be put at ease, I've got a table with 250+ million records, but I've heard of people with larger tables than that on this

Re: Database design question

Thanks everyone. Now I feel confident that one table will be fine (Tripp's stat of 30 million records put me at ease :) ). Cheers, -James On Aug 7, 2006, at 4:08 PM, John Meyer wrote: One table, USERS Another table MESSAGES With a foreign key referencing users. Maybe a second foreign key r

RE: Database design question

One table, USERS Another table MESSAGES With a foreign key referencing users. Maybe a second foreign key referencing the destinating user as well. -Original Message- From: James Tu [mailto:[EMAIL PROTECTED] Sent: Monday, August 07, 2006 1:56 PM To: mysql@lists.mysql.com Subject: Databa

Re: Database design question

I want to design a database for lots of users. Each user will be managing their own messages. Does it make sense to create a table for each user after they've registered? Or should I just create one MESSAGES table and store messages there keyed off of their user_id? If I create a table for e

Database design question

I want to design a database for lots of users. Each user will be managing their own messages. Does it make sense to create a table for each user after they've registered? Or should I just create one MESSAGES table and store messages there keyed off of their user_id? If I create a table fo

Re: Trouble with using "IN" for a sub-query statement

On Monday 07 August 2006 12:13 pm, William DeMasi wrote: > I meant to have it say : > > "select * from c2iedm_dev2.act where act_id IN (select obj_act_id from > > c2iedm_dev2.act_functl_assoc where subj_act_id =24);" What does the output of (the subselect): select obj_act_id from c2iedm_dev2.act_

Re: Trouble with using "IN" for a sub-query statement

On Monday 07 August 2006 12:02 pm, William DeMasi wrote: > The select statement I am trying to run is: > "select * from c2iedm_dev2.act where act_id =(select obj_act_id from > c2iedm_dev2.act_functl_assoc where subj_act_id =24);" Well the problem I'm seeing is that you're not using IN anywhere in

Trouble with using "IN" for a sub-query statement

The select statement I am trying to run is: "select * from c2iedm_dev2.act where act_id =(select obj_act_id from c2iedm_dev2.act_functl_assoc where subj_act_id =24);" But I get the error below: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version f

Re: MySQL Load Balancing

Peter Zaitsev wrote: On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II wrote: I am looking into a scale-out solution for MySQL. I have read white papers and searched the web but I can't find a load balancer that claims to work well for MySQL. MySQL's white paper shows NetScaler in the scale-

mysqld won't start

From: root To: mysql@lists.mysql.com Subject: mysqld won't start >Description: In an attempt to upgrade to MySQL 5.0.24 it was necessary to use "rpm -e ..." to remove version 5.0.22 then "rpm -U ..." to install the shared,server and client modules. When I do a "rpm -qa" it shows t

ODBC - MySQL 5 bug!

Good day, After a whole day of researching I finally found an answer for Ms Access not displaying the columns of more than one table in a MySQL 5 view... The bugfix was posted in a mysql forum here: http://forums.mysql.com/read.php?65,52721,100434#msg-100434 which contains a link to a download fi

Re: MySQL SQL statistics

On 8/7/06, 古雷 <[EMAIL PROTECTED]> wrote: Hello everyone: I want to get some SQL statistics including executions, CPU time for each SQL Statement. The number of each type of query can be found using the "show status like 'Com%';", I don't believe there's a way to know how much CPU time MySQL i

Re: Problems connecting using "-h hostname" with new installation

On 8/6/06, Ro BGCT <[EMAIL PROTECTED]> wrote: Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the foll

Re: text mode listing

On 8/6/06, Bill <[EMAIL PROTECTED]> wrote: Hi Can you remind me how to tell mysql to list vertically instead of horiz in text mode? Ex: select all * from a_tablesends field1 field2 . I want field1 field2 field... Thanks if you type help you can find a lot o information mysql>

Re: Problems connecting using "-h hostname" with new installation

On 8/6/06, Ro BGCT <[EMAIL PROTECTED]> wrote: Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the foll

Re: Code snippet to run at database service startup

On 8/7/06, Asif Lodhi <[EMAIL PROTECTED]> wrote: Hi, What if I want certain variables initialized and certain code to run at the database service startup? I am running 5.0.22 on Windows XP Service Pack 2. Are there any tirggers that can tell me that the database is starting up? You can writ

RE: determine safest value for max_connections

> This might help you > http://kjalleda.googlepages.com/maxconnbymysql > > Kishore Jalleda Thanks Kishore. Regards, Rithish.

Code snippet to run at database service startup

Hi, What if I want certain variables initialized and certain code to run at the database service startup? I am running 5.0.22 on Windows XP Service Pack 2. Are there any tirggers that can tell me that the database is starting up? -- Thanks in advance, Asif -- MySQL General Mailing List For l

Re: where may I find sqlplus.hh??

Greg 'groggy' Lehey wrote: I have downloaded a code on c++ to talk to MySQL database from net which included a file "sqlplus.hh" , where may I find the file?Please help me soon. That's the main header file for MySQL++ v1.7.9. You can download that release from the official MySQL++ page:

Re: Text search + transactions?

Peter Zaitsev wrote: Right. If you want full text search to follow transaction isolation as well you're in trouble.In most search applications however it is not that critical. Thats a pity. I will have to port the application to PostgreSQL then. Thanks anyway, LL -- MySQL General

Re: Text search + transactions?

On Mon, 2006-08-07 at 09:49 +0100, Lexington Luthor wrote: > Peter Zaitsev wrote: > > Hi, > > > > One of approaches is to have "shadow" MyISAM table in addition to your > > Innodb table to perform full text search, which you can update in bulks > > or via triggers. > > How can I ensure isolation

Re: Text search + transactions?

Peter Zaitsev wrote: Hi, One of approaches is to have "shadow" MyISAM table in addition to your Innodb table to perform full text search, which you can update in bulks or via triggers. How can I ensure isolation for queries on this "shadow" table? The documentation says that the table type d

Re: maximum files size for longblob - what is bigger?

On Mon, 2006-08-07 at 09:18 +0100, [EMAIL PROTECTED] wrote: > what us the maximum filesize for longblobs in kb? Is there anything bigger? http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html As you can see in theory it is about 4GB. It is however also limited by max_packet_size which

Re: maximum files size for longblob - what is bigger?

[EMAIL PROTECTED] wrote: what us the maximum filesize for longblobs in kb? Is there anything bigger? That's answered in the documentation - http://dev.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC

Query two databases

Hi. I'm running MySQL on a Windows 2003 server and connecting using classic ASP. I'm trying to connect and query two databases using a statement like: strSQLCombo = "select sfproducts.products.sku as psku, sfproducts.products.sortName, sum(mcomorderentry.order_items.quantity-mcomorderentry.or

maximum files size for longblob - what is bigger?

what us the maximum filesize for longblobs in kb? Is there anything bigger? Ross

Re: Text search + transactions?

On Mon, 2006-08-07 at 08:49 +0100, Lexington Luthor wrote: > Hi, > > I need fast text searching on a transactional table. Is it possible to > use transactions and text-search on a table together yet in any > production stable version of mysql? Hi, One of approaches is to have "shadow" MyISAM

MySQL SQL statistics

Hello everyone: I want to get some SQL statistics including executions, CPU time for each SQL Statement. How can I get it from MySQL? regards, Gu Lei

Text search + transactions?

Hi, I need fast text searching on a transactional table. Is it possible to use transactions and text-search on a table together yet in any production stable version of mysql? Thanks, LL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l