On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote:
> (Correction, seel below)
>
> > Jørn Dahl-Stamnes :
> > > > I have checked the local DNS and 'r2-d2' and
> > > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
> > > > What's wrong?
> > >
> > > Reverse resolution?
> >
> > I
(Correction, seel below)
> Jørn Dahl-Stamnes :
> > > I have checked the local DNS and 'r2-d2' and
> > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
> > > What's wrong?
> > Reverse resolution?
> I have checked that, and reverse DNS is OK - both resolve to
> 192.18.2.22
I read you sol
> Jørn Dahl-Stamnes :
> > > I have checked the local DNS and 'r2-d2' and
> > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
> > > What's wrong?
> > Reverse resolution?
> I have checked that, and reverse DNS is OK - both resolve to
> 192.18.2.22
I read you solved your problem, but by "
On Monday 11 January 2010 09:55, Ananda Kumar wrote:
> use mysql;
> select * from user;
>
> see if you able to see 'r2-d2' entry in this table.
>
> also you can try this
>
> grant all on . to 'root'@'%' idenfified by
> 'secret-password';
I just found the cause of the problem... /etc/nsswitch.conf
use mysql;
select * from user;
see if you able to see 'r2-d2' entry in this table.
also you can try this
grant all on . to 'root'@'%' idenfified by
'secret-password';
regards
anandkl
On Mon, Jan 11, 2010 at 1:40 PM, Jørn Dahl-Stamnes
wrote:
> On Monday 11 January 2010 08:53, Mihamina Rakotoma
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote:
> > Jørn Dahl-Stamnes :
> > I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
> > resovl to the same IP-addresse.
> > What's wrong?
>
> Reverse resolution?
I have checked that, and reverse DNS is OK - both resolve
> Jørn Dahl-Stamnes :
> I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
> resovl to the same IP-addresse.
> What's wrong?
Reverse resolution?
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
+26
7; idenfified by
'secret-password';
grant all on *.* to 'root'@'jedi.dahl-stamnes.net' idenfified by
'secret-password';
> --Original Message--
> From: Jørn Dahl-Stamnes
> To: mysql@lists.mysql.com
> ReplyTo: sq...@dahl-stamnes.net
> Subject:
com
ReplyTo: sq...@dahl-stamnes.net
Subject: Problem with mysql
Sent: Jan 10, 2010 3:20 PM
Hello
I have installed mysql, apache and phpmyadmin on a new server running Fedora
Core 12.
For some unknown reason I cannot connect to the local host using a full
hostname.
This is what I have done:
Hello
I have installed mysql, apache and phpmyadmin on a new server running Fedora
Core 12.
For some unknown reason I cannot connect to the local host using a full
hostname.
This is what I have done:
r2-d2# mysql -u root -p
grant all on . to 'root'@'r2-d2' idenfified by 'secret-password';
gran
: Problem with MySQL user
I'm working with two VMs, one a web server, one a MySQL database server.
In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for
the web site, and that works. The VMs got shipped off to a hosting
facility. They got the 172.16.1.X netwo
I'm working with two VMs, one a web server, one a MySQL database server.
In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for
the web site, and that works. The VMs got shipped off to a hosting
facility. They got the 172.16.1.X network between the two VMs up, but
when they try to
Hi Krishna,
I use the script mysql_multi to stop and the start several, or all,
instances.
At the end, to work with more ease,
I will create scripts to connect to each instance
and in the script force the variable prompt at the connection
seems easy
Thanks for all !!!
Il
Hi Stefano,
I believe that, different mysql configuration file for different mysql
instance is a better idea. In your case, if any thing goes wrong with my.cnf
Then, it is going to effect all mysql instance (either restart mysql server
or any other way). It has a lots of disadvantages.
You might
Hi Krishna,
the problem is that you use --default-file on the command line and in
this mode it's working fine,
I also tried,
but I have the configuration of the variable "default-file" in the
general my.cnf and I enter in MySQL
in this way:
mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock
W
Hi Stefano,
I have tested. It's working fine without any issue.
Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add
the below entires and restart the mysql server.
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
pro
Hi Krishna,
thanks for the your answer !!!
I have three different my.cnf for my three instances but one general
my.cnf to manage all instances,
my general my.cnf is:
[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
pas
prajapat...@gmail.com ("Krishna Chandra Prajapati") writes:
> You are running three mysql instance on single server. You can have three
> my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
> information in them. In this way you can set the prompt for different
> instance.
Thanks for the all answers !!!
It's ok,
even if I have three different my.cnf for my three instances,
my general my.cnf is:
[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
password = mysys2008srv
log = /MYSQL/MYSQL_LOG/My
Stefano Elmopi wrote:
If I put the variable prompt in the general my.cnf, the prompt is
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the instance
in the [mysql] section, the prompt does not change.
This is because the client reads from my.cnf b
Ciao Stefano,
how do you connect to the different instances?
if you use different operating system users or different mysql home
directories
just put in the home directory of each user a .my.cnf file (or my.cnf in the
mysql home)
with just the prompt setting in the [mysql] section.
NOTE: in the
Hi Stefano,
You are running three mysql instance on single server. You can have three
my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
information in them. In this way you can set the prompt for different
instance.
On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi
wrote:
I need advice.
I have three instances of MySQL on a single server.
How can I change the MySQL prompt depending of the instance on which
connecting ?
If I put the variable prompt in the general my.cnf, the prompt is
changed but for all instances.
If I put in the variable prompt in the my.cnf
Hi all,
I've a server where between 1-2 there comes a high load from less than
1k queries there's a jump to 60+k queries. It all started after adding
more RAM to the server.
Anyone seen this before ?
Regards,
Toke Herkild
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
On 10 jun 2007, at 20.47, tAndRead wrote:
Hi all,
when I try to add a foreign text from the keyboard in the mysql
client,
keystrokes are ignored! unless they are numbers, commas etc
(using kde-konsole with the the DeJaVu international font)
I believe this has to do something with the co
Hi all,
I have compiled mysqld 5.0.37 with utf support:
( configure --with-charset=utf8 --with-extra-charsets=none)
utf8 is the default in my.cnf:
( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 )
mysqld acknowledges it:
mysql> show variables like "charac%";
+--
Hi all,
I have compiled mysqld 5.0.37 with utf support:
( configure --with-charset=utf8 --with-extra-charsets=none)
utf8 is the default in my.cnf:
( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 )
mysqld acknowledges it:
mysql> show variables like "charac%";
+--
2006/6/5, MySQL Nexeia <[EMAIL PROTECTED]>:
I face one problem with mysql4.0
I've two tables, one called company and the other called favorites. The
relation between those two tables is CO_ID on the company table and
MASTER_CO_ID on the favorites table. When I run the following query it works
f
I face one problem with mysql4.0
I've two tables, one called company and the other called favorites. The
relation between those two tables is CO_ID on the company table and
MASTER_CO_ID on the favorites table. When I run the following query it works
fine on mysql-5.0 but it give error with mysql
Hello.
Some tips from the manual could be helpful. See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
untz wrote:
> Hello there,
>
> I just downloaded the MySQL 5 Community Edition for OS X Tiger..
Lachlan Mulcahy wrote:
Hi Unnsse,
Here's the problem at hand:
Raven:~ untz$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)
Can anyone tell me what possibly I am doing wrong?
The message you are getting is saying that there is no socket
Hi Unnsse,
Here's the problem at hand:
Raven:~ untz$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)
Can anyone tell me what possibly I am doing wrong?
The message you are getting is saying that there is no socket file
at /tmp/mysql.soc
Hello there,
I just downloaded the MySQL 5 Community Edition for OS X Tiger...
Ran the installer and it installed everything to /usr/local/ ...
Updated my .bash_profile by creating a MYSQL_HOME variable and
appending that MYSQL_HOME/bin to the PATH variable...
Now, the problem is that when
Hello.
It doesn't run on Windows NT 4 and below. See:
http://dev.mysql.com/doc/administrator/en/mysql-administrator-installation-windows.html
Wolfgang Bogenrieder wrote:
> Hallo,
>
> ich have a problem with
>
> mysql-administrator-1.1.5 and
> mys
Hallo,
ich have a problem with
mysql-administrator-1.1.5 and
mysql-query-browser-1.1.17
running under Windows NT Sp6. Starting the tools I get the error
message, like
"procedure GetFileSizeEx not found in Kernel32.dll". Suppose you have to
define #ifdef NT while compiling,
mysql@lists.mysql.com
> Cc: Andrew Braithwaite
> Subject: Re: possible MySQL bug - insert into 'double' column problem
> with mysql 4.1
>
> Andrew Braithwaite wrote:
>> Hi All,
>>
>> I have a strange error when trying to insert into a table with 2
>
MySQL bug - insert into 'double' column problem
with mysql 4.1
Andrew Braithwaite wrote:
> Hi All,
>
> I have a strange error when trying to insert into a table with 2
> 'double' fields. It inserts into the 1st field OK but fills the 2nd
one
> with nines. See
Andrew Braithwaite wrote:
Hi All,
I have a strange error when trying to insert into a table with 2
'double' fields. It inserts into the 1st field OK but fills the 2nd one
with nines. See below for a complete recreate.
[...]
| lon | double(7,6) | YES | MUL | NULL|
Hello Andrew,
> I have a strange error when trying to insert into a table with 2
> 'double' fields. It inserts into the 1st field OK but fills the 2nd one
> with nines. See below for a complete recreate.
>
> Is this a known problem? Does anyone have a solution?
>
> I'm running standard MySQL bi
Hi All,
I have a strange error when trying to insert into a table with 2
'double' fields. It inserts into the 1st field OK but fills the 2nd one
with nines. See below for a complete recreate.
Is this a known problem? Does anyone have a solution?
I'm running standard MySQL binaries on redhat l
Hi:
I have this data:
ventas_encabezado_historico_sat Query
VEH_EMPRESA
VEH_TIENDA
VEH_FECHA
VEH_STATUS
VEH_TOTAL
VEH_HORA
DLC
T01
6/1/2003
V
30
8:31:05 AM
DLC
T01
6/1/2003
V
114.28
8:38:44 AM
DLC
T01
6/1/2003
V
63.2
8:41:13 AM
DLC
T01
6/1/2003
V
8.75
8:42:47 AM
dlc
T01
6/1/2003
V
12.35
> It would appear that the package is for the 64-bit OS, even though it is
> listed as being for the 32-bit one.
>
> I see directories, that failed to install, of:
> /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench
>
> I had gotten my file from
> http://dev.mysql.com/get/Downl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It would appear that the package is for the 64-bit OS, even though it is
listed as being for the 32-bit one.
I see directories, that failed to install, of:
/usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench
I had gotten my file from
thomas [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 1:28 PM
To: Ravi T Ramachandra (WT01 - EMBEDDED & PRODUCT ENGINEERING SOLUTIONS)
Cc: [EMAIL PROTECTED]
Subject: Re: Data loss problem with mysql
On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote:
>
> Dear all,
>
> We a
On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote:
>
> Dear all,
>
> We are running mysql 4.0.17 on linux environment. Our database resides
> on external disk connected via FC cables. We recently noticed a loss
> of data in the following scenario.
>
> Inserted a row in a table in a separate transacti
Dear all,
We are running mysql 4.0.17 on linux environment. Our database resides
on external disk connected via FC cables. We recently noticed a loss
of data in the following scenario.
Inserted a row in a table in a separate transaction by a java
application,
queried a row in the table in a s
If you give more details maybe someone on the list will be able to help.
Astghik Barseghian wrote:
Hello Philippe,
I am trying to use DBMail from MySQL to send and receive messages but I get an SQL
sytax error.
Could you please tell me is there any way to use the mentioned component,
or how can I
Frank Perez <[EMAIL PROTECTED]> wrote:
> I am trying to install MySQL 5.0.0 on a fresh install
> of Fedora Core 1, however I am running into a little
> trouble and I was hoping someone could give me a
> little insight on what I might be doing wrong.
>
> I am able to install the 'server', 'clients
Hello everyone,
I am trying to install MySQL 5.0.0 on a fresh install
of Fedora Core 1, however I am running into a little
trouble and I was hoping someone could give me a
little insight on what I might be doing wrong.
I am able to install the 'server', 'clients', and
'devel' packages with no prob
Martin Rytz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 18, 2004 9:35 AM
> To: [EMAIL PROTECTED]
> Subject: Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations
> (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
>
> Hi All
>
> I am very confused
Hi All
I am very confused about MySQL 4.1.3. I have problems with the character set
and the collation. Under 4.0.20 I had never such problems.
I downloaded the beta-files from version 4.1.3b and zipped it to c:\mysql.
Then I loaded my data within a script with "load data infile" into my
tables.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I also tried the 5.0.1 MAX binaries looking for a solution to my previously
posted problem of permissions (see at the bottom of the message for the
previous post).
According to the hostname.err file:
040810 13:31:44 mysqld started
Jocelyn Fournier wrote:
Hi,
A quick fix would be to set the wait_timeout variable in the my.cnf to a
much smaller value than 28800 (default value).
Try to add wait_timeout=60 in the my.cnf for example, the connections should
be automatically closed after 60 secondes if there are not used anymore.
Fournier
www.presence-pc.com
- Original Message -
From: "Jan Kirchhoff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 03, 2004 7:43 PM
Subject: Re: Problem with Mysql 4.0.18 + Debian
> That sounds like a typical
| citidel | localhost | citidel | Sleep | 607 | | NULL
>
> |
> | 95 | citidel | localhost | citidel | Query | 0| NULL | show
> processlist |
> ++-+---+-+-+--+---+---------
>
>
>
>
> Ryan Richardson said:
>>
>> -Original Message-
>> From: [
| Query | 0| NULL | show
processlist |
++-+---+-+-+--+---+-
Ryan Richardson said:
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/2/04 9:16 AM
Subject: Problem with Mysql 4.0.18 + Debian
Hello:
I posted this before but I have not
--
Ryan Richardson said:
>
> -Original Message-
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: 8/2/04 9:16 AM
> Subject: Problem with Mysql 4.0.18 + Debian
>
> Hello:
>
> I posted this before but I have not gotten a response. I have a
>
Ryan,
> Here's the problem. I had the site up several days, with everything
> running perfectly. Ordinarily there would be about 11 mysql processes
> running. However, after a few days of running smoothly, the number of
> mysql processes increases to over 170, and the site crashes. Formerly
>
Victor Pendleton said:
> What does mysql "show processlist" look like?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: 8/2/04 9:16 AM
> Subject: Problem with Mysql 4.0.18 + Debian
>
> Hello:
>
> I posted this
What does mysql "show processlist" look like?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/2/04 9:16 AM
Subject: Problem with Mysql 4.0.18 + Debian
Hello:
I posted this before but I have not gotten a response. I have a
Debian
(woody) server runn
Hello:
I posted this before but I have not gotten a response. I have a Debian
(woody) server running a good sized database (7.2GB of db files), Mysql
4.0.18. I am running Apache 1.3.29 + perl and using mysql as the
backend. In my.cnf, I have max_connections=300.
Here's the problem. I had th
Hello,
I'd like to ask for some help on a problem which have prevented my mysql
server to run since I updated it from 4.0 to 4.1
Anyway, even if in the idea it's an update, in the facts it's a fresh install,
from sources.
Sources were configure'd with "./configure --prefix=/usr/local/mysql".
Aft
> Hello:
>
> I posted this before but I have made some changes since then (not that
> they helped much). I have a Debian (woody) server running a good sized
> database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29
> + perl and using mysql as the backend. In my.cnf, I set
> max_
Hello:
I posted this before but I have made some changes since then (not that
they helped much). I have a Debian (woody) server running a good sized
database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29
+ perl and using mysql as the backend. In my.cnf, I set
max_connections=3
Dear Friends
i was using ,mysql 4.0.15 for production with no problem
now i just instaled the 4.1.3-beta for an test
and relink my app that use mysql api
every time i execute i got an segmentation fault on the call to
mysql_num_fields
Can any one help
Regards
Luiz
--
MySQL General Mailing Li
Hello:
This is my first time posting so bear with me. I have a Debian (woody)
server running a good sized database (7.2GB), Mysql 4.0.18. I am
running Apache 1.3.29 + perl and using mysql as the backend. Here's the
problem. I had the site up for weeks, with everything running
perfectly. Or
> > Hi, my name is Carlos Flores, and i have solaris 9 on ultra 10
> > workstation, but
> > i can not up this daemon, with /opt/sfw/mysql/bin/mysqld_safe & i try
> > to up this
> > daemon, but always begin but in second line tell me: mysql ended, and
> > i try with
> > mysql_install and anyone opti
I'm running mysql 4.0.17 on Mac OS X 10.2.8 without problems. My first
guess would be that the upgrade reset the permissions on /tmp, so now
the mysql user doesn't have permission to create mysql.sock.
Try
cd /tmp
sudo chmod 1777 .
then see if mysqld will start. (While you're in /tmp, mak
Hi,
I've recently been having some problems with mySQL on one of my OS X
computers. It was working perfectly until I upgraded from OS 10.2.6 to
OS 10.2.8, and now mysqld refuses to start up, showing the following
--
[EMAIL PROTECTED] mysql]$ sudo ./bin/mysqld_safe
Starting mysqld daem
Hi!
I compiled mysql 4.1.1 today and used the following config:
#v+
--with-character-set=latin1 \
--with-collation=latin1_german1_ci \
--with-extra-charsets=all
#v-
./configure and make worked fine, but make test failed:
#v+
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing
What version of mysql are you using? I'm running 4.0.14 and I upgraded
without a problem.
On Friday, October 31, 2003, at 01:20 PM, Anderson, James H [IT] wrote:
Ever since upgrading I haven't been able to use the 'mysql'
command--it just
hangs. Otherwise, the database seems to be working prope
Ever since upgrading I haven't been able to use the 'mysql' command--it just
hangs. Otherwise, the database seems to be working properly. I even tried
rebuilding from source but it didn't solve the problem. I've attached
ktrace/kdump output of the problem. I'm hoping someone can interpret this
stuf
I should add that I can access the database via a java program, just not
using the mysql command.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
->-Original Message-
-->From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 2:03 PM
-->To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED]
-->Subject: RE: problem with MySQL and latest release of Mac OX X
(Panther)
-->
-->BTW,
mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 2:03 PM
-->To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED]
-->Subject: RE: problem with MySQL and latest release of Mac OX X
(Panther)
-->
-->BTW, nothing's changed in my.cnf...
-->
-->.my.cnf
-->
.
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 4:42 PM
To: Anderson, James H [IT]; [EMAIL PROTECTED]
Subject: RE: problem with MySQL and latest release of Mac OX X (Panther)
Can you post you're my.cnf options / your query in que
age-
-->From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 1:06 PM
-->To: [EMAIL PROTECTED]
-->Subject: problem with MySQL and latest release of Mac OX X (Panther)
-->
-->Much to my surprise and chagrin, I'm having a problem using MySQL
Much to my surprise and chagrin, I'm having a problem using MySQL after upgrading to
the latest release of Mac OS X this past weekend. As far as I can tell, the server
seems to be running, but when I attempt to execute the mysql command it just hangs.
Any ideas?
Thanks,
jim
--
MySQL General
Hello,
This sql query works fine with mysql 4.0.15, but it gives an error with
mysql 3.23.49:
SELECT officiele_naam, rechtsvorm, activiteit1, activiteit2, adres, postnummer,
gemeente, Biogarantie, Hefboom, Netwerk_Vlaanderen, Vibe, Fair_Trade, NULL , Vosec,
Solidr, Demeter, Europees_Ecolabel, B
Hi folks
I wrote an application which uses japanese characters. I can display
japanese characters, fetching from a mysql database on my WindowsXP
machine.
I moved the same to a Linux machine and could see only junk characters.
Any suggestions?
MySQL version 4.0.13 on Win XP Japanese
MySQL v
Victoria, Thanks.
--
__
Sign-up for your own personalized E-mail at Mail.com
http://www.mail.com/?sr=signup
CareerBuilder.com has over 400,000 jobs. Be smarter about your job search
http://corp.mail.com/careers
--
MySQL General Mailing Li
Hi!
On Sep 10, Victoria Reznichenko wrote:
> [EMAIL PROTECTED] wrote:
> > I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it
> > doesn't work. MySQL always crashs with error 11 Segmentation fault.
> >
> > I don't know why but I try to dump database (about 200,000 lines)
> > and
[EMAIL PROTECTED] wrote:
> I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work.
> MySQL always crashs with error 11 Segmentation fault.
>
> I don't know why but I try to dump database (about 200,000 lines) and install MySQL
> 4.0.14 windows version and try to import
I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work.
MySQL always crashs with error 11 Segmentation fault.
I don't know why but I try to dump database (about 200,000 lines) and install MySQL
4.0.14 windows version and try to import database again to MySQL windows ve
I have problem with these versions of mysql. Few seconds after
start I have tons of log in /var/log/mysql/ which looks like this:
update.61871 update.62874 update.63877 update.64880 update.65883 update.66886
update.67889
update.61872 update.62875 update.63878 update.64881 update.65884 u
Hi Lenz,
thanks a lot for your reply!
> Is that a self-compiled binary or one of ours?
It are the MySQL-4.0.13-MAX-RPMs from your site.
> Not very helpful. Does this occur under high load only?
Yeah I know, otherwise I would have tried to generate a reproducible testcase with a
given query or
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote:
> before posting to the bugs-list I would like to try it here to get some
> help :). Every now and then MySQL-4.0.13 crashes on my
> Dual-Athlon-MP-machine.
Is that a self-compiled binary or one of ou
Hey folks,
before posting to the bugs-list I would like to try it here to get some help :).
Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine.
Its not reproducible nor I know a query which does it.
(The log shows that at the end, so no query :-( :
Trying to get some variables.
Hello Heikki,
Thanks for your response. Hmmm... When I run 'show processlist', I get something
like the following:
++--++--+-+-+---+--+
| Id | User | Host | db | Command
nal Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 10:48 PM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
> Hello Heikki,
>
> > why you do not look with SHOW INNODB STATUS if there are dang
Hello Heikki,
> why you do not look with SHOW INNODB STATUS if there are dangling
> transactions which could still see the delete-marked rows? Purge cannot
> remove them then.
This is what I see:
mysql> show table status like 'sccchangelog';
+--++++---
ECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 12:10 AM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
> Hi,
>
> I wanted to post a follow-up question to the inquiry below. I've done some
more research since my last post and now
Hi,
I wanted to post a follow-up question to the inquiry below. I've done some more
research since my last post and now think that the performance problem is related to
something other than uncommitted transactions. More specifically, I think the culprit
is the lack of timely synchronization
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
--
1 - 100 of 277 matches
Mail list logo
