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
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:
Views (to a lesser degree ) 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 simila
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]
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
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
e local database
using php scripts.How do I connect web database and local database
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 b
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.
-
Sify Mail - now with Anti-virus protection powered by Trend Micro, USA.
Know more
load query, it is
showing the error on the browser that
COUNT=006
Access 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 b
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
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 whic
sort. 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 PROTE
a 100-150 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
=1
set-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 +, vinod p
> wr
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
ormance 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.
A
rnel
2.4.2. 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 postin
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 panicke
the .cnf file, i've just
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 d
and a dual CPU.
Tx.
Vinod.
_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
-
Before posting, please check:
http://www
tance).
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 -060
rmance out 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?
.sock listed as a listening
socket. How do i remove all these so that i can restart the server?
Sorry for the long mail, but I really am desperate now..
Tx.
Vinod
--
so little time, so many things to do...
_
Chat wit
23 matches
Mail list logo