MySQL Master and Slave Database Setup

Hi, I need to run a longer running insert and test it in the Master Slave Replication Database Server. And interrupt the Insert query on the Master and check on slave to ensure that the data is in sync. How can i do it, are there benchmark tools to do that. Thanks and Regards Kaushal

Re: MySQL Master and Slave Database Setup

Use the below link to know how to setup replication. http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html regards anandkl On 4/15/08, Kaushal Shriyan [EMAIL PROTECTED] wrote: Hi, I need to run a longer running insert and test it in the Master Slave Replication Database Server. And

Re: why doesn't mysql select the correnct index?

Changying Li schrieb: why does mysql use group_id index ? because in this case group_id would be faster than user_id but in fact group_id is very slow (51.21 sec), user_id is (0.00 sec) ok, at least MySQL does think so I know, but I what I really want to know is how does mysql think so ?

Re: Incorrect results from sum

Jonathan Mangin schrieb: I'm trying to total certain nutrients consumed on a given date (though I've removed date temporarily). You'll see I have three items (in two meals) in itemized, and two meal totals in simple. mysql select id, item, carb from my_menu where id in (10, 11, 22);

problems w/ Replication over the Internet

I have a setup with a master and a bunch of slaves in my LAN as well as one external slave that is running on a Xen-Server on the internet. All servers run Debian Linux and its mysql version 5.0.32 Binlogs are around 2 GB per day. I have no trouble at all with my local slaves, but the external one

Re: Two MySql servers, but very different performances for a SELECT JOIN

I'm still trying to decript the EXPLAIN result, and there is something I really don't understand: mysql EXPLAIN SELECT STRAIGHT_JOIN media.* FROM country,content,media WHERE country.id='Germany' AND country.detail_tid=content.tid AND content.id=media.content_id; On the FAST server:

Re: why doesn't mysql select the correnct index?

Sebastian Mendel [EMAIL PROTECTED] writes: Changying Li schrieb: why does mysql use group_id index ? because in this case group_id would be faster than user_id but in fact group_id is very slow (51.21 sec), user_id is (0.00 sec) ok, at least MySQL does think so I know, but I what I really

grant user privileges

hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same as internal. how do i do this??? i tried (as root): grant all on test.* to

Re: Incorrect results from sum

On Tue, Apr 15, 2008 at 4:21 AM, Sebastian Mendel [EMAIL PROTECTED] wrote: use UNION You can't use UNION to add the results of two queries. It would return two rows. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

changing name of tables into UPPER CASE

Hi ALL,, I am new to perl, I have a database which works fine in windows, Now i need to change table names to uppercase in Linux. So I have done the following: I copied all the from files into /var/lib/mysql/new_db from windows to linux. Then changed the names to caps; and changed the

Re: changing name of tables into UPPER CASE

perl pra schrieb: Hi ALL,, I am new to perl, I have a database which works fine in windows, Now i need to change table names to uppercase in Linux. So I have done the following: I copied all the from files into /var/lib/mysql/new_db from windows to linux. Then changed the names to caps;

Re: Incorrect results from sum

Perrin Harkins schrieb: On Tue, Apr 15, 2008 at 4:21 AM, Sebastian Mendel [EMAIL PROTECTED] wrote: use UNION You can't use UNION to add the results of two queries. It would return two rows. of course! you need to use this UNION as subquery sorry for being not imprecise -- Sebastian --

Re: Create table

