Re: Assistance with trigger

2019-04-26 Thread Machiel Richards
Please ignore my request as I have managed to figure this out. Thank you. had to rewrite the insert to use Old.Column1... etc... and that works quite well. From: Machiel Richards Sent: Friday, 26 April 2019 10:48 AM To: mysql@lists.mysql.com Subject

Assistance with trigger

2019-04-26 Thread Machiel Richards
Hi All I am hoping this email finds all well. I would like to request some assistance with a MySQL trigger please. We need to implement a trigger that will in short terms make a backup of a row before it gets deleted. so we have tableA and TableB (backup table). I added a

Re: High cpu usage

2018-10-26 Thread Machiel Richards
ursday, 25 October 2018 9:54:10 PM To: mysql@lists.mysql.com Subject: Re: High cpu usage Hello Machiel, On 10/25/2018 6:09 AM, Machiel Richards wrote: > Good day all > > > Hoping this mail finds you well. > > > I am hoping someone can perhaps give us some guidance her

High cpu usage

2018-10-25 Thread Machiel Richards
Good day all Hoping this mail finds you well. I am hoping someone can perhaps give us some guidance here as we now seem to be stuck on a problem and have not been able to find a solution after more than a month. We are running an opensips server on Centos 6.5 , using mysql 5.7.13

info on open tables

2018-09-28 Thread Machiel Richards
Hi all I am hoping this mail finds all well. I have a question about mysql open tables and open_table_cache which I do not seem to be finding the answer to on the internet. We are busy investigating an issue on a server where we have erattic behaviour. During the times

Re: Optimize fails due to duplicate rows error but no duplicates found

2018-02-13 Thread Machiel Richards
mysql@lists.mysql.com Subject: Re: Optimize fails due to duplicate rows error but no duplicates found Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards wrote: > Good day guys, > > > I am hoping this mail finds you well. > > > I am at a bit of a loss here... >

Re: Optimize fails due to duplicate rows error but no duplicates found

2018-02-13 Thread Machiel Richards
ql.com Subject: Re: Optimize fails due to duplicate rows error but no duplicates found Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards wrote: > Good day guys, > > > I am hoping this mail finds you well. > > > I am at a bit of a loss here... > > > W

Optimize fails due to duplicate rows error but no duplicates found

2018-02-13 Thread Machiel Richards
Good day guys, I am hoping this mail finds you well. I am at a bit of a loss here... We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed. However, after running for over an hour , the optimize fails stating

Network throughput for mysql replication

2017-05-16 Thread Machiel Richards
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

Re: tcmalloc mysql 5.7.14

2017-05-16 Thread Machiel Richards
how late this reply is) > > > On 5/8/2017 7:56 AM, Reindl Harald wrote: > >> >> >> Am 08.05.2017 um 13:51 schrieb Machiel Richards: >> >>> We are having an issue with memory allocations on mysql 5.7.14 >>> whereby mysql is not releasing the memo

Re: tcmalloc mysql 5.7.14

2017-05-08 Thread Machiel Richards
any help here. Regards On Mon, May 8, 2017 1:56 pm, Reindl Harald wrote: > > > Am 08.05.2017 um 13:51 schrieb Machiel Richards: > >> We are having an issue with memory allocations on mysql 5.7.14 whereby >> mysql is not releasing the memory that is being allocated du

tcmalloc mysql 5.7.14

2017-05-08 Thread Machiel Richards
Hi Guys I hope this mail finds everyone well. We are having an issue with memory allocations on mysql 5.7.14 whereby mysql is not releasing the memory that is being allocated during mysqldump processes. This has been logged as a bug with mysql dev team however they do not see this as

Optimize table partitions

2017-03-03 Thread Machiel Richards
Good day everyone I hope this mail is finding everyone well. I am asking for some insight again today as I can not seem to find the correct info on the net. Some of our database tables are quite large with millions of records. However due to disk space issues, we have done

mysql Archiving engine

2017-01-03 Thread Machiel Richards
Good day all Compliments of the season to everyone and I hope that this mail finds all well. I am trying to find out a bit more regarding the archiving storage engine. We currently have an archiving process that the dev team wrote for archiving of data. However, management

Re: MySql Swapping issues

2016-09-07 Thread Machiel Richards
they run large updates or reports. Biggest issue at the moment is mysql taking all physical memory until nothing left, the starts swapping as well until that is completely used up. On 07 Sep 2016 15:47, "Johan De Meersman" <vegiv...@tuxera.be> wrote: - Original Message -

