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
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
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 access all files.
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:
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
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
97 0
--
-Original Message-
From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 10:03 AM
To: [EMAIL PROTECTED]
Subject: Urgent problem
Hi
Rainer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
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
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
--
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
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
, 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 first
e-mail.
The failed login attempts couldn't be from your slaves trying
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-mail I
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 first
e-mail.
The failed login attempts couldn't be from your slaves trying to login
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 still be
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 |
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
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,
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://hostname/sqladmin using GUI then MySql is
giving
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 and
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
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
statement
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
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
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 want to get details about whose files
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 if
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
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 (15%
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) Pro*
30 matches
Mail list logo
