RE: Replication with HEAP tables slave insert error

2004-02-02 Thread Vinod Panicker
Hi Egor, Thanks for the reply. My responses below - Vinod Panicker [EMAIL PROTECTED] wrote: Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only

Replication with HEAP tables slave insert error

2004-02-01 Thread Vinod Panicker
doesn't create a disk file, I cant get a snapshot using tar. Also, the slave stopped due to an error of a duplicate key! Why should it have a problem with inserting data that went through fine on the master? All help is welcome. Tx, Vinod. -- MySQL General Mailing List For list archives: http

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

2003-12-15 Thread Vinod Kumar Singh
) will be a disadvantage. I had a bad experience with Triggers Stored Procedures wiht SAPDB. If you are going to use have if..else like conditions, then it is not easy to work with in SAPDB. While in PostgreSQL it works flawlessly and syntaxis also very similar to Oracle plSql. Vinod -- MySQL

How to make Database access fast

2003-08-17 Thread Vinod Bhaskar
and what I have to do spead up the process. Regards, Vinod. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to speed up the access

2003-08-14 Thread Vinod Bhaskar
and disply the report and noiw the same report program is taking more than 5 min to disply. Off couce the database is growing. But there are only 4000 Records. What may be the problem and how to spead up the process? Please suggest. Regards, Vinod. -- MySQL General Mailing List For list

How to connect Web databse from Local machine

2002-10-06 Thread Vinod Bhaskar
simultaneously. I will be grateful, if any body can mail me the connecting scripts, so that I can write php scripts to update the records from local database. or can any body suggest a solution on how to update the tables. Regards, Vinod

How to connect web database from Local machine

2002-10-06 Thread Vinod Bhaskar
Hi all, I am having MySQL database on web. (eg., at www.lmcr.net). What is the PHP script which I can connect the MySQL table from my Local machine. Can anybody help me. Regards, Vinod. - Before posting, please check

Not able to insert data

2002-09-25 Thread VINOD
(bangla)or die(could not select database);? $query=insert into count (count)values (30); mysql_query($query) or die(mysql_error());? This script works fine with MySQL and Appache in a Linux machine. Please suggest me how to solve the problem Regards, Vinod

Access denited error

2002-07-27 Thread VINOD
denied for user:root@localhost (Using Passwor- dYES) Please suggest me how to over come the problem Regards, Vinod - Sify Mail - now with Anti-virus protection powered by Trend Micro, USA. Know more at http://mail.sify.com One click here

Access denied error

2002-07-05 Thread VINOD
Hi friends, I own a domain with MySQL support. I have created a database \lnet_cal\ on the web and also table \yarntype\, using PHP Myad- min on the webspace and also granted all access privileges to user \lnet_root\ to the database. I had uploaded a PHP module on the web which is

Access denied error

2002-07-05 Thread VINOD
Hi friends, I own a domain with MySQL support. I have created a database lnet_cal on the web and also table yarntype, using PHP Myad- min on the webspace and also granted all access privileges to user lnet_root to the database. I had uploaded a PHP module on the web which is

Re: Connection related SIG 11 crash in 3.23

2001-03-23 Thread vinod p
. The mysql server that i have crashes when the machine approaches 100% CPU usage. Someone told me that a 2.2 kernel downgrade will solve the problem; but i dont want to do that. I've tried on different machines and the problem remains. Tx. Vinod. --- Voytek Lapinski [EMAIL PROTECTED] wrote: Ok

Re: Mysql restarts at 100% CPU

2001-03-20 Thread vinod p
queries at that time. Tx. Vinod --- "Gerald L. Clark" [EMAIL PROTECTED] wrote: You have mysqld set for 2000 connections. How many threads do you have Linux configured for, and how many are open when Mysqld crashs? vinod p wrote: hi, thanks for the interest. The

Re: am I alone? (scale)

2001-03-18 Thread vinod p
is expected but a crash is most definitely not. As u can see, the limits are set pretty high on the system. Memory usage is not even 150MB. What's the reason? and the partial backtrace that i'm getting is the same after every crash. Any ideas? Tx. Vinod

Mysql restarts at 100% CPU

2001-03-18 Thread vinod p
hi, my mysql server restarts automatically when the machine touches 100% CPU usage. any ideas why? tx. vinod. Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in

Re: Mysql restarts at 100% CPU

2001-03-18 Thread vinod p
-variable= back_log=2900 set-variable= connect_timeout=15 set-variable= wait_timeout=57600 set-variable= interactive_timeout=57600 Tx. Vinod. --- "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote: On Mon, Mar 19, 2001 at 12:34:30AM +0000, vinod p wrote: my mysql serve

Heavy Load

2001-03-17 Thread vinod p
. I'm using latest versions of everything. Thanks, Vinod Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in - Before posting, please check

Re: Re: max connections

2001-03-03 Thread vinod panicker
). Tx. Vinod - Original Message -- "Jorge del Conde" [EMAIL PROTECTED] wrote: To:[EMAIL PROTECTED], "vinod panicker" [EMAIL PROTECTED] From:"Jorge del Conde" [EMAIL PROTECTED] Date:Sat, 3 Mar 2001 01:17:41 -0600 Subject: Re: max connec

Re: Re: Re: max connections

2001-03-03 Thread vinod panicker
increased the max_connections variable. The server runs smoothly for some time and then it just restarts without any warning... nothing in the .err file too! weird... any hope, suggestions? Tx. Vinod - Original Message -- "Jorge del Conde" [EMAIL PROTEC

Re: Re: Scaling mysql

2001-03-03 Thread vinod panicker
hey, replication was ruled out coz the writes are very very frequent. and consistency of data is a very important issue. tx. vinod - Original Message -- "Jason Landry" [EMAIL PROTECTED] wrote: To:[EMAIL PROTECTED], "vinod panicker" [EMAIL PR

max connections

2001-03-02 Thread vinod panicker
of this box. It will be accessed by multiple web servers. I also wanted to know if I can have 2 mysql servers on the same machine accessing and serving data from the *same* database... also, at what number of connections does mysql go for a toss? Tx. Vinod