MySql Swapping issues

2016-09-07 Thread Machiel Richards
Hi Guys I am hoping this mail find everyone to be good. I am looking for some more info or perhaps some advice on an issue that I am busy investigating. There are 4 databases that I am busy looking at that seems to be building up memory usage over the course of 3 to 4 days and once

Mysql into outfile problem

2014-02-19 Thread Machiel Richards
Hi guys I am hoping that someone might have experienced this before or might know why we are getting this. We regularly need to run some queries and export the results to a csv file. However we seem to be experiencing the following issues: - when we run an

Re: Mysql into outfile problem

2014-02-19 Thread Machiel Richards
, / Carsten On 19-02-2014 09:03, Machiel Richards wrote: Hi guys I am hoping that someone might have experienced this before or might know why we are getting this. We regularly need to run some queries and export the results to a csv file. However we seem

Re: Mysql into outfile problem

2014-02-19 Thread Machiel Richards
I have checked now and there is nothing in the Slow logs. On 19/02/2014 15:33, Johan De Meersman wrote: - Original Message - From: Machiel Richards machiel.richa...@gmail.com Subject: Mysql into outfile problem - when we run an explain on the query it shows

Mysql 5.1 union with group by for results

2013-11-08 Thread Machiel Richards
Good day all I am hoping someone can assist me in the following. One of our servers were running mysql 5.0 still and as part of a phased upgrade route we have upgraded to version 5.1. However since the upgrade, the query below gives us an error stating that the syntax

Re: Mysql 5.1 union with group by for results

2013-11-08 Thread Machiel Richards
Happiness, that gave me what I was looking for. Thank you Johan. I have tested the option you gave me but my brackets was in the wrong place. On 08/11/2013 13:23, Johan De Meersman wrote: - Original Message - From: Machiel Richards machiel.richa...@gmail.com ERROR 1064 (42000

Re: Mysql 5.1 union with group by for results

2013-11-08 Thread Machiel Richards
mysql time ;-) ). - I have now explained to them what the problem is and they will be working with the developers to rewrite all these queries. Regards Machiel. On 08/11/2013 13:27, Jesper Wisborg Krogh wrote: Hi Machiel, On 8/11/2013 20:04, Machiel Richards wrote: Good day all

Re: Master not creating new binary log.

2013-07-04 Thread Machiel Richards - Gmail
'%dir%'; (there may be other VARIABLES worth checking) What steps did you take for the move? (Actually move bin.1? Start over? etc?) Consider using expire_logs_days. 5.0 -- I don't think anything relevant has changed during 4.0 thru 5.6. -Original Message- From: Machiel Richards

Master not creating new binary log.

2013-07-03 Thread Machiel Richards - Gmail
Hi all I hope all are well. I would like some assistance with something really strange. We currently have a problem with a master slave setup running mysql 5.0. This is one of our legacy servers which are in the planning to be upgraded, however in order for this to

Assistance with replication

2012-11-12 Thread Machiel Richards - Gmail
Hi Guys We need some assistance with a master slave setup we are experiencing some issues with. We have one master with 2 slaves replicating from it. Both the slaves stopped working this morning in the early hours at exactly the same bin_log file and position.

Re: Assistance with replication

2012-11-12 Thread Machiel Richards - Gmail
/12 Machiel Richards - Gmail machiel.richa...@gmail.com mailto:machiel.richa...@gmail.com Hi Guys We need some assistance with a master slave setup we are experiencing some issues with. We have one master with 2 slaves replicating from it. Both

Mysql backup for large databases

2012-11-01 Thread Machiel Richards - Gmail
Hi All I am busy investigating some options relating to the backup for MySQL databases when they get quite large. When using the MySQL enterprise, there is the option to use the MySQL enterprise backup as it is part of the Enterprise license. However, when using the GA

Re: Mysql backup for large databases

2012-11-01 Thread machiel . richards
Well, the biggest problem we have to answer for the clients is the following: 1. Backup method that doesn't take long and don't impact system 2. Restore needs to be done on a quick as possible way in order to minimize downtime. The one client is running master - master replication with master

Temporary table creation fails

2012-09-10 Thread Machiel Richards - Gmail
Hi All I am hoping someone can point me in the right direction. We have a mysql 5.0 database which is giving us hassles when trying to create a temporary table. The creation works perfectly on the slave machine as well as all our other db's, however on the one specific main

