mmm... I am not sure about the connection pooling... Fairly new to the site.
What I do know is that they run a couple of web servers that connect to the
MySQL database and are currently experiencing some performance and
connection problems.
There are a lot of processes that have been runnin
Hi
Yes, we did check the amount of free O/S memory and this was the
same as during normal operating times when the system is working.
Even the load averages on the system was very low.
At the moment of this incident there was only 300 odd connections
from the website where
Hi All
Just one other note on this issue experienced.
I used google to try and find some solutions / clues and all the
suggestions are to increase the innodb buffer pool size.
This was however recently done on the database to increase this to
4Gb already.
However
Hi Carlos (and all)
I had a look at the script that we use an the following is the
calculations that is used to calculate the innodb buffer usage.
Machiel
-Original Message-
From: Carlos Proal [mailto:carlos.pr...@gmail.com]
Sent: 16 March 2010 9:31 AM
To: mysql@lists.mysql.co
HI Carlos
We run a script for the monitoring and the output received is as
follows:
InnoDB Buffer Pool __
Usage 3.00G of 3.00G %Used: 100.00
Read hit 100.00%
Pages
Free 0%Total: 0.00
Data
Good day guys
I previously requested information regarding the exporting
of data which needs to be imported into oracle.
We are however still struggling with the data though and
maybe someone can give me some ideas...
It seems that one of
Thank you for the link but seeing that I am still new with MySQL , this does
not mean anything to me.
From: prabhat kumar [mailto:aim.prab...@gmail.com]
Sent: 08 January 2010 4:22 PM
To: machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: FW: MySQL export and import into Oracle
http
Hi guys,
Can you please assist me in rewriting this query in order to run this
against a mysql database?
It seems that the decode function does not exist in mysql.
select
decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr,
count(*) tot
from profiles
where email i
Good day all...
I have some questions regarding data handling when doing
exports in mysql.
This is a follow up on my mails yesterday about the exports
within a cron.
What we found now was places where the users for instance
manually ent
.
Regards
-Original Message-
From: Nicola Salvemini [mailto:nicolasalvem...@yahoo.it]
Sent: 07 January 2010 3:45 PM
To: sureshkumar...@gmail.com; Mikhail Berman; machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: table export in cron
- machiel.richards wrote
Hi all
I have a question regarding exporting of tables to a file
from mysql.
We need to export tables from mysql to a delimeted file
which will then be imported into another database (oracle).
We can do this manually from within mysql usin
Good day all
I hope that someone can help me out with some resources.
Due to lack of interest my MySQL training was cancelled in
December.
However I need to get certified (MySQL DBA) ASAP and need to
do this on book knowledg
Thank you very much.
This now explains a lot.
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: 18 December 2009 10:05 AM
To: machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: RE: Innodb buffer pool size filling up
Machiel,
That is how it is supposed to
yone in advance.
Regards
Machiel
-Original Message-
From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com]
Sent: 01 December 2009 10:04 PM
To: 'machiel.richards'; 'Claudio Nanni'
Cc: mysql@lists.mysql.com
Subject: RE: Innodb buffer pool size filling up
Good day guys (and girls if any)
I am constantly in a position where variables on a
production mysql database needs to be changed.
The database runs a 24/7 system and thus to reboot is not
preffered and should be the absolute last resort.
...@gmail.com]
Sent: 01 December 2009 01:12 PM
To: machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: Innodb buffer pool size filling up
That is basically its use,
the buffer pool is the collection of all mysql innodb buffers,
and after warm up it goes to keep all cacheable data.
How big is your
There are no errors in the logs at all.
We have a script to calculate the percentages used and free in order
to do daily,weekly and monthly reporting trend analyses and thus we notice
the growth but no errors.
-Original Message-
From: Neil Aggarwal [mailto:n...@jammconsulting.co
Hi all
I hope someone can help me out here as I am still new with MySQL.
I am trying to determine when last a MySQL database was shut down and
when last the tables were analyzed.
Can someone please assist in this and let me know if this is
possible.
18 matches
Mail list logo