RE: finding exact query being run

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

RE: Mysql error causing database to not accept threads

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

RE: Strange errors / messages on slave server

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.

RE: Innodb buffer pool usage

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

RE: Innodb buffer pool usage

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:

Help with export and import into Oracle

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

Data handling during exports

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

RE: FW: MySQL export and import into Oracle

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

RE: table export in cron

. 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 machiel.richa...@gmail.com

table export in cron

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

Mysql Certification exams

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

RE: RE: Innodb buffer pool size filling up

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

RE: Innodb buffer pool size filling up

. 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 -Original Message- From

MySQL variables

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.

RE: Innodb buffer pool size filling up

...@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

RE: Innodb buffer pool size filling up

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

MySQL - determine last date of shutdown and analyze

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.