Re: Temporary table creation fails

2012-09-10 Thread Machiel Richards - Gmail
/2012 11:05 AM, Ananda Kumar wrote: try this command and see if you can get more info about the error show innodb status\G On Mon, Sep 10, 2012 at 2:25 PM, Machiel Richards - Gmail machiel.richa...@gmail.com mailto:machiel.richa...@gmail.com wrote: Hi All I am hoping someone can

Re: Temporary table creation fails

2012-09-10 Thread Machiel Richards - Gmail
, Machiel Richards - Gmail machiel.richa...@gmail.com mailto:machiel.richa...@gmail.com wrote: Hi We tried that as well, however the databases are quite busy and either other transactions overwrite the info, or there is nothing logged. We even tried running the create

Re: Temporary table creation fails

2012-09-10 Thread Machiel Richards - Gmail
Hi, still no luck, same error being given immediately after pressing enter. On 09/10/2012 12:02 PM, Ananda Kumar wrote: start with 500MB and try On Mon, Sep 10, 2012 at 3:31 PM, Machiel Richards - Gmail machiel.richa...@gmail.com mailto:machiel.richa...@gmail.com wrote: Hi

Re: Temporary table creation fails

2012-09-10 Thread Machiel Richards - Gmail
and proper cnf file if you are giving so. Also specify the user as root if you have root access. Thanks On Mon, Sep 10, 2012 at 3:34 PM, Machiel Richards - Gmail machiel.richa...@gmail.com mailto:machiel.richa...@gmail.com wrote: Hi, still no luck, same error being given

Re: Temporary table creation fails

2012-09-10 Thread Machiel Richards - Gmail
Hi, We confirmed that the /tmp directory permissions is set to rwxrwxrwxt and is owned by root , the same as all our other servers. There is also about 60Gb of free space on the filesystem where /tmp resides. Regards On 09/10/2012 01:11 PM, Rik Wasmus wrote: the message ERROR

Re: Temporary table creation fails

2012-09-10 Thread Machiel Richards - Gmail
. Regards On 09/10/2012 02:33 PM, Ananda Kumar wrote: this temp table will hold how many rows, what would be its size. On Mon, Sep 10, 2012 at 5:03 PM, Machiel Richards - Gmail machiel.richa...@gmail.com mailto:machiel.richa...@gmail.com wrote: Hi, We confirmed that the /tmp

Re: Temporary table creation fails

2012-09-10 Thread Machiel Richards - Gmail
, forbidding you to create files, check if SELinux is disabled On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail machiel.richa...@gmail.com mailto:machiel.richa...@gmail.com wrote: Hi at the moment this does not really matter to us. we have even tried to create a temp

Re: Temporary table creation fails

2012-09-10 Thread Machiel Richards - Gmail
*From: * Machiel Richards - Gmail machiel.richa...@gmail.com; *To: * Ananda Kumar anan...@gmail.com; *Cc: * mysql@lists.mysql.com; *Subject: * Re: Temporary table creation fails *Sent: * Mon, Sep 10, 2012 12:41:51 PM no selinux , checked this as well. We generally dont use

Fwd: Question relating to transactions on innodb tables.

2011-11-25 Thread Machiel Richards - Gmail
Hi All Just a quick question relating to the use of transactions on innodb tables. We are doing some archiving on some innodb tables, however there seems to be some issues somewhere in the process with data not being updated accordingly. We would like to make use

Deleting of records older than a specific date time

2011-05-23 Thread Machiel Richards
Hi Everyone I have posted this question quite a while back and noticed now that I haven't gotten an answer as yet and this is still on my unresolved list. We have 2 tables which we want to archive data from. We need to be able to delete all data from the 2 tables that is

Mysql clustering

2011-02-22 Thread Machiel Richards
documentation on how to set everything up. If someone perhaps have the ebook version of the mysql clustering certification study guide, that would help me as well as I might be looking at going for the certification as well. Machiel Richards Relational Database Consulting (Pty) Ltd MYSQL

Replicating to mysql5.1 from 5.0 master?

2011-02-16 Thread Machiel Richards
suggestions would be greatly appreciated. (My feeling is to exclude the mysql database from replication but not too sure). Machiel Richards Relational Database Consulting (Pty) Ltd MYSQL / POSTGRES specialist 20 Stirrup Lane, Woodmead Office Park, Van Reenens Road, Woodmead, South Africa

