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

HI All Maybe you can assist. We are looking at upgrading a clients' MySQL 5.0 to version 5.1. They are running the following version: mysql Ver 14.12 Distrib 5.0.72sp1, for unknown-linux-gnu (x86_64) using readline 5.1

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

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 2-

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

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

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

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%

Mysql error causing database to not accept threads

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 you

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?

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 version()

MySQL 5 certification books / trainign material

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 replication and reverse replication?

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 serv

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

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 on MySQL databases

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 ove

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

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

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

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 client

Mysql installation - Innodb not enabled?

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

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 availabl

Changing database tables to different storage engine.

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 r

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

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 ac

Upgrading of mysql database

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 I

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

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 i

MMM setup and requirements

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 a

Another replication question

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 insta

Uprading of MySQL

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 upgr

MySQL upgrade from 5.0.51a to 5.1.53

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 source

Re: MySQL upgrade from 5.0.51a to 5.1.53

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_upgrade script to work. On Tue, Nov 30, 2010 at 11:23 AM, Machiel Richards

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

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 a

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?

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 machin

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

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

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

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

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

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

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

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 m

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

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

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

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

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.

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

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

Re: Temporary table creation fails

, 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

Re: Temporary table creation fails

*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

Mysql backup for large databases

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

  1   2   >