Hi Guys
I am once again having a weird issue... well weird to me anyway.
We have a master,slave setup using mysql 5.7 and they are both
connected on the same network segment through the same switch.
During the weekend a HUGE amount of processing was done on the master,
and thus
Hi,
I have configured replication from EC2 mysql instance to another mysql
instance on our network via vpn in between. Sometimes it is showing no
errors on the slave but the slave falls behind . When I issue the commands
stop slave ; start slave ; it again catches up with the master.
What is
Sheesh... I knew it had to be something simple. Opened up phpMyAdmin as
mysql/root and changed the privileges for the ijdb user to allow connecting from
any host, not just localhost.
Problem solved.
Thanks!
Monte
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
connect to .20 - as proven by the "access denied" message you
get instead of a "cannot connect to host".
You are, however, going to 192.168.56.20, which means that your network packets
enter the host-only network from your hosts's (virtual) interface 192.168.56.1.
That
7;t *want* to connect to the mysql server @ 192.168.58.1 - my local
interface on that network. If I wanted to connect to the local server, I'd tell
it exactly that - localhost or 127.0.0.1.
Again, I *don't* want to connect to 192.168.56.1 - I want to connect to
192.168.56.20 - so why the heck
- Original Message -
> From: "Monte Milanuk"
> 'Connection Failed: [HY000][MySQL][ODBC 5.1 Driver] Access denied for
> user 'ijdb'@'192.168.56.1' (using password: YES)'
The connector is not trying to connect to the host address; it's connecting
*from* the host address - in your MySQL,
ct to the MySQL database both via
the command-line client and via M$ Access and Excel.
I also have Virtualbox installed with a LAMP server running on a host-only
network. I can connect to the LAMP server via cmd.exe, PuTTY, Firefox, etc. I've
modified the mysql configuration on the LAMP server t
Check your auto negotiate setting on your nic. Run ifconfig and see if there
are a lot of errors.
On Sep 29, 2011 10:13 AM, "Jim Moseby" wrote:
Yeah:
# host 72.30.2.43 /* yahoo.com */
43.2.30.72.in-addr.arpa domain name pointer ir1.fp.vip.sk1.yahoo.com.
# host 10.1.20.97 /* my windows box */
97
Yeah:
# host 72.30.2.43 /* yahoo.com */
43.2.30.72.in-addr.arpa domain name pointer ir1.fp.vip.sk1.yahoo.com.
# host 10.1.20.97 /* my windows box */
97.20.1.10.in-addr.arpa has no PTR record
>>> Todd Lyons 9/29/2011 10:26 AM >>>
On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby wrote:
> I still u
On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby wrote:
> I still use the old MySQL Administrator GUI on my windows box. A simple
> 'select * from tablename' that would return only three records takes just
> over a minute to return (although it says '3 records returned in 0.0086
> seconds' at the
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
Strange, strange problem.
Everything was fine yesterday morning, then all of a sudden any query over the
network takes a REALLY long time to return. If I log in at the server console,
every query is snappy-fast
In the last episode (Oct 20), Bermejo, Rodrigo (GE Infra, Aviation) said:
> We are facing a preformance issue with a desktop application which
> connects remotly to a Mysql / DB ( ping times 300-800ms). We do not have
> time to invest in modifications to create a 2-tier ... Web application
> The
Well, it's not exactly a clean approach, but if those are the limits you
have to work within, so be it :-)
I suspect you could gain some more performance by using MySQL's multiple
select syntax. It's rougly like this:
insert into *table* (*field*, *field*, *field*) values (*value*, *value*, *
val
Hola List /.
We are facing a preformance issue with a desktop application which
connects remotly to a Mysql / DB ( ping times 300-800ms).
We do not have time to invest in modifications to create a 2-tier ...
Web application
The initial plan was to implement a Client cache or a local DB (mysql
sla
,
Remeber love and understading matters alot in life one love;
Awaiting to hear from you soonest,
Thanks and God bless you,
Form sandra
--
View this message in context:
http://www.nabble.com/Degrees-in-network-between-members-friends-tp5870832p18020641.html
Sent from the MySQL - General mailing list
Here is my errors in my locahost.locaodomain.err:
071217 14:02:12 mysqld_safe Starting mysqld daemon with databases from
/usr/local/mysql/data/
2 071217 14:02:12 InnoDB: Started; log sequence number 0 46429
3 071217 14:02:13 [Warning] NDB: server id set to zero will cause any
other mys
If you must manually sync, MySQL Table Sync is designed for efficient
syncing over a slow network.
http://mysqltoolkit.sourceforge.net/
It's still not finished, but I use it in production all the time.
If there's any way you can possibly do this via replication, I would
recommend y
both masters in Replication?
Thanks again
CPK
On 8/26/07, Gary W. Smith <[EMAIL PROTECTED]> wrote:
>
> > for generating Statutory reports. Also cluster can not be a solution
> as
> > it
> > requires min. 100 MB network.
>
> Says who?
>
> But clustering won&
> for generating Statutory reports. Also cluster can not be a solution
as
> it
> requires min. 100 MB network.
Says who?
But clustering won't help. You are looking for active/active, which
could be accomplished but this would possibly lead to specific conflicts
if people are tryi
.
accounting will carried out at both, but only HO database will be considered
for generating Statutory reports. Also cluster can not be a solution as it
requires min. 100 MB network.
Can we generate scripts on windows to sync them manually?
Thanks
CPK
On 8/25/07, Craig Huffstetler <[EM
I would probably recommend replication. It's not that bad to setup and once
it catches up on the slave then it will continue to be an easy sync in the
future as long as both are running. How big is the database you wish to
synchronize? What connection are both servers on?
Is there anyway possible
Hi,
I have a problem as below-
We have a MySQL server for our ERP database. Now we have to implement the
ERP for Head office. HO is away from the current setup and connection
between the two is through VPN at slow speed. How can we synchronize the two
MySQL servers?
Replication,
Cluster, or manual
Us If you need
the software(E-Mail:[EMAIL PROTECTED])
E-Mail:filtersoft#126.com
6.Introducation:
The software can monitor and manage employees' network behaviors. Prevent
secret and vital data from being sent out. It captures and records the
communication data on network and block relate
lease Contact Us If
you need the software(E-Mail:[EMAIL PROTECTED])
E-Mail:filtersoft#126.com
6.Introducation:
The software can monitor employee's network behaviors. Prevent secret and
vital data from being sent out. It just captures and records the
communication data on network for reference
Hello,
Good post, but not what i'm looking for.
Well, Postgresql seems to be the winner, at least for
handling network addresses.
(Don't take me wrong. I'm not saying Postgresql is better RDBMS)
Thanks.
On 5/15/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
js wrote:
Hi,
js wrote:
Hi Baron.
Thanks for reply.
If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.
Very true, I didn't quite understand the syntax you were using. But you can still use
bitwise arithmetic to work around this. Scott Noyes wrote a nice
> -Original Message-
> From: js [mailto:[EMAIL PROTECTED]
> Sent: 15 May 2007 15:31
> To: MySQL List
> Subject: Network address functions in MySQL?
>
>
> Hi.
>
> Today I found postgresql's neat feature, inet operators,
> which allows you
Hi Baron.
Thanks for reply.
If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.
On 5/15/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hello,
js wrote:
> Hi.
>
> Today I found postgresql's neat feature, inet operators,
> which allows you to do
>
>
Hello,
js wrote:
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' >> inet '192.168.1.5'
http://www.postgresql.org/docs/current/static/functions-net.html
Is there anyway to do this using MySQL?
Yes. Have a look at the inet_ntoa() and i
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' >> inet '192.168.1.5'
http://www.postgresql.org/docs/current/static/functions-net.html
Is there anyway to do this using MySQL?
--
MySQL General Mailing List
For list archives: http://lists.
Hi Everyone
I have a new MySQL database at the back end of an invoicing and stock control
program. I ran a Performance Monitor thing whilst doing the look-ups involved
in one of the reports (Invoice items in order of customer name between 2 dates
- you know the sort of thing). It appears that t
quot;;
$categorias="Todo o site\n";
foreach ($linhas as $linha) {
if ($linha["indice"]!="") {
if (substr($linha["indice"],0,strlen($anterior))==$anterior &&
(strlen($linha["indice"])!=strlen($anterior) || $espacos==0)) $espacos+=4;
Hey everybody,
i´m becoming desperate about the following problem.
We´ve an online-community / network.
There´s a network table ( sql create below ), in which we store the
relationships between the member.
I need a SQL-statement or a PHP-Function to calculate the 2nd, 3rd and
4th degrees
Hey everybody,
i´m becoming desperate about the following problem.
We´ve an online-community / network.
There´s a network table ( sql create below ), in which we store the
relationships between the member.
I need a SQL-statement or a PHP-Function to calculate the 2nd, 3rd and
4th degrees
Hi All,
I need small help from you. I am using Replication, i am using this
technique to give live support to Support team. But my Server and Slave are
not in LAN. So some times i am getting network delay. Can anybody tell me a
good suggestion to over come this.
regards,
balaraju
Asif Lodhi wrote:
Hi Chris,
On 7/28/06, Chris <[EMAIL PROTECTED]> wrote:
> i'm trying to figure out how to allow all users on machines within my
> network access to a mysql db...
>
> with no luck..
...
Have you
bruce wrote:
hi...
i'm trying to figure out how to allow all users on machines within my
network access to a mysql db...
i've tried:
grant access all on *.* to '*'@'%'
grant access all on *.* to '%'@'%'
grant access all on *.* to @'%
hi...
i'm trying to figure out how to allow all users on machines within my
network access to a mysql db...
i've tried:
grant access all on *.* to '*'@'%'
grant access all on *.* to '%'@'%'
grant access all on *.* to @'%'
with no
Wim, see http://dev.mysql.com/doc/refman/5.0/en/grant.html
When granting access to a user, you can do like
GRANT SELECT on db.* to 'user'@'%.domain.com'
which gives 'user' access to select from any table within 'db', provided
they are coming from a host in 'domain.com'. ('%' is a wildcard.)
Y
Hello
I would like to grant select access to a certain
mysql database from all computers in my local lan
without having to add every specific computer to the
user database , is this possible and how is this
done?
The purpose is to give all users the possibility to
access the addresslist table in
Hello List,
Has anyone seen any problems using LOAD DATA FROM MASTER on a second slave
using a secondary network interface?
I have:
mysql-master / {172.25.7.20 / eth0, 192.168.7.20 / eth1} / Red Hat EL V.4 /
MySQL 5.0.22
mysql-slave1 / 172.25.1.58 / Windows XP / MySQL 5.0.18
mysql-slave2
Takanobu Kawabe schrieb:
> Hello, my name is Takanobu Kawabe.
>
> I have gotten a MySQL Network, and the service level is gold , I
> could login MySQL Network on May 20th ,
> but now I can't login. I have tried some times last week,
> and today
Hello, my name is Takanobu Kawabe.
I have gotten a MySQL Network, and the service level is gold , I
could login MySQL Network on May 20th ,
but now I can't login. I have tried some times last week,
and today , but I cannot do it.
If I try to login (U
On Mon, Apr 17, 2006 at 11:26:38AM +0800, 古雷 wrote:
> Hello:
>
> For example:
> What does "Web Access" and "Remote Troubleshooting" mean in this page
> https://shop.mysql.com/network.html?rz=s2
'Web Access' means you have access to the web-based support system.
'Remote Troubleshooting' means tha
Hello:
For example:
What does "Web Access" and "Remote Troubleshooting" mean in this page
https://shop.mysql.com/network.html?rz=s2
regards,
gu lei
--- Philippe Poelvoorde <[EMAIL PROTECTED]> wrote:
> 2006/4/8, Philippe Poelvoorde <[EMAIL PROTECTED]>:
> > Hi,
> >
> > 2006/4/8, Dan Buettner <[EMAIL PROTECTED]>:
> > > Seems like what you're looking for is a way to query your
> database
> > > more efficiently/quickly, and still find all links
2006/4/8, Philippe Poelvoorde <[EMAIL PROTECTED]>:
> Hi,
>
> 2006/4/8, Dan Buettner <[EMAIL PROTECTED]>:
> > Seems like what you're looking for is a way to query your database
> > more efficiently/quickly, and still find all links in either
> > direction.
> >
> > I think the use of a UNION statemen
> Sent: 07 April 2006 15:11
> To: Martin Gallagher; mysql@lists.mysql.com
> Subject: Re: Social Network, linking members
>
> Martin Gallagher wrote:
>
> >Hi,
> >
> >I'm trying to find the most efficient way of "linking" members to
> one
> >anot
Hi,
2006/4/8, Dan Buettner <[EMAIL PROTECTED]>:
> Seems like what you're looking for is a way to query your database
> more efficiently/quickly, and still find all links in either
> direction.
>
> I think the use of a UNION statement should allow this. Basically
> write your query twice, joining
Original Message-
From: 2wsxdr5 [mailto:[EMAIL PROTECTED]
Sent: 07 April 2006 15:11
To: Martin Gallagher; mysql@lists.mysql.com
Subject: Re: Social Network, linking members
Martin Gallagher wrote:
Hi,
I'm trying to find the most efficient way of "linking" members to one
another
mailto:[EMAIL PROTECTED]
Sent: 07 April 2006 15:11
To: Martin Gallagher; mysql@lists.mysql.com
Subject: Re: Social Network, linking members
Martin Gallagher wrote:
Hi,
I'm trying to find the most efficient way of "linking" members to one
another in a social networking applica
! That's exactly the problem.
I think I might just have to grin and bear what I already have :-(
-Original Message-
From: 2wsxdr5 [mailto:[EMAIL PROTECTED]
Sent: 07 April 2006 15:11
To: Martin Gallagher; mysql@lists.mysql.com
Subject: Re: Social Network, linking members
Martin Gallagher w
Martin Gallagher wrote:
Hi,
I'm trying to find the most efficient way of "linking" members to one
another in a social networking application.
Currently I link them using 2 separate fields for the members: id1, id2. So,
to find people in your network you would do:
I'm not
.mysql.com
Subject: Re: Social Network, linking members
How about something like this
Users table
user_id
user_name
user_password
user_whatever
and then
Relation table
rel_id
user_id
friend_id
and then selecting from relations table
How about something like this
Users table
user_id
user_name
user_password
user_whatever
and then
Relation table
rel_id
user_id
friend_id
and then selecting from relations table
On Fri, 2006-04-07 at 14:47 -0700, Martin Gallagher w
Hi,
I'm trying to find the most efficient way of "linking" members to one
another in a social networking application.
Currently I link them using 2 separate fields for the members: id1, id2. So,
to find people in your network you would do:
WHERE id1=%ID OR id2=%ID
Th
Anyone have some pointers at a HowTo on creating a social network?
Basically I need to show people in your immediate network, and also friends
of your friends, etc... Like the whole 'six degrees of separation' thing.
Ala: myspace, friendster, etc. ad nauseum.
I prefer mySQL and PHP, b
On 19/02/2006 10:57 p.m., Kevin Burton wrote:
I was talking to a friend tonight about how they use NBD to run a single
system image in memory.
NBD (Network Block Device) allows one Linux box to export a block device
and for you to mount it on another filesystem. For the memory
component
I was talking to a friend tonight about how they use NBD to run a
single system image in memory.
NBD (Network Block Device) allows one Linux box to export a block
device and for you to mount it on another filesystem. For the
memory component they just use a ram disk.
More info here
On Saturday 17 December 2005 21:43, [EMAIL PROTECTED] wrote:
> I think the most likely culprit will be an unexpected reverse DNS result.
> Here are the other likely reasons to get an access denied error:
> http://dev.mysql.com/doc/refman/4.1/en/access-denied.html
>
> To the server, does the machine
Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote on 12/17/2005 02:12:38
PM:
> I'm trying to access a database over my local network.
>
> On the server, I had applied the following commands:
>
> shell > mysql -u root -p
> mysql> GRANT ALL on mydb.* To 'snotf
I'm trying to access a database over my local network.
On the server, I had applied the following commands:
shell > mysql -u root -p
mysql> GRANT ALL on mydb.* To 'snotface'@'otherhost.mydomain' IDENTIFIED BY
'novice';
From the otherhost.mydomain, I try
I would like to thank you all for the help and the
explanations.
I think I'll stick to the option of having the
database behind the firewall. The problem is I don't
control that part of the company, as you can imagine
so I'll have to ask the network administrators for
that.
Just
cts of SSL + strange port + firewall
you can see how each layer contributes to the overall security of your
application. Using SSL, even your logins are encrypted. Without it, anyone
sniffing your network traffic can see both the queries and the responses.
Nothing that goes over the internet can
.
Just my $.02
J.R.
-Original Message-
From: Ruben Carvalho [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 06, 2005 1:20 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Network drive
I don't have a web server, I mean, I have a standalone java application
running i
[EMAIL PROTECTED] wrote:
> >
> > > Ruben Carvalho <[EMAIL PROTECTED]>
> wrote on
> > > 07/06/2005 11:06:10
> > > AM:
> > >
> > > > I think I haven't understood your question. I
> > > guess
> > > > that in case of
ideas? Thank you
--- [EMAIL PROTECTED] wrote:
Ruben Carvalho <[EMAIL PROTECTED]> wrote on
07/06/2005 11:06:10
AM:
I think I haven't understood your question. I
guess
that in case of a network failure you can have the
same behavior as a power shutdown.
About the networke
clients
> don't have access to the machine behind the proxy).
>
> Any ideas? Thank you
>
> --- [EMAIL PROTECTED] wrote:
>
> > Ruben Carvalho <[EMAIL PROTECTED]> wrote on
> > 07/06/2005 11:06:10
> > AM:
> >
> > > I think I haven'
EMAIL PROTECTED] wrote:
> Ruben Carvalho <[EMAIL PROTECTED]> wrote on
> 07/06/2005 11:06:10
> AM:
>
> > I think I haven't understood your question. I
> guess
> > that in case of a network failure you can have the
> > same behavior as a power shut
Ruben Carvalho <[EMAIL PROTECTED]> wrote on 07/06/2005 11:06:10
AM:
> I think I haven't understood your question. I guess
> that in case of a network failure you can have the
> same behavior as a power shutdown.
>
> About the networked drives? Anyone?
>
&g
I think I haven't understood your question. I guess
that in case of a network failure you can have the
same behavior as a power shutdown.
About the networked drives? Anyone?
--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hi Ruben,
>
> > I would like to make a
Hi Ruben,
> I would like to make a short, quick and simple
> question.
>
> Is it possible to have the following line:
>
> innodb_data_home_dir="X:/data/"
>
> in a my.ini config file?
>
> I'm using windows XP, mysql 4.1.12, X: is a mapped
> netw
Hello everyone,
I would like to make a short, quick and simple
question.
Is it possible to have the following line:
innodb_data_home_dir="X:/data/"
in a my.ini config file?
I'm using windows XP, mysql 4.1.12, X: is a mapped
network drive to a Linux folder using samba, all the
Thanks Gleb. I just had to manually make changes in my firewall. I allowed
requests to port 3306 & mysqld.exe in exceptions tab and it solved the
problem. The only reason I didn't think about firewall setting before since
whenever I try to run new service, I wud get a pop up from Firewall asking
to
"rtroiana" <[EMAIL PROTECTED]> wrote on 06/06/2005 08:42:18 AM:
> Hi All,
>
> I'm trying to connect to MySql server from MySql Administrator on a
network
> machine. I specify the Server host as IP of the machine where DB server
is
> running and Port as 33
Hi All,
I'm trying to connect to MySql server from MySql Administrator on a network
machine. I specify the Server host as IP of the machine where DB server is
running and Port as 3306.
Username as 'root' and the password
I have tried with other usernames and specifyi
-to-server.html
http://dev.mysql.com/doc/mysql/en/query-log.html
"Reema Troiana" <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I'm trying to connect to MySql server from MySql Administrator on a network
> machine. I specify the Server host as IP of the mach
Hi All,
I'm trying to connect to MySql server from MySql Administrator on a network
machine. I specify the Server host as IP of the machine where DB server is
running and Port as 3306.
Username as 'root' and the password
I have tried with other usernames and specifying machine
Hi all,
So what does the buzz about MySQL Network mean, for you?
And what about licensing?
I wrote an article about all that: MySQL Network and You.
http://dev.mysql.com/tech-resources/articles/mysql-network-and-you.html
In a nutshell:
- Some people spend time to save money,
and MySQL
N¬™ë,j°jËkj{zºÞw…«k‰©oz»"¢z
‰¦ºx†jטúèDear all,
I have a mysql-4.0.12 server installed on RH 8, it works fine for months before
I
find the server unavailable from the remote host on the same LAN. I am sure
there
isn't any firewall between server and client. I ssh to the server and find th
Donny Simonton wrote:
It was probably attempting to do a reverse and nothing exists, so it just
has to timeout.
Reverse DNS is evil... :)
http://dev.mysql.com/doc/mysql/en/DNS.html
You can disable DNS hostname lookups by starting |mysqld| with the
|--skip-name-resolve| option. However, in this
It was probably attempting to do a reverse and nothing exists, so it just
has to timeout.
Donny
> -Original Message-
> From: Frank Febbraro [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 07, 2004 3:23 PM
> To: Donny Simonton; [EMAIL PROTECTED]
> Subject: Re: MySQ
> I've been using mysql 4.1 since the first day it was out; it's all been
> trial and error. If I remember correctly, I found it on 4.1.0 when I was
> doing a processlist, and noticed that some of the boxes connecting to mysql
> had reverse and others didn't. So now we actually go to the /etc/hos
onny Simonton; [EMAIL PROTECTED]
> Subject: Re: MySQL 4.1.7 Network slowdown
>
> > The final question, does the windows box have reverse DNS setup for it?
> If
> > not add it to the /etc/hosts file on your fc3 linux box. And reconnect
> to
> > mysql.
>
> WOW! Th
> The final question, does the windows box have reverse DNS setup for it? If
> not add it to the /etc/hosts file on your fc3 linux box. And reconnect to
> mysql.
WOW! That was it. Things are lightning fast now.
Sorry for going completely down the wrong path.
What would have been the best way
/etc/hosts file on your fc3 linux box. And reconnect to
mysql.
Donny
> -Original Message-
> From: Frank Febbraro [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 07, 2004 1:01 PM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL 4.1.7 Network slowdown
>
> > >
> > This might be related to a bug I filed a couple months ago, assuming
> > your server is running on Windows
> >
> > http://bugs.mysql.com/bug.php?id=5787
>
> Sorry, I did not mention it, we are running on Linux, Fedora Core 3 to be
> exact.
>
My client machine (the remote machine in this mix
> This might be related to a bug I filed a couple months ago, assuming
> your server is running on Windows
>
> http://bugs.mysql.com/bug.php?id=5787
Sorry, I did not mention it, we are running on Linux, Fedora Core 3 to be exact.
--
MySQL General Mailing List
For list archives: http://lists.mys
> I have tried it with both utf8 and latin1, no difference in delay.
Sorry, to be more specific.
I have tried it originally with everything as UTF-8 (database, tables,
connections) I thought that the encoding could be the problem so I
converted/configured everything to latin1 (ISO-8859-1) and hav
> What character set are you using in the JDBC driver? Does it happen to
> be utf-8?
I have tried it with both utf8 and latin1, no difference in delay.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Got me then?! I am still running 4.0.22. Waiting for the connecter/J
to come out of gamma and for 4.1.* to stabilize a bit, so I can't offer
much other than what I have read.
Frank Febbraro wrote:
Are you seeing the slowdown only from your java app? Or from all clients?
I see this slowdown f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank Febbraro wrote:
>>Are you seeing the slowdown only from your java app? Or from all clients?
>
>
> I see this slowdown from my java app AND from the remote MySQL client
> application (called MySQL Query Browser 1.1.1 and 1.1.2). Basically I
> s
> Are you seeing the slowdown only from your java app? Or from all clients?
I see this slowdown from my java app AND from the remote MySQL client
application (called MySQL Query Browser 1.1.1 and 1.1.2). Basically I
see the slowdown from all clients that are remote machines, but I do
not see it w
Frank Febbraro wrote:
The MySQL-client is 4.1.7, too?
Yes
The localhost mysql command is version 4.1.7-standard
The remote query browser is version 1.1.1 gamma
The remote JDBC driver is version 3.0.16-ga
Are you seeing the slowdown only from your java app? Or from all clients?
In the changelog f
Frank,
Wouldn´t it because the client driver (ODBC version)?
Perhaps it´s faster in the local server because it uses a mysql-4.1.7
client.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> The MySQL-client is 4.1.7, too?
>
Yes
The localhost mysql command is version 4.1.7-standard
The remote query browser is version 1.1.1 gamma
The remote JDBC driver is version 3.0.16-ga
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Hmmm...
The MySQL-client is 4.1.7, too?
I realy don´t know if it make some difference, but perhaps
it does.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for the response
> If you provide more informations like the query and how
> many rows it returns, it should be easier help you.
The query is: select * from cmContent;
The query returns 228 rows.
mysql> describe cmContent;
+-+--+--+-+-
Frank,
If you provide more informations like the query and how
many rows it returns, it should be easier help you.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ry browser, or using Connector/J) we get 228
rows in 5172 msec.
I do not really know what to do to try to determine the cause of the
slowdown. Using trace route there is only one hop directly to the DB
server and large files transfer lightning quick so I do not think it
is a network problem, bu
1 - 100 of 212 matches
Mail list logo