Hi Jim,
On 10/31/2018 7:12 PM, Halaasz Saandor wrote:
2018/10/31 15:15 ... Jim:
Given the following bug report, what I am trying to do does not sound
hopeful:
https://bugs.mysql.com/bug.php?id=90994
...
Any thoughts or do I need to accept that what I'm attempting just
isn't going to work?
2018/10/31 15:15 ... Jim:
Given the following bug report, what I am trying to do does not sound
hopeful:
https://bugs.mysql.com/bug.php?id=90994
...
Any thoughts or do I need to accept that what I'm attempting just isn't
going to work?
From the same bug report, id=90994:
[24 Oct 20:17] B
I'm trying to configure replication of a mysql5.1 database master server
to a mysql8.0 database server.
But the replication connection will not succeed.
I don't believe the issue is directly related to replication, because
any connection attempt from mysql8.0 to mysql5.1 fails as follows.
As r
Learner Study writes:
> Setup:
> MySQL 5.6.16 + thread pool extensions running on 3.18 kernel
>
> Two sysbench clients running from different PCs with total of 14k
> connections, each connection doing 2 select queries per sec.
>
> When I specify 7k connections from each c
nning from different PCs with total of 14k
>> connections, each connection doing 2 select queries per sec.
>>
>> When I specify 7k connections from each client, sysbench shows latency
>> of .3 msec (for both sides)
>>
>> If I run with 13k from one client and 1k from the ot
Hello MySQL experts,
I am new to MySQL and am seeing following behavior
Setup:
MySQL 5.6.16 + thread pool extensions running on 3.18 kernel
Two sysbench clients running from different PCs with total of 14k
connections, each connection doing 2 select queries per sec.
When I specify 7k
Hi all!
I would like know if there are any calculatios for
specifying the maximum number of the 'max_connections' value.
I understand that max_connections should be decided by the remaining RAM size
of the system. But exactly how should it be actually calculated?
I am currently using RHEL 5.3 3
:wleut...@columbus.rr.com]
> Sent: Friday, September 21, 2012 7:04 AM
> To: mysql@lists.mysql.com
> Subject: Default Values for Max User and Max Connections.
>
> Hello All,
>
> Question. In mysql 5.5 what are the defaults for these values:
>
> max_connections = ? (is
Hello All,
Question. In mysql 5.5 what are the defaults for these values:
max_connections = ? (is this set to 151 in 5,5)
max_user_connections = ?(is this set to unlimited unless you provide
the exact number)?
Thank you so much.
Wayne Leutwyler, RHCT
Open Source + Open M
put increases almost linearly with the number
> of C# threads, until I reach 100 threads, which is the maximum number
> of connections allowed by my server.
>
> This is quite unexpected, since the server has only two processors. I
> expect the throughput to grow from one connection to
number of C# threads I found that the time
taken to finish the benchmark decreases, thus increasing the
throughput. The throughput increases almost linearly with the number
of C# threads, until I reach 100 threads, which is the maximum number
of connections allowed by my server.
This is quite
On Mon, Nov 29, 2010 at 2:21 PM, Peter Wang wrote:
> We had have a similar problem caused by broken network-card, use
> `/sbin/ifconfig | grep errors' to check errors/dropped counter. for
> example, broken network-card may cause many connections, since normal
> tcp connect op
Johan De Meersman writes:
Hi,
You may check the network at that time.
We had have a similar problem caused by broken network-card, use
`/sbin/ifconfig | grep errors' to check errors/dropped counter. for
example, broken network-card may cause many connections, since normal
tcp connect
3 PM, Nigel Wood wrote:
> >
> > > Quick thought: what is your idle timeout set to on the MySQL server?
> > > Could you have configured it to reap these idle connections?
> > >
> >
> > I could, probably, but the applications are generally well-behaved, and
&
sman wrote:
> On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood wrote:
>
> > Quick thought: what is your idle timeout set to on the MySQL server?
> > Could you have configured it to reap these idle connections?
> >
>
> I could, probably, but the applications are generally we
On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood wrote:
> Quick thought: what is your idle timeout set to on the MySQL server?
> Could you have configured it to reap these idle connections?
>
I could, probably, but the applications are generally well-behaved, and it's
not a recurring p
Seen this a lot with poorly written web apps which open connections but dont
close them when finished. Try setting wait_timeout and/or
interactive_timeout to close unused connections.
John
On 24 November 2010 11:27, Johan De Meersman wrote:
> Hey,
>
> Late last night, I got a call
were writeable - so not hanging write flood - and when I eventually
sent a kill, the daemon did a clean shutdown and came back up without a
hitch.
Unfortunately I couldn't log in while this was going on because I never
configured a few extra connections for super - that's been fixed by n
Hi Carlos,
>From your trailing mail I noticed the below GRANT. This will just give
'cmennens'@'ideweb1.iamorlando.com' access to mysql but not any databases.
*Access to mysql:*
| GRANT USAGE ON *.* TO 'cmennens'@'ideweb1.iamorlando.com' IDENTIFIED
BY PASSWORD '' |
In addition t
ssing something. MySQL is rejecting incoming connections from my
host machine that I have WorkBench installed on. Please help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar wrote:
> GRANT ALL PRIVILEGES ON *.* TO username@'tuna.iamghost.com' IDENTIFIED BY
> PASSWORD 'password';
>
> *.* ie for all databases , if want on particular DB
>
> GRANT ALL PRIVILEGES ON MyDATABASE.* TO username@'tuna.iamghost.com'
> IDENTIFIED BY
:mich...@weblore.com]
Sent: Tuesday, July 13, 2010 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: Allowing Connections From Remote Clients
On Tuesday, July 13, 2010 02:25:33 pm Prabhat Kumar wrote:
> GRANT ALL PRIVILEGES ON **.** TO username@'tuna.iamghost.com' IDENTIFIED BY
> PASSWORD &#x
BASE.** TO username@'tuna.iamghost.com'
> IDENTIFIED BY PASSWORD 'password';;
>
You also need to verify that you don't have network connections turned off in
/etc/my.cnf
if you have skip-networking, comment it out
also make sure that the bind-address is set to 192.
lowed to connect to this MySQL server."
>
> Can someone please tell me what I need to do so I can allow remote
> connections to the database from the MySQL workbench application? I
> have access to MySQL via CLI.
>
> Thank you!
>
> --
> MySQL General Mailing List
&g
to do so I can allow remote
connections to the database from the MySQL workbench application? I
have access to MySQL via CLI.
Thank you!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
om:* Rob Wultsch [mailto:wult...@gmail.com]
> *Sent:* 02 July 2010 10:46 AM
>
> *To:* Machiel Richards
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: Mysql connections not released
>
>
>
> A bad assumption I make these days is that everyone has skip resolve off.
> If th
RDC_Logo
From: Rob Wultsch [mailto:wult...@gmail.com]
Sent: 02 July 2010 10:46 AM
To: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released
A bad assumption I make these days is that everyone has skip resolve off. If
that is the case DNS issues will not impac
d on the net it also suggests that it might be network
> or DNS related.
>
>
>
> The connections building up is the following:
>
>
>
> *** 1346. row
> ***
>
> Id: 903175
&g
Hi
From a thread found on the net it also suggests that it might be network
or DNS related.
The connections building up is the following:
*** 1346. row
***
Id: 903175
User: unauthenticated user
processes were
> increasing the whole time.
>
> · From the details, it seemed that all the connections were coming
> from the website and were trying to make connections to the database,
> however the statuses never changed from connect to anything else, and yet
> the amount
before it went down
(so to speak).
What I found was the following:
. When running ' show processlist', the amount of processes were
increasing the whole time.
. From the details, it seemed that all the connections were coming
from the website and w
I think its more on the app side that is causing the problem.
Check if the connections are getting closed on the app side after the job is
done.
Also u might to check on slow or general query log to know what is happening
on the db side.
Also check the load on the db server.
We have db&#
Sent: Thursday, February 25, 2010 6:28
PM
Subject: Re: What is "unusually high" for
the # of connections to MySQL?
It depends, but 100 is not strange at all, particularly if
you have sleeping connections
(usually due to slow page loading (ajax?) and/or persistent connections
fro
;'SHOW VARIABLE''
makes no sense at all. I have not executed such a function in my code.
Thanks,
Jesse
- Original Message -
From: Claudio Nanni
To: Jesse
Cc: mysql@lists.mysql.com
Sent: Thursday, February 25, 2010 6:28 PM
Subject: Re: What is "unusually
It depends, but 100 is not strange at all, particularly if you have sleeping
connections
(usually due to slow page loading (ajax?) and/or persistent connections from
the app)
and any number of connections cannot crash a server, can make it slow or
unusable, but not crash it.
Watch the app, you
I was wondering what would be considered "unusually high" for the # of
connections to a MySQL Server? Also, if a high number of these are in
"sleep" mode,does it make a difference?
We have a web site (a few, actually) and MySQL (Version
5.0.67-community-nt-log) running o
mg>hopefully quick comments
> Date: Sun, 7 Jun 2009 04:41:20 -0600
> Subject: Thread safe queries with multiple connections
> From: buf...@biffco.net
> To: mysql@lists.mysql.com
>
> I think my question is whether the data in MYSQL_RES and MYSQL_ROW data
> structures are
I think my question is whether the data in MYSQL_RES and MYSQL_ROW data
structures are sufficiently independent from that of other instances of
those data structures in a multi-threaded situation when a pool of
connections are share. The application my have multiple connections
structures defined
g (user must be certified) but your
local one doesn't, that would explain it.
What are your MySQL versions on both your server and remote client?
What errors do you get on your client?
Regards,
Andy
Stefano Elmopi wrote:
Hi,
I'm trying to make connections ssl.
I followed the MySQ
local one
doesn't, that would explain it.
What are your MySQL versions on both your server and remote client?
What errors do you get on your client?
Regards,
Andy
Stefano Elmopi wrote:
Hi,
I'm trying to make connections ssl.
I followed the MySQL guide and I've configur
Hi,
I'm trying to make connections ssl.
I followed the MySQL guide and I've configured the server
then I created a normal user, without the REQUIRE SSL.
On the same server can connect with the only option:
mysql --ssl-ca=cacert.pem -u Pluto -p
but if I try to connect from anoth
Hi Seth,
I implemented SSL successfully just a couple of weeks ago on 5.1.30, and
I too found some aspects confusing. Here's my answers from my own
experience so please forgive me if they're inaccurate.
1) On the server side, I believe ssl-ca, ssl-cert and ssl-key are all
required to establ
Howdy,
I've read through all of the MySQL docs on SSL and I just need a brief
overview of a few things to understand some things that aren't crystal
clear to me since I'm not very familiar with SSL.
1) Which SSL options are *required*?
It seems that only ssl-key is _always_ required for
Hi,
I think you need to take into consideration the following thins:
1. The number of connections that can come at any point of time
(depending up on the statisics) set global max_connections=1000
2.decrease the wait time out variable wait_timeout=30 or even lower
value depending upon
Sep 2008 10:51
> Asunto: RE: too many connections
>
>
> in my.cnf configuration file try upping the number of connections
> max_connections=3072
> to
> max_connections=6144
>
> Martin
> __
> Disclaimer and confidentiali
You have to use mysql 64bits on S.O. 64bits
--Mensaje original--
De: Martin Gainty
Para: Kinney, Gail
Para: 'mysql@lists.mysql.com'
Enviado: 19 Sep 2008 10:51
Asunto: RE: too many connections
in my.cnf configuration file try upping the number of connections
max_connectio
subsequent requests. New connections are
created if no persistent connection is available. Unfortunately,
connections allocated though mysql_pconnect are never closed. If the
rate of requests should spike, PHP will potentially allocate every
connection and never release them, even after traffic
TED]
> *Sent:* Friday, September 19, 2008 9:44 AM
>
> *To:* Kinney, Gail
> *Subject:* Re: too many connections
>
>
>
> Are there any UPDATE queries being executed? Which storage engines are you
> using?
>
> On 9/19/08, *Kinney, Gail* <[EMAIL PROTECTED]> wrote:
>
In case you're using PHP, in theory all database connections should be
closed when script stops execution. I'm not sure if it's always like that in
practice.
Persistent connections can be a quick fix to your problem, but as was
mentioned in the previous mail, it's better to
Gail,
I know the list has already recommended allowing more connections but the
bigger question is what is sucking them all up. Even with 1000 connections
things like apache can only use the number of connections that there are
processes (* the number of connections used within each process
On 9/19/08, Kinney, Gail <[EMAIL PROTECTED]> wrote:
>
> Hello, We have MySQL 4.0.14 and have just gotten an error:
>
Please help.
>
Answer the door, 2004 is calling.
--
-jp
I hope that someday we will be able to put away our fears and prejudices and
just laugh at people.
deepthoughtsbyjackh
in my.cnf configuration file try upping the number of connections
max_connections=3072
to
max_connections=6144
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender
On Fri, Sep 19, 2008 at 9:07 PM, Olexandr Melnyk <[EMAIL PROTECTED]> wrote:
> Restart MySQL server
>
> On 9/19/08, Kinney, Gail <[EMAIL PROTECTED]> wrote:
> >
> > Hello, We have MySQL 4.0.14 and have just gotten an error: too many
> > connections. we can&
Restart MySQL server
On 9/19/08, Kinney, Gail <[EMAIL PROTECTED]> wrote:
>
> Hello, We have MySQL 4.0.14 and have just gotten an error: too many
> connections. we can't connect to our site using MySQL admin. Please help.
>
> Gail Kinney
> Webmaster UC Denver
Hello, We have MySQL 4.0.14 and have just gotten an error: too many
connections. we can't connect to our site using MySQL admin. Please help.
Gail Kinney
Webmaster UC Denver
[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM:
Hi Raj,
In which path the trace file would be created.
In your current path itself.
Or just do
strace -o /tmp/mysql.strace -T mysql -u root -h host -p
The "mysql -u root -h host -ppassword" is the command which you
Thank u very much.
regards
anandkl
On 8/13/08, Raj Shekhar <[EMAIL PROTECTED]> wrote:
>
> in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM:
>
>> Hi Raj,
>> In which path the trace file would be created.
>>
>
> In your current path itself.
>
> Or just do
> strace -o /tmp/
Hi Raj,
In which path the trace file would be created.
regards
anandkl
On 8/13/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> In infinite wisdom "Krishna Chandra Prajapati" <[EMAIL PROTECTED]>
> spoke thus:
>
> > Hi all,
> >
> > Connecting to mysql server (Production) is taking 5 to 6 seco
In infinite wisdom "Krishna Chandra Prajapati" <[EMAIL PROTECTED]> spoke thus:
> Hi all,
>
> Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
> has 16Gb ram. Previously it was using only 6GB ram. The details are as
> follows. DNS looks fine.
Is it that the database yo
You should run into out of memory scenaria. OS is keeping to free some
memory that delay mysql connection.
On 8/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote:
>
> > Do you have any other services running on th
On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote:
> Do you have any other services running on the server, such as mail or web?
> How long does it take to connect to those services ('telnet 25',
> or telnet 80')?
No
>
> What are you using to connect to mysql? how lo
Do you have any other services running on the server, such as mail or
web? How long does it take to connect to those services ('telnet
25', or telnet 80')?
What are you using to connect to mysql? how long does 'telnet
3306' take (assuming you are on the default port and have
firewa
Hi all,
Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
has 16Gb ram. Previously it was using only 6GB ram. The details are as
follows. DNS looks fine.
free -m
total used free sharedbuffers cached
Mem: 15899 15877
Check if your connections are too large to afford any other connections.
On Mon, Aug 11, 2008 at 8:54 PM, Krishna Chandra Prajapati <
[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Connecting to mysql server is taking lot of time near around 4 to 5
> seconds.
> Its a penti
Hi All,
Connecting to mysql server is taking lot of time near around 4 to 5 seconds.
Its a pentium box with 512Mb ram max_connections=200
what can be the reason ?
--
Krishna Chandra Prajapati
you can do this
set global max_connections=2500;
On 8/5/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Thanks a lot.
>
> Is there any way to increase the maximum no of connections without
> restarting mysql server.
>
> On Tue, Aug 5, 2008 at
Thanks a lot.
Is there any way to increase the maximum no of connections without
restarting mysql server.
On Tue, Aug 5, 2008 at 2:39 PM, Vladislav Vorobiev <[EMAIL PROTECTED]
> wrote:
> 2008/8/5 Krishna Chandra Prajapati <[EMAIL PROTECTED]>:
> > Hi All,
> >
> >
2008/8/5 Krishna Chandra Prajapati <[EMAIL PROTECTED]>:
> Hi All,
>
> I am trying to connect to mysql server. Buts, Its giving " too many
> connections". How to increase the max_connection on mysql server.
>
> When i am giving mysql -u root -p
> Still, its gi
Hi All,
I am trying to connect to mysql server. Buts, Its giving " too many
connections". How to increase the max_connection on mysql server.
When i am giving mysql -u root -p
Still, its giving too many connections.
How to solve this problem.
--Thanks
Krishna Chandra Prajapati
can't seem to find anything on my problem. hope list can help:
thread class creates connection to mysql - all is well
if sql takes too long, calling thread interrupts thread, and close
resources:
rs.close(), stmt.close(), conn.close()
however mysqld server connections are not closed
af
On Fri, Jun 6, 2008 at 9:25 PM, TUT - LightSpeed <[EMAIL PROTECTED]> wrote:
>
> Actually they are 2 connection to 2 different databases on 2 different
> hosts.
> I wanted rquery results from db1 to be in a temporary table to be used in
> db2.
> I can go around it with some php code to create the t
emp table on multiple connections
On Fri, Jun 6, 2008 at 2:28 PM, TUT - LightSpeed <[EMAIL PROTECTED]>
wrote:
I have this problem
I connect to 2 database servers in the same script
If I create a temp table on one, won't be able on the other
$db1 = db_connect1();
$db2 = db_connect2
db_connect2();
>
> I get error that temp_table doesn't exist on db2
>
> How can it be possible to use it on db2 queries ?
>
Temporary tables are locked down to just the current connection, so you
really can't. If you really need to use two connections to the same
database, you co
I have this problem
I connect to 2 database servers in the same script
If I create a temp table on one, won't be able on the other
$db1 = db_connect1();
$db2 = db_connect2();
$query = "CREATE TEMPORARY TABLE temp_table SELECT ..";
$result = mysql_query($query,$db1) or die(mysql_err
s a user can connect per
> hour..
>
> -Eric
>
> 2008/3/31 Vidal Garza <[EMAIL PROTECTED]>:
>
>
> > Velen escribió:
> >
> >
> > > Hi,
> > >
> > > How can i limit connections to my database?
> > >
> >
You probably only want max_connections and not max_user_connections.
Max_user_connections is the number of times a user can connect per
hour..
-Eric
2008/3/31 Vidal Garza <[EMAIL PROTECTED]>:
> Velen escribió:
>
>
> > Hi,
> >
> > How can i limit connections
Velen escribió:
Hi,
How can i limit connections to my database?
Regards,
Velen
max_user_connections = 50
max_connections = 50
--
Ing. Vidal Garza Tirado
Depto. Sistemas
Aduanet S.A. de C.V.
Tel. (867)711-5850 ext. 4346, Fax (867)711
On Sun, Mar 30, 2008 at 9:59 AM, Velen <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> How can i limit connections to my database?
RTFM: http://dev.mysql.com/doc/refman/5.0/en/user-resources.html
--
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL Genera
Hi Velen,
you have to put this parameter in the [mysqld] section of .my.cnf file:
max_connections = n # n is the number of connections desired
don't forget to restart mysql!
Aloha!
Claudio Nanni
-Messaggio originale-
Da: Velen [mailto:[EMAIL PROTECTED]
Inviato: domeni
Hi,
How can i limit connections to my database?
Regards,
Velen
In response to an email offlist, I forgot to specify that these are
InnoDB tables.
On Mon, Mar 3, 2008 at 2:53 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> I've been noticing strange load spikes on our mysql machine, throwing
> back the dreaded "max connections error", e
I've been noticing strange load spikes on our mysql machine, throwing
back the dreaded "max connections error", even though the value is set
to 500. I'm wondering if this is related to an hourly script I run
that does a few somewhat-db intensive queries. The script runs a
m ok, then you can focus recovery/restore options on that
> database.
>
>
> - Rick
>
>
> Original Message
> > Date: Friday, January 25, 2008 08:07:32 AM -0500
> > From: Paul Berry <[EMAIL PROTECTED]>
> > To: mysql@lists.mysql.com
&g
hey guys - overnight our sql server apparantly got hit hard, and started
dropping connections
it was restarted and now this morning even though its showing 0 processes
running, seems
completely healthy on all tests, mysqld restarted with no sign of problems -
none of the
web servers can connect to
hello,
i'm searching for some information about how many system memory mysql
uses in relation to the open connections.
in the last weeks we often had the problem of "too many connections",
but before raising the configuration value, we would like to calculate a
maximum amount of u
On Dec 22, 2007 10:55 AM, Moon's Father <[EMAIL PROTECTED]> wrote:
> how big your mysql connections's users.
How big users? don't know what you said.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 20.12.2007 22:46 CE(S)T, Martijn Tonies wrote:
>> Okay, I got that. So a COMMIT statement after disabling autocommit mode
>> and another START TRANSACTION does not finish my transaction. (But then,
>> what does?) Interesting view, I didn't know that. But now all's clear: I
>> won't touch autocom
> >> So MySQL does support nested transaction and both "SET AUTOCOMMIT = 0"
> >> and "START TRANSACTION" start a new transaction level, is that true?
> >
> > I didn't say it supports nested transactions, I said that if your
> > application
> > starts a single transaction and does not finish it, it
On 20.12.2007 21:34 CE(S)T, Martijn Tonies wrote:
>> So MySQL does support nested transaction and both "SET AUTOCOMMIT = 0"
>> and "START TRANSACTION" start a new transaction level, is that true?
>
> I didn't say it supports nested transactions, I said that if your
> application
> starts a single
On 20.12.2007 22:18 CE(S)T, Baron Schwartz wrote:
> On Dec 20, 2007 3:33 PM, Yves Goergen <[EMAIL PROTECTED]> wrote:
>> I wasn't able to find MVCC-related information (I assume it means Multi
>> Version Concurrency Control, not sure whether that's correct) in the
>> MySQL manual. But Martijn's expl
Hi,
On Dec 20, 2007 3:33 PM, Yves Goergen <[EMAIL PROTECTED]> wrote:
> On 20.12.2007 21:14 CE(S)T, Baron Schwartz wrote:
> > It doesn't support nested transactions. What you're seeing is the
> > effects of MVCC. The InnoDB section of the MySQL manual explains it.
>
> I wasn't able to find MVCC-r
> On 20.12.2007 20:34 CE(S)T, Martijn Tonies wrote:
> > Are your tables InnoDB? If so, the snapshot transaction is giving you
> > a static view on the data and your own changes, while your PHPMyAdmin
> > commits the NULL write. Your application keeps on seeing your own
> > changes, cause it did
On 20.12.2007 21:14 CE(S)T, Baron Schwartz wrote:
> It doesn't support nested transactions. What you're seeing is the
> effects of MVCC. The InnoDB section of the MySQL manual explains it.
I wasn't able to find MVCC-related information (I assume it means Multi
Version Concurrency Control, not su
On 20.12.2007 20:34 CE(S)T, Martijn Tonies wrote:
> Are your tables InnoDB? If so, the snapshot transaction is giving you
> a static view on the data and your own changes, while your PHPMyAdmin
> commits the NULL write. Your application keeps on seeing your own
> changes, cause it did not end the s
Hi,
On Dec 20, 2007 2:26 PM, Yves Goergen <[EMAIL PROTECTED]> wrote:
> On 20.12.2007 19:42 CE(S)T, Yves Goergen wrote:
> > But when I set that column to NULL
> > with phpMyAdmin, my application still reads the old data from the
> > database. phpMyAdmin keeps telling me that the value is actually N
Yves,
> On 20.12.2007 19:42 CE(S)T, Yves Goergen wrote:
> > But when I set that column to NULL
> > with phpMyAdmin, my application still reads the old data from the
> > database. phpMyAdmin keeps telling me that the value is actually NULL,
> > which I just entered. Whereas the persistent PHP conn
On 20.12.2007 19:42 CE(S)T, Yves Goergen wrote:
> But when I set that column to NULL
> with phpMyAdmin, my application still reads the old data from the
> database. phpMyAdmin keeps telling me that the value is actually NULL,
> which I just entered. Whereas the persistent PHP connection doesn't see
Hi,
today I have noticed a strange bug with MySQL and PHP. I'm developing a
PHP application, using the MySQL database server 5.0.45 on Windows XP
and the PDO connection objects (PHP Data Objects). The PHP application
works on InnoDB tables and uses transactions and persistent connections.
O
It is set in mysql's config file.
Have you traced into your program?
Albert Sanchez:
> Is there a limit of connections (open and close) that mysql can carry? or a
> limit by second?
>
> I have a big memory crash (double free or corruption) in my program and I
> smell th
Is there a limit of connections (open and close) that mysql can carry? or a
limit by second?
I have a big memory crash (double free or corruption) in my program and I
smell that it could be mysql,
thanks a lot,
Albert
1 - 100 of 711 matches
Mail list logo
