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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
#x27;;
SHOW VARIABLES LIKE '%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.
-O
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
.e. on the master the file and log position
are way ahead of the slaves by about 9 hours).
3. We have tested replication by creating a test table in the
database with some data and it was not replicated to the slaves.
Regards
Machiel
On 11/12/2012 03:11 PM, Manuel Arostegui wrote:
No errors are being logged, and there is enough disk space on
the server so it can't be space related.
Can anyone suggest some things we can check or do in order to
get replication sorted and to avoid future issues like this?
regards
Machiel
--
MySQL General Mailing Lis
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
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 (fre
*From: * Machiel Richards - Gmail ;
*To: * Ananda Kumar ;
*Cc: * ;
*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 selinux and disable it completely from installation.
I have
, forbidding you to create
files, check if " SELinux is disabled"
On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail
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 table wit
.
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
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
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
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
, 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
/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
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
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
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.
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
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
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
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
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
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
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
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
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
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
.
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
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
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
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
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
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
d was wondering if this is not
perhaps the issue.
Thank you in advance for all responses
Regards
Machiel
?
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
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
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
- 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
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
test connectivity from apps,etc...
Any suggestions?
Regards
Machiel
instances running on the slave machine).
Does anybody have any ideas?
Any ideas will be greatly appreciated.
Regards
Machiel
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
isn't being updated?
The MySQL version is 5.051a
regards
Machiel
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
.
-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
. startup new database.
7. disable the old database so that it would not start
up during reboot.
Regards
Machiel
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
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
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
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
.
I don't know clustering on MySQL at all so I will really
appreciate some help on this.
Regards
Machiel
-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
rt process?
Any assistance will be appreciated.
Regards
Machiel
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
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
: 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
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
ciate help on this one.
Regards
Machiel
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
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
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
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
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
, 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
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
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
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
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
the connections
originates from ? i.e - website, internal, import scripts, etc...
Machiel Richards
MySQL DBA
Relational Database Consulting
RDC_Logo
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
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
lp is appreciated.
Machiel
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
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
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
1 - 100 of 107 matches
Mail list logo