MySQL 5.1 change master syntax issues?

2011-02-16 Thread Machiel Richards
to the master using these credentials, however Can't seem to spot my mistake in the command. The slave server is running mysql-5.1.50 and the master server is mysql-5.0 Machiel Richards Relational Database Consulting (Pty) Ltd MYSQL / POSTGRES specialist 20 Stirrup Lane, Woodmead

Multi slave-single master

2011-02-15 Thread Machiel Richards
Good day all I just have a quick question in order to confirm something.. If I remember correctly, one master are allowed to have more than one slave server (i.e. serverA can be master to both serverB and serverC) Am I correct in this matter? We are busy with a

Mysql Event scheduler

2011-01-10 Thread Machiel Richards
Good day all Can anyone perhaps off hand tell me whether the following two tasks will be able to be scheduled with the MySQL event scheduler? 1. MySQL backups using mysqldump 2. Analyzing of tables (all tables for all databases) Regards Machiel

Re: Stored procedure

2011-01-06 Thread Machiel Richards
() statement. Can anybody give me some ideas as I have tried so many options and yet none of them has worked as yet. Regards Machiel -Original Message- From: petya pe...@petya.org.hu To: Machiel Richards machi...@rdc.co.za Cc: mysql@lists.mysql.com Subject: Re: Stored procedure Date

Stored procedure

2011-01-05 Thread Machiel Richards
Good day all I am hoping that someone can assist me here. As per a client requirement, I am writing a script/stored procedure combination in order to do the following: - Script to be run within a cron once a day according to a set

Re: Stored procedure

2011-01-05 Thread Machiel Richards
HI How do I use the mysql event scheduler? I have not used this as yet so not sure how to use it. Regards Machiel -Original Message- From: petya pe...@petya.org.hu To: Machiel Richards machi...@rdc.co.za, mysql@lists.mysql.com Subject: Re: Stored procedure Date: Wed, 05

Re: Database procedures

2010-12-14 Thread Machiel Richards
. Regards Machiel -Original Message- From: Machiel Richards machi...@rdc.co.za To: mysql mailing list mysql@lists.mysql.com Subject: Database procedures Date: Tue, 14 Dec 2010 08:37:10 +0200 HI All I am hoping that someone with more experience than me can assist here. I

Database procedures

2010-12-13 Thread Machiel Richards
HI All I am hoping that someone with more experience than me can assist here. I am trying to find out how to write a database procedure within MySQL, however I have never worked with procedures in my life and the resources I found on the net thus far seems greek to me...

Resource required

2010-12-09 Thread Machiel Richards
HI Guys Does anybody know if there is a mysql mailing list where we can post for a position we have open in terms of MySQL dba. I know some mailing lists have a specific list for job ads... Regards Machiel

Re: Resource required

2010-12-09 Thread Machiel Richards
. Regards Machiel -Original Message- From: Johan De Meersman vegiv...@tuxera.be To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql@lists.mysql.com Subject: Re: Resource required Date: Thu, 9 Dec 2010 14:00:18 +0100 On Thu, Dec 9, 2010 at 1:46 PM, Machiel Richards machi

Moving of databases from one server to another

2010-12-08 Thread Machiel Richards
HI All I am hoping someone has had this before as this one is baffling me entirely. We did a MySQL database move from one machine to another one last night. The O/S versions are the same and so are the database version (5.1.22). The database was installed and configured

Re: Moving of databases from one server to another

2010-12-08 Thread Machiel Richards
Hi Johan Would the server require a restart after this or not? Machiel -Original Message- From: Johan De Meersman vegiv...@tuxera.be To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql@lists.mysql.com Subject: Re: Moving of databases from one server to another Date

Re: Moving of databases from one server to another

2010-12-08 Thread Machiel Richards
HI Johan Thank you for the advice... Problem resolved. Regards Machiel -Original Message- From: Johan De Meersman vegiv...@tuxera.be To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql@lists.mysql.com Subject: Re: Moving of databases from one server to another Date

Bind-address use?

2010-12-07 Thread Machiel Richards
Hi All I am unable to find an answer on what the bind-address in mysql-5.1 actually does. From the config file it says that it provides the same function as the previous skip-networking function. However, let's say I configure the bind-adress value to the IP of the

Re: Bind-address use?

