audit trails

Good day all I am hoping this mail finds all well... I am in need of some assistance please. We have a few tables that I need to add auditing information for. The idea is that we need to create an audit table that will track the following on the main table : - any chan

Re: audit trails

Thank you for the reply. well in essence the following is required. we need to know who made what changes to tables. we recently had a case of important data being deleted, however finding it i binary logs proved 2 things : 1. it takes very long to find as we did not know in whi

Re: audit trails

Hi Guys Thank you very much for all the input, I appreciate it. @ Johan Once again glad to deal with you. I do agree that triggers are not the way to go and I personally also do not like using it unless absolutely required. I do feel other solutions may be better, however , un

mysql odbc connection problem

Hi All We are experiencing some problems when trying to connect to a mysql database using ODBC. The settings have been configured and it seems to be getting to the DB but we getting the following error: [S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'hostname' (using pas

Enabling Slow query log in Mysql 5.0

Hi All I hope that someone can assist me with this. We have a client with a production MySQL database running MySQL 5.0. Their slow query counts have skyrocketed over the last week and I found that their slow query logs are

Uprading from mysql 5.0 to mysql 5.1

also sp1 then apply that.) Help will be appreciated. Regards Machiel

slow queries not being logged

Good day all I hope you can assist me with this one... We have a client where the slow query log was disabled. We noticed that the slow query amount (when viewing global status) has skyrocketed during the last 2 weeks going up to over 2 mi

RE: slow queries not being logged

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

Innodb buffer pool usage

abase administration so no luck in answering them on this so I would appreciate the assistance. Regards Machiel

Innodb buffer pool size

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 u

Replication testing?

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

Strange errors / messages on slave server

eally hope that someone can assist with this one as I am still a fairly new dba and this is completely new to me... Appreciate all replies. Regards Machiel

Re: Strange errors / messages on slave server

ric sense), then the length of > the queue will grow to infinity. > > In less technical terms, if the master goes faster than the slave, the > slave > will puke. > > Regards, > > Jerry Schwartz > Global Information Incorporated > 195 Farmington Ave. > F

Questions regarding Query cache usage

lp is appreciated. Machiel

Mysql error causing database to not accept threads

ested changing the thread_cache_size to 512 , currently this is on 256. Hoping that someone can assist with this and much appreciated. Regards Machiel

RE: Mysql error causing database to not accept threads

f 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 t

Determine connection origins

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

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 connections not released

where else 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

problem 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 T

RE: Mysql connections not released

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

finding exact query being run

, 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

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 upgrades?

ill be the best to upgrade to. 2. where can I get information on how to upgrade the database itself 3. has anyone done this before? if so, is there anything that we should look out for? I would really appreciate the help here. Regards Machiel

MySQL 5 certification books / trainign material

even seem to get hold of someone at oracle to provide me with possible assistance as they all just say they don't know. Regards Machiel

MySQL replication and reverse replication?

the slave server in cases where the master server should fail. I am however not that experienced on MySQL as yet and cant seem to find specific references on how to do this change over? any ideas or resources will be appreciated. Regards Machiel

Replication / standby option on MySQL (GA)

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

Failover on master/slave replication

ciate help on this one. Regards Machiel

Replication on MySQL databases

situations. Any help would be appreciated as google has not yet turned up any sufficient info for me in this short time I had been given. Regards Machiel

Re: Replication on MySQL databases

: Johan De Meersman To: Machiel Richards Cc: mysql mailing list 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 that happens on one side, also MUST happen on the other

MySQL clustering and licensing

aditional licences for clustering or not. I would really appreciate any suggestions here, I am busy trying to get the info from the net as well but I am pressured for responses. Regards Machiel

Re: MySQL clustering and licensing

ponse 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 To: Machiel Richards Cc: mysql mailing list Subject: Re: MySQL clustering and lice

Oracle imports into MySQL

rt process? Any assistance will be appreciated. Regards Machiel

Mysql installation - Innodb not enabled?

-devel-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm MySQL-shared-compat-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm MySQL-embedded-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm MySQL-test-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm Regards Machiel

MySQL GA & clustering

. I don't know clustering on MySQL at all so I will really appreciate some help on this. Regards Machiel

Changing database tables to different storage engine.

