Hello all,
I have struck with a big problem with MySQL 5.0.22 server on RHEL 3.
After an upgradation from MySQL 4.1.11 to MySQL 5.0.22 almost all the queries
are struggling to execute and the DB server is clogged. Below is an example of
what is happening.
This query usd to execute very fast on
Hi!
> "Peter" == Peter Lauri <[EMAIL PROTECTED]> writes:
Peter> Best group member,
Peter> My computer stopped working. And I was able to install Windows on another
Peter> partition and now I face one problem. I was running Windows with MySQL
4.1.
Peter> I have all C: working, and can acces
It was just to copy the files from the DATA folder in the installation
directory. That was easier then I thought.
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 6:52 AM
To: mysql@lists.mysql.com
Subject: Urgent problem
Best group member,
My
Best group member,
My computer stopped working. And I was able to install Windows on another
partition and now I face one problem. I was running Windows with MySQL 4.1.
I have all C: working, and can access all files.
The first question: Can I recover that data from MySQL?
The second question:
restart mysql with the skip-grants option
-Original Message-
From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:03 AM
To: [EMAIL PROTECTED]
Subject: Urgent problem
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts
TECTED]
phone: +49 941 / 78 88 7 - 121
fax : +49 941 / 78 88 7 - 20
cellphone: +49 174 / 41 94 97 0
--
> -Original Message-
> From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 13, 2003 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: Urge
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts, incl administrator)...
My problem: I use MySQLFront to change the allowed
hosts and did it for all users. They were 'localhost'
and I set them to 'localhost; EcolMod1' where the
EcolMod1 is the name of my c
Hi
I did something stupid: I locked myself out of the
MySQL server...
My problem: I use MySQLFront to change the allowed
hosts and did it for all users. They were 'localhost'
and I set them to 'localhost; EcolMod1' where the
EcolMod1 is the name of my computer where the MySQL
server is insta
Quoting Nils Valentin <[EMAIL PROTECTED]>:
> When you said you modified the scripts, are these the scripts on the 12
> webservers (mysql clients) ?
Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12
webservers
> If not, then these mysql clients (webservers) would stil
;Nils Valentin" <[EMAIL PROTECTED]>
> To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, June 27, 2003 1:30 PM
> Subject: Re: URGENT problem with mysql processes
>
>
> Hi Keith,
>
> from your last e-mail I understand no
No, the slaves replicate fine and I can see their entries in the processlist
normally (as their hostname), not as "unauthenticated user"..
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting Nils Valentin <[EMAIL PROTECTED]>:
> Hi Keith,
>
> from your last e-m
Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 1:30 PM
Subject: Re: URGENT problem with mysql processes
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying to login, but
you havent set them up on the master yet ?
Just a gu
When you said you modified the scripts, are these the scripts on the 12
webservers (mysql clients) ?
If not, then these mysql clients (webservers) would still be wanting to send
to IP addres 192.168.1.71 as configured for php or in your client.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月
Neither of these two machines send the request.
I have 12 webservers, which send the requests.
I have 5 database servers, 1 master(for updates/inserts/deletes) and 4
slaves(for selects).
Machine A below was the current Master DB server, however it is old and was
being replaced by machine B
--
Ok but that's not what I meant.
I'll try to explain better.
Machine A: IP = 192.168.1.71
Machine B: IP = 192.168.1.79
1) Scripts goto 192.168.1.71 - Everything is OK
2) Changed scripts to 192.168.1.79 - Site works at first, but processes pile up
until server is killed
3) Halt machine B
4) Gi
Hi Keith,
The wrong IP address could only avoid a client to connect to the database
server.
If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in
config.inc.php or which ever tool you use than of course it will try to
connect to this IP address.
Best regards
Nils Val
Hi Keith,
2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました:
> Major problem!
>
> I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is
>
> - quad-xeon (500mhz each cpu)
> - 3 gig RAM
> - Linux Redhat 7.3
>
> When I start up mysql, processes looking like the following begin to pile
Major problem!
I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is
- quad-xeon (500mhz each cpu)
- 3 gig RAM
- Linux Redhat 7.3
When I start up mysql, processes looking like the following begin to pile up
until it kills the server:
| 106 | unauthenticated user | 192.168.1.
Thank you for your fine bug report, thanks to which, I was able to fix
a problem.
Final fix will come up in 4.0.3, but this is a patch that fixes it
temporarily :
= /mnt/work/mysql-4.0/sql/sql_delete.cc 1.80 vs edited =
*** /tmp/sql_delete.cc-1.80-1656Tue Jul 23 18:31:17 2002
--
Hello,
I'm working on a purge utility to purge 3 tables: call_record,
modem_call_rec and makrup. Those 3 tables are related with foreign key
recid, so I used the following sql to purge data that is older than 30 days:
delete call_record, modem_call_rec, markup from call_record,
modem_call_rec
I am inserting into the table values with single Quote (MySql table).
If I give the command through text file - Insert into test values
('manisha\' test') - then this is ok, but when i try to insert the manisha
' test value through http:///sqladmin using GUI then MySql is
giving error.
Any h
Andrew,
Thursday, February 21, 2002, 3:31:16 AM, you wrote:
AB> I have created a table in the mysql db, using phpmyadmin with the following
AB> statement:
AB> create table books
AB> ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary
AB> key(isbn));
AB> which works fine
xx.x
David McInnis
-Original Message-
From: Andrew Bunkell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 5:31 PM
To: [EMAIL PROTECTED]
Subject: urgent problem with mysql and phpmyadmin
I have created a table in the mysql db, using phpmyadmin with the
following
stat
I have created a table in the mysql db, using phpmyadmin with the following
statement:
create table books
( isbn char(13) not null,author char(30),title(60),price float(4,2),primary
key(isbn));
which works fine and creates the table i need the problem comes when i try
to insert some values into
ruary 16, 2002 3:42 PM
Subject: urgent : Problem in Group by clause
hi all,
i have a problem in mysql query...
lemme state the scenario...
i have a table 'UploadDetails' in which i am storing
data regd files...
the fields are:
FileName, Title, Designer, UploadedBy, SubmittedDate
i
hi all,
i have a problem in mysql query...
lemme state the scenario...
i have a table 'UploadDetails' in which i am storing
data regd files...
the fields are:
FileName, Title, Designer, UploadedBy, SubmittedDate
i want to get details about whose files are designed
by who..etc...
that is i need
hi all,
i have a problem in mysql query...
lemme state the scenario...
i have a table 'UploadDetails' in which i am storing
data regd files...
the fields are:
FileName, Title, Designer, UploadedBy, SubmittedDate
i want to get details about whose files are designed
by who..etc...
that is i need
> when you run myisamchk it try to find the .MYI file.
> If you try to run myisamchk on the MYD file, it says that the key definition
> is incorrect (which seems to be normal ;))
The key definition should be part of the .frm file, in my
understanding. Oh, I see, myisamchk is invoked on that very
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> I'm administrating a machine which has just badly crashed, and a MYI
> file has disappeared for one table. Is this possible to repair this
> table?
Try to touch the file (to create an empty one), and see i
Hi,
I'm administrating a machine which has just badly crashed, and a MYI file has
disappeared for one table.
Is this possible to repair this table ?
BTW, REPAIR TABLE in mysql report a wrong message :
mysql> REPAIR TABLE threadhardwarefr1;
+--++--+---
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote:
> > Am 11:22 16.03.2001 schrieben Sie:
> > >*This message was transferred with a trial version of CommuniGate(tm)
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote:
> > Am 11:22 16.03.2001 schrieben Sie:
> > >*This message was transferred with a trial version of CommuniGate(tm)
On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote:
> Am 11:22 16.03.2001 schrieben Sie:
> >*This message was transferred with a trial version of CommuniGate(tm) Pro*
> >Hi there,
> >
> >i dont want to start a thread about MySQL over NFS, i did it and it runs
> >pretty good,
> >but now t
Am 11:22 16.03.2001 schrieben Sie:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>Hi there,
>
>i dont want to start a thread about MySQL over NFS, i did it and it runs
>pretty good,
>but now there is a problem i could not solve.
>
>the cpu on the filer goes up and up
Hi there,
i dont want to start a thread about MySQL over NFS, i did it and it runs
pretty good,
but now there is a problem i could not solve.
the cpu on the filer goes up and up (15% per day) and i have no idea why.
At the moment it hit 70% in peak time (5 min average)
Seems to be the database
36 matches
Mail list logo