2010-12-07 Thread Machiel Richards
what will the effect be if we disable this option in the config file by means of hashing out the option? will it break the database or just listen on any device? -Original Message- From: Claudio Nanni claudio.na...@gmail.com To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list

MySQL restore failing

2010-12-03 Thread Machiel Richards
Hi All I am hoping that someone could assist me with this one. I am trying to restore a database to a new machine for testing purposes. The current machine is running mysql-5.0.72sp1 and the new machine 5.1.50. When running the restore is runs for quite a while

Re: MySQL restore failing

2010-12-03 Thread Machiel Richards
then? The current proc tables have 16 columns. Any ideas? Regards Machiel -Original Message- From: partha sarathy par...@mafiree.com To: Machiel Richards machi...@rdc.co.za, mysql mailing list mysql@lists.mysql.com Subject: Re: MySQL restore failing Date: Fri, 3 Dec 2010 14:02:59

MySQL upgrade from 5.0.51a to 5.1.53

2010-11-30 Thread Machiel Richards
HI Guys I found some info regarding a method to upgrade mysql databases. Currently the version is at mysql-5.0.51a (as installed via the ubuntu-8.0.4 respository). I downloaded the only version available from the web (5.1.53) that will work on ubuntu [except for

Re: MySQL upgrade from 5.0.51a to 5.1.53

2010-11-30 Thread Machiel Richards
vegiv...@tuxera.be To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql@lists.mysql.com Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53 Date: Tue, 30 Nov 2010 11:29:29 +0100 I suspect you need to have the new version running instead of the old one, for the mysql_upgrade script

RESOLVED - Re: MySQL upgrade from 5.0.51a to 5.1.53

2010-11-30 Thread Machiel Richards
earlier. Regards Machiel -Original Message- From: Johan De Meersman vegiv...@tuxera.be To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql@lists.mysql.com Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53 Date: Tue, 30 Nov 2010 11:29:29 +0100 I suspect you need to have

Uprading of MySQL

2010-11-25 Thread Machiel Richards
Hi Guys I am looking for some suggestions here please. This is related to a previous question I had regarding the upgrading of mysql 5.0.51a to mysql 5.1.53. The database is running on Ubuntu-8.0.4 and as stated the only repository was the 5.0.51a version. In order to be able to

MMM setup and requirements

2010-11-24 Thread Machiel Richards
Good day all I was asked to research the MMM multi master setup and viability for a specific environment in order to assist with load balancing and high availability. I do however have some questions and hope that someone out there have had enough experience to assist me with this

Another replication question

2010-11-24 Thread Machiel Richards
Hi All I am back once again with another replication question (maybe this can also be handled by MMM but not sure) this time for a different client. We are trying to find out how to setup 3 different masters to replicate to a single slave server (without the need to have 3 different

Table cache not being updated

2010-11-23 Thread Machiel Richards
Hi All Maybe someone can help me with this one. We have set the table_cache to 1024, however the open tables value stays 64 of 64. Everything I checked stated that the open tables is related to the table_cache variable. Can someone please assist on why the value

Changing database tables to different storage engine.

2010-11-22 Thread Machiel Richards
Good day all Hope all is well. I have something to ask as someone might have done this as well and may have a good solution on how to fix this. During a database migration this weekend to move a MySQL database from windows to linux, we created a backup and

Re: Changing database tables to different storage engine.

2010-11-22 Thread Machiel Richards
this not rather have just resulted in an error allowing to fix the problem in the first place instead of changing the storage engines? Anyone have some thoughts on the best solution to fix this? I will look into the innodb not working soon. Machiel -Original Message- From: Machiel Richards

Re: Changing database tables to different storage engine.

2010-11-22 Thread Machiel Richards
the tables will still be MyIsam. In this event I will need to manually alter each table, and I am concerned about the impact of this on the system performance. Regards Machiel -Original Message- From: John Daisley daisleyj...@googlemail.com To: Machiel Richards machiel.richa

MySQL replication server

2010-11-22 Thread Machiel Richards
Hi All sorry to bother everyone again. but now I have a question from a client which I am sure about my answer, however need to confirm. When setting up a master/slave replication set. As I understand it, the slave server can't accept any writes, however it will be able to

Upgrading of mysql database

2010-11-22 Thread Machiel Richards
Hi All Sorry for all my posts today but this one client is keeping me busy. the version of MySQL installed on the ubuntu server is 5.0.51a-3ubuntu5.8-log as this was the latest one available in the repository. We will need to upgrade this to version 5.1.53. Am

Re: MySQL replication server

2010-11-22 Thread Machiel Richards
. -Original Message- From: a.sm...@ukgrid.net To: John Daisley daisleyj...@googlemail.com Cc: Machiel Richards machi...@rdc.co.za, mysql mailing list mysql@lists.mysql.com Subject: Re: MySQL replication server Date: Mon, 22 Nov 2010 13:03:38 + Hi, I think you are wrong, slaves will always

Re: Upgrading of mysql database

2010-11-22 Thread Machiel Richards
How would I do an inplace upgrade? -Original Message- From: Johan De Meersman vegiv...@tuxera.be To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql@lists.mysql.com Subject: Re: Upgrading of mysql database Date: Mon, 22 Nov 2010 15:25:44 +0100 That would work, yes. You

Mysql installation - Innodb not enabled?

2010-11-18 Thread Machiel Richards
Good day all We have downloaded the following MySQL version which untarred to provide a list of RPM's: MySQL-server-advanced-gpl-5.1.50-1.rhel5.x86_64.tar The installations went through fine, however while doing some configurations I found that Innodb is not enabled / installed.

MySQL GA clustering

2010-11-18 Thread Machiel Richards
Good day all I would just like to confirm the following please. I have a client who is running the free downloadable version of MySQL and they would like to go the clustering route for quite a couple of reasons. Does anybody know whether clustering is

Oracle imports into MySQL

2010-11-10 Thread Machiel Richards
Good day all I am hoping that someone has got some more answers for me on the topic as most of the websites which have not been very useful. All websites I have found thus far reffers to software that either needs to be bought or otherwise need to be run manually. One of our

Re: MySQL clustering and licensing

2010-11-09 Thread Machiel Richards
times. Any ideas on this will help us out in making the final decisions. Ps there are only 2 machine available for the databases. Regards -Original Message- From: Joerg Bruehe joerg.bru...@oracle.com To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql

MySQL clustering and licensing

2010-11-08 Thread Machiel Richards
Good day all Maybe someone can assist me here as I am not sure where to get this information from and I need this for a proposed environment for a client. 1. The client will have 2 new machines, had a look at the specs and it is fairly good considering it will be dedicated to MySQL.

Replication on MySQL databases

2010-11-04 Thread Machiel Richards
Good day all I am hoping that someone can perhaps help me with some resources or info. I need to go to a meeting in the next hour and was requested this morning to research possible load balancing options for MySQL database. What is currently running is a website (balanced

Re: Replication on MySQL databases

2010-11-04 Thread Machiel Richards
: Johan De Meersman vegiv...@tuxera.be To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql@lists.mysql.com Subject: Re: Replication on MySQL databases Date: Thu, 4 Nov 2010 10:21:11 +0100 If your sites are busy with *writes*, you're kind of stuck. Replication means that every write

Failover on master/slave replication

2010-10-19 Thread Machiel Richards
Good day all I am hoping someone has had some experience in this to assist me. I have been going through lots of forums and documentation and can find a lot of information on how to setup a master/slave replication on MySQL. The question I have however is how do you fail

Replication / standby option on MySQL (GA)

2010-10-01 Thread Machiel Richards
Hi Guys Can someone please confirm whether replication / standby functionality is available on the GA release of MySQL or this an Enterprise specific functionality? Regards Machiel

MySQL replication and reverse replication?

2010-09-14 Thread Machiel Richards
Good day all I am hoping everyone is well. Can someone perhaps assist me with some resources on the following topic one of our clients are running a MySQL 5 master/slave replication setup. There is a DR test schedule during next month, however they want the slave

MySQL 5 certification books / trainign material

2010-09-07 Thread Machiel Richards
Good day everyone I think I have asked this question a while back but cant remember whether I have received an answer yet so I will ask again. I am busy studying for my MySQL certification exams, however the only book I have available to me is the MySQL 4 manual.

MySQL upgrades?

2010-09-03 Thread Machiel Richards
Good day all I am looking for someone that can maybe help me with some info regarding the upgrading of MySQL. We have a MySQL database currently running with a master/slave replication setup. The current version of the database is as follows: mysql select

finding exact query being run

2010-07-12 Thread Machiel Richards
, any ideas? I tried the slow query log but it is not showing up in there. All the queries are showing sleep Not sure if this means anything Machiel Richards MySQL DBA Relational Database Consulting RDC_Logo

RE: finding exact query being run

2010-07-12 Thread Machiel Richards
I had a look and all of these just say sleep as the command. Machiel Richards MySQL DBA Relational Database Consulting RDC_Logo From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: 12 July 2010 5:43 PM To: Machiel Richards Cc: mysql@lists.mysql.com Subject: Re: finding exact query

Mysql connections not released

2010-07-02 Thread Machiel Richards
to go from here to find the root cause. Generally everything works fine, however , every now and then things suddenly seem to be going wrong... L Any help would be appreciated. Machiel Richards MySQL DBA Relational Database Consulting RDC_Logo

RE: Mysql connections not released

2010-07-02 Thread Machiel Richards
is caused by a connection / transaction not completing. However what I need to find out now is why and how to resolve this. Machiel Richards MySQL DBA Relational Database Consulting RDC_Logo From: Rob Wultsch [mailto:wult...@gmail.com] Sent: 02 July 2010 9:42 AM To: Machiel

RE: Mysql connections not released

2010-07-02 Thread Machiel Richards
We do not use that setting at present no specifically because all hosts use ip's to connect and not dns / hostnames. We can't seem to find any errors thus the reason for truggling to pinpoint the exact cause. Machiel Richards MySQL DBA Relational Database Consulting RDC_Logo

RE: Mysql error causing database to not accept threads

2010-06-30 Thread Machiel Richards
of the amount of connections though. Machiel Richards MySQL DBA Relational Database Consulting -Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: 30 June 2010 10:53 AM To: mysql@lists.mysql.com Cc: Machiel Richards Subject: Re: Mysql error causing database

Determine connection origins

2010-06-30 Thread Machiel Richards
the connections originates from ? i.e - website, internal, import scripts, etc... Machiel Richards MySQL DBA Relational Database Consulting RDC_Logo

Reserving threads for root user

2010-06-30 Thread Machiel Richards
threads for the root user / database restarts? Current version running: 5.0.72sp1-enterprise-gpl-log Machiel Richards MySQL DBA Relational Database Consulting RDC_Logo

Mysql error causing database to not accept threads

2010-06-29 Thread Machiel Richards
Good morning all Hope everyone is well We received an error on a MySQL database this morning which caused it to be unavailable for connections. Error: ERROR 1135 (0): Can't create a new thread (errno 11); if

Questions regarding Query cache usage

2010-06-08 Thread Machiel Richards
Good morning all I would like to try and find out how you can see what is using the query cache. My reason for asking is the following: On one of our client databases, the query cache is set to 128Mb and the usage always varied between 5% and 53%

Strange errors / messages on slave server

2010-06-02 Thread Machiel Richards
Good day all I hope someone can assist me with this. While doing the normal routine daily health checks on one of our clients' servers I came across some strange behaviour from the slave server. (two servers setup in master / slave replication)

Re: Strange errors / messages on slave server

2010-06-02 Thread Machiel Richards
860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com Machiel Richards -Original Message- From: Machiel Richards [mailto:machi...@rdc.co.za] Sent: 02 June 2010 9:41 AM To: mysql@lists.mysql.com Subject: Strange errors / messages on slave server Good day all

Replication testing?

2010-06-01 Thread Machiel Richards
are available on both databases. I am not yet to this part of my studying as I am fairly new to MySQL and I am hoping someone can perhaps provide me with some info / resources on where to get this info from. Machiel Richards MySQL DBA Relational Database Consulting RDC_Logo

Innodb buffer pool size

2010-05-20 Thread Machiel Richards
Hi Guys I just have a quick question. I have done some research into how to determine the size of your Innodb buffer pool. All of the sources I used, specified that the Innodb buffer pool size should be the same size as your database + 10%. However, as far as I

Innodb buffer pool usage

2010-03-16 Thread Machiel Richards
Hi all Maybe someone can assist me with this one. A while back I requested some information relating to the MySQL innodb buffer pool size that seems to fill up rather frequently. The buffer pool is currently set to 3Gb , and it takes about

RE: slow queries not being logged

2010-02-23 Thread Machiel Richards
Hi All I found my problem and this was kind of a blonde moment for me... When configuring the log_slow_queries parameter, it was configured as follows: log_slow_queries=1 This the file being created is called 1 and the 1 does not mean it

  1   2   >