mance degration as possible. What is the best way to do this in order to have the least amount of effect on the database and it's performance? Regards Machiel

Re: Changing database tables to different storage engine.

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.

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 To: Machiel Richards Cc: mysql mailing list Subject: Re: Changing

MySQL replication server

le to accept reads. Is this correct, or will the slave server still be able to accept writes as well (even though it may not be replicated) ? Kind Regards Machiel

Upgrading of mysql database

. startup new database. 7. disable the old database so that it would not start up during reboot. Regards Machiel

Re: MySQL replication server

. -Original Message- From: a.sm...@ukgrid.net To: John Daisley Cc: Machiel Richards , mysql mailing list Subject: Re: MySQL replication server Date: Mon, 22 Nov 2010 13:03:38 + Hi, I think you are wrong, slaves will always accept writes unless you set readonly in the mysql config. Due

Re: Upgrading of mysql database

How would I do an inplace upgrade? -Original Message- From: Johan De Meersman To: Machiel Richards Cc: mysql mailing list Subject: Re: Upgrading of mysql database Date: Mon, 22 Nov 2010 15:25:44 +0100 That would work, yes. You could also try to upgrade in place - the upgrade scripts

Table cache not being updated

isn't being updated? The MySQL version is 5.051a regards Machiel

MMM setup and requirements

during a system failure it is rather quick and easy enough to get the slave running as the master. I do not have as much experience on this yet so I would really appreciate assistance. Regards Machiel

Another replication question

instances running on the slave machine). Does anybody have any ideas? Any ideas will be greatly appreciated. Regards Machiel

Uprading of MySQL

test connectivity from apps,etc... Any suggestions? Regards Machiel

MySQL upgrade from 5.0.51a to 5.1.53

g' ERROR 1305 (42000) at line 522: FUNCTION mysql.CONCAT does not exist ERROR 1305 (42000) at line 537: FUNCTION mysql.CONCAT does not exist ERROR 1305 (42000) at line 552: FUNCTION mysql.CONCAT does not exist FATAL ERROR: Upgrade failed r...@machielr-laptop:/usr/local/mysql/bin# Regards Machiel

Re: MySQL upgrade from 5.0.51a to 5.1.53

- setup new mysql version using the tar file - start the new server and restore the backup. - run mysql_upgrade in order to ensure all tables are well as well as privilege tables. Does this seem right to you guys? Machiel -Original Message- From: Johan De Meersman

RESOLVED - Re: MySQL upgrade from 5.0.51a to 5.1.53

earlier. Regards Machiel -Original Message- From: Johan De Meersman To: Machiel Richards Cc: mysql mailing list 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 restore failing

16 columns and exactly the same as far as I can see. Is there anyone that might know why I am getting this? I would really apprecaite any help as this machine needs to be up and running by eod today. Regards Machiel

Re: MySQL restore failing

? The current proc tables have 16 columns. Any ideas? Regards Machiel -Original Message- From: partha sarathy To: Machiel Richards , mysql mailing list Subject: Re: MySQL restore failing Date: Fri, 3 Dec 2010 14:02:59 +0530 (IST) In mysql 5.1, mysql.proc table contains 20

Bind-address use?

d was wondering if this is not perhaps the issue. Thank you in advance for all responses Regards Machiel

Re: Bind-address use?

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 To: Machiel Richards Cc: mysql mailing list Subject: Re: Bind-address use? Date: Tue

Moving of databases from one server to another

oduction system and I am a bit concerned to the fact that the startup script does not work properly. Is there anyone who has had this issue before and have been able to resolve it? Thank you in advance for any help on this matter. Regards Machiel

Re: Moving of databases from one server to another

Hi Johan Would the server require a restart after this or not? Machiel -Original Message- From: Johan De Meersman To: Machiel Richards Cc: mysql mailing list Subject: Re: Moving of databases from one server to another Date: Wed, 8 Dec 2010 11:02:55 +0100 That's a very D

Re: Moving of databases from one server to another

HI Johan Thank you for the advice... Problem resolved. Regards Machiel -Original Message- From: Johan De Meersman To: Machiel Richards Cc: mysql mailing list Subject: Re: Moving of databases from one server to another Date: Wed, 8 Dec 2010 11:15:52 +0100 On Wed, Dec 8, 2010 at