At 10:32 AM +0530 4/15/08, Krishna Chandra Prajapati wrote: Hi, I have created a table name group. CREATE TABLE `group` ( `group_id` int(11) NOT NULL, `group_name` varchar(128) NOT NULL, `date_created` datetime NOT NULL, `created_by` int(11) NOT NULL, `modified_by` int(11) default

Find two sets of records

I'm drawing a blank here. I need to extract two sets of records from a pair of tables. `eo_name_table` is a list of titles, `prod` is a list of products having titles and a discontinued flag. I want all of those records from `eo_name_table` that do not have a matching title in `prod`. I also want

Re: Two MySql servers, but very different performances for a SELECT JOIN

On Tue, April 15, 2008 02:03, [EMAIL PROTECTED] wrote: I'm still trying to decript the EXPLAIN result, and there is something I really don't understand: mysql EXPLAIN SELECT STRAIGHT_JOIN media.* FROM country,content,media WHERE country.id='Germany' AND country.detail_tid=content.tid AND

Re: Two MySql servers, but very different performances for a SELECT JOIN

On Tue, Apr 15, 2008 at 9:05 AM, Wm Mussatto [EMAIL PROTECTED] wrote: Possible key refers to the keys that the server thinks might be usable. key refers to the one is chose. On the slow server it decided that the possible key would not work so it didn't use it. You might try to force the

Re: Strange performance problem

It's possibly a DNS problem (reverse DNS exactly). Best regards.

[Stored Procedure] - Error handling

Hello folks, Any way to retrieve the error code/error number from a stored proc. Scenario -- calling a stored proc from PHP - using mysqli_multi_query() The stored proc has multiple queries. Lets say one of the queries generates an exception. How do I retrieve the error message

Re: SQL query question for GROUP BY

I just thought of something else... could the same be accomplished using stored routines? I could find no way in MySQL to create stored routines which could be used with the 'group by' queries though. If this were possible, it should then be also possible to define a 'LAST' stored routine,

Re: [Stored Procedure] - Error handling

Ratheesh, There's a specific list for PHP database functions, Databases and PHP (PHP-DB), which you can find at http://php.net/mailinglists . I'm forwarding your message over to there, and recommend that you subscribe to that list. You'll probably get more direct responses by

Re: SQL query question for GROUP BY

On Fri, Apr 11, 2008 at 4:01 PM, Victor Danilchenko [EMAIL PROTECTED] wrote: Oooh, this looks evil. It seems like such a simple thing. I guess creating max(log_date) as a field, and then joining on it, is a solution -- but my actual query (not the abridged version) is already half a

Re: Create table

Hi, If you really need to call it group, try using : `group` in your query (use the ` thing) Regards, Velen - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Krishna Chandra Prajapati [EMAIL PROTECTED]; mysql mysql@lists.mysql.com Sent: Tuesday, April 15, 2008 6:27 PM

Spring 2008 MySQL Magazine released!!

Hey everyone, I just posted the Spring issue of the MySQL Magazine. This issue contains a great group of articles that you will want to read. In addition, Sheeri Cabral did a fabulous job with a new layout for the magazine. It is as always FREE!!. Available for download from

Re: Spring 2008 MySQL Magazine released!!

On Tue, Apr 15, 2008 at 2:20 PM, B. Keith Murphy [EMAIL PROTECTED] wrote: Hey everyone, I just posted the Spring issue of the MySQL Magazine. This issue contains a great group of articles that you will want to read. In addition, Sheeri Cabral did a fabulous job with a new layout for the

Re: Create table

On Tue, Apr 15, 2008 at 7:27 AM, Paul DuBois [EMAIL PROTECTED] wrote: At 10:32 AM +0530 4/15/08, Krishna Chandra Prajapati wrote: Hi, I have created a table name group. CREATE TABLE `group` ( `group_id` int(11) NOT NULL, `group_name` varchar(128) NOT NULL, `date_created`

Mysqldump

Hi Gurus, I am a newbie.Please bear with me. Could someone pls guide me as to the best way of adding excel files as tables to Mysql ? Thanks

Re: Mysqldump

On Tue, Apr 15, 2008 at 3:11 PM, minky arora [EMAIL PROTECTED] wrote: Hi Gurus, I am a newbie.Please bear with me. Could someone pls guide me as to the best way of adding excel files as tables to Mysql ? mysqldump is for exporting data. What you're looking for is the LOAD DATA [LOCAL]

Re: Spring 2008 MySQL Magazine released!!

Daniel, Thanks for pointing that out. I haven't heard of this before so I really don't have a clue. We use Openoffice 2.4 to create the magazine and generate the pdf. It works fine in both OO and adobe acrobat (I am blessed with a Windows laptop). Keith Daniel Brown wrote: On Tue, Apr

JDBC error: sql: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'gname' at row 0

Have identical versions installed, in one query works fine, in another, pukes with the error in the subject. When I query by hand (via mysql client) works fine. Not even that much data to complain about! mysql select - group_concat(concat('',hosts.name,'') order by hosts.name asc

Re: Mysqldump

Am Dienstag, den 15.04.2008, 15:11 -0400 schrieb minky arora: Could someone pls guide me as to the best way of adding excel files as tables to Mysql ? You can import CSV files into MySQL: http://dev.mysql.com/doc/refman/5.1/en/load-data.html Norbert -- MySQL General Mailing List For

Does version 4 mysqlcheck close MyISAM tables left open?

Unable to find this in the manual ... Yesterday morning we rebooted the server by accident, which crashed and restarted MySQL 4.1. Late last night a scheduled job ran mysqlcheck and found 4 open tables. When I next ran mysqlcheck it found nothing wrong. mysqlcheck command: CHECK TABLE $DBTABLES

mysqldump

Thanks. I will successful in executing LOAD DATA INFILE Now i need to do a SqlDump as well to get a backup of the DB..I looked at the syntax but am not sure if /what all options to use. I only have one DB. Could someone tell me if I really need to specify any options ?

select does too much work to find rows where primary key does not match

I have two MyISAM tables; each uses 'phone' as a primary key. Finding rows where the primary keys match is efficient: mysql explain select bar.phone from foo,bar where foo.phone=bar.phone; ++-+---++---+-

Re: select does too much work to find rows where primary key does not match

I would have thought your not = though is matching a lot more rows every time.. I would look into using where not exists as a subselect delete from bar where not exists (select 'y' from foo where foo.phone = bar.phone); something like that. On Tue, Apr 15, 2008 at 5:00 PM, Patrick J. McEvoy

Re: Find two sets of records

Try using the sub query as a derived table ala: SELECT eo_name_table.eo_name, eo_name_table.eo_pub_date FROM eo_name_table LEFT JOIN (SELECT prod.prod_title FROM prod WHERE prod.prod_discont = 0) fake_prod on eo_name_table.eo_name = fake_prod.prod_title WHERE prod.prod_title IS NULL I'm not

Re: select does too much work to find rows where primary key does not match

How about using a left outer join. Find all the rows in bar without a matching row in foo: To verify: select * from bar left outer join foo on bar.phone=foo.phone where foo.phone is null Then delete bar.* from bar left outer join foo on bar.phone=foo.phone where foo.phone is null Phil

Re: select does too much work to find rows where primary key does not match

I would have thought your not = though is matching a lot more rows every time.. The field is UNIQUE PRIMARY KEY in both tables, so there should be 0 or 1 matches. I would look into using where not exists as a subselect My MySQL book (O'Reilly second edition) does not mention subqueries or

Re: grant user privileges

Can you give the output of the command show grants for admin; Thank You, -srini Hiep Nguyen wrote: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's

update select question

I have the following query... SELECT c.NLCID, n.publishdate FROM newsletter n JOIN newslettersection s using (NLID) JOIN newslettercontent c using(NLCID) WHERE contenttype = 1 AND n.publishdate AND c.`timestamp` = '-00-00 00:00:00' I want to run an update on newslettercontent and set its

Re: mysqldump

use can say mysqldump --help, it would give you all the options. To speedup the dump, you can use -e -q and --single-transaction, regards anandkl On 4/16/08, minky arora [EMAIL PROTECTED] wrote: Thanks. I will successful in executing LOAD DATA INFILE Now i need to do a SqlDump as well to

Re: update select question

Chris W schrieb: I have the following query... SELECT c.NLCID, n.publishdate FROM newsletter n JOIN newslettersection s using (NLID) JOIN newslettercontent c using(NLCID) WHERE contenttype = 1 AND n.publishdate AND c.`timestamp` = '-00-00 00:00:00' I want to run an update on

Re: grant user privileges

Hiep Nguyen schrieb: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same as internal. how do i do this??? i tried (as root):

Re: update select question

update newslettercontent c set c.timestamp= (select n.publishdate from newsletter n where n.NLCID= c.NLCID); This should work. On 4/16/08, Chris W [EMAIL PROTECTED] wrote: I have the following query... SELECT c.NLCID, n.publishdate FROM newsletter n JOIN newslettersection s using (NLID)