Resource required

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

. Regards Machiel -Original Message- From: Johan De Meersman To: Machiel Richards Cc: mysql mailing list Subject: Re: Resource required Date: Thu, 9 Dec 2010 14:00:18 +0100 On Thu, Dec 9, 2010 at 1:46 PM, Machiel Richards wrote: Does anybody know if there is a mysql mailing

Database procedures

urce which explains exactly how I would be able to create this procedure or can otherwise assist or guide me? I would really appreciate the help as I would love to learn how to write procedures. Regards Machiel

Re: Database procedures

rn the value 3823054 and not null. Regards Machiel -Original Message- From: Machiel Richards To: mysql mailing list 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

Stored procedure

x_id int(11); select max(id) into max_id from table1 where utc < dt; delete from table2 where id < max_id; delete from table1 where id < max_id; end Does anybody perhaps have any suggestions? Regards Machiel

Re: Stored procedure

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 To: Machiel Richards , mysql@lists.mysql.com Subject: Re: Stored procedure Date: Wed, 05 Jan 2011 12:15:59 +0100 Hi, Use

Re: Stored procedure

dy 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 To: Machiel Richards Cc: mysql@lists.mysql.com Subject: Re: Stored procedure Date: Wed, 05 Jan 2011 12:44:07 +0100 http://dev.mysql.com/doc/refman

Mysql Event scheduler

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

Multi slave-single master

migration to new hardware this weekend and my plan is to setup the new master server as a slave to current production master in order to get all data in sync and during switchover to simply shutdown current production and change over to the new servers using relevant configuration. Regards Machiel

Replicating to mysql5.1 from 5.0 master?

he go-live. Any 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, So

MySQL 5.1 change master syntax issues?

ble to connect 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

Mysql clustering

roper 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

Deleting of records older than a specific date & time

would really appreciate it if someone can assist me in this regard please. Regards Machiel PS someone already suggested me using MySQL scheduled events , however I was not able to figure out how to use it for this functionality though.

Re: Mysql backup for large databases

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 ser

Mysql 5.1 union with group by for results

r. Any help would by appreciated. Regards Machiel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Mysql 5.1 union with group by for results

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" ERROR 1064 (42000): You have an err

Re: Mysql 5.1 union with group by for results

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

Mysql into outfile problem

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 exp

Re: Mysql into outfile problem

Best, / 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

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" Subject: Mysql into outfile problem - when we run an explain on the query it shows that it is using index

MySql Swapping issues

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 p

Re: MySql Swapping issues

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" wrote: - Original Message - > From: "Machiel Ri

mysql Archiving engine

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

Optimize table partitions

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 a

tcmalloc mysql 5.7.14

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 a

Re: tcmalloc mysql 5.7.14

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

Re: tcmalloc mysql 5.7.14

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

Network throughput for mysql replication

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 resulted

Optimize fails due to duplicate rows error but no duplicates found

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 t

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

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... > > > We are trying to run optimize again

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

: 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... > > > We are trying t

info on open tables

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

High cpu usage

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 w

Re: High cpu usage

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 here as

Assistance with trigger

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 b

Re: Assistance with trigger

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

Fwd: Question relating to transactions on innodb tables.

of transactions for this , in order to allow us to roll back on changes if the after checks does not correspond. What I am trying to find out is whether a transaction will cause the locks to be handled as table locks or will it be row level locks? Regards Machiel

Temporary table creation fails

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 serve

Re: Temporary table creation fails

/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 mailto:machiel.richa...@gmail.com>> wrote: Hi All I am hoping someone can point me in the

Re: Temporary table creation fails

, Machiel Richards - Gmail 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 stateme

Re: Temporary table creation fails

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 mailto:machiel.richa...@gmail.com>> wrote: Hi, the sort_buffer_size w

Re: Temporary table creation fails

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 mailto:machiel.richa...@gmail.com>> wrote: Hi, still no luck, same error being given immediately after pr

Re: Temporary table creation fails

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 1

Re: Temporary table creation fails

. 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 mailto:machiel.richa...@gmail.com>> wrote: Hi, We confirmed that the /tmp directory permissions

  1   2   >