El 30/7/20 a las 4:51, sthustfo escribió:
> Hi all,
>
> I am looking for a i686 package (32 bit) for mysql-connector-odbc. However,
> I could locate only the x86-64 version on the repositories. Not much of a
> DB person but trying to connect to a 64bit MySQL server on remote host.
>
> Any
If you can find the RPMS, you could rebuild for I686.
-Original Message-
From: CentOS On Behalf Of sthustfo
Sent: Wednesday, July 29, 2020 9:52 PM
To: CentOS mailing list
Subject: {EXTERNAL} [CentOS] mysql-connector-odbc i686 package
CAUTION: This email originated outside of BSWH
Hi all,
I am looking for a i686 package (32 bit) for mysql-connector-odbc. However,
I could locate only the x86-64 version on the repositories. Not much of a
DB person but trying to connect to a 64bit MySQL server on remote host.
Any suggestions where I can locate the i686 package? Is there a
On 06/03/2017 08:52 AM, Johnny Hughes wrote:
On 06/03/2017 08:19 AM, Leon Vergottini wrote:
Dear Community
I am trying to install MySQL 5.6 on a Raspberry PI 3B. Using my normal
procedure by downloading the yum repo rpm and installing MySQL through that is
not working. There is no
On 06/03/2017 08:19 AM, Leon Vergottini wrote:
> Dear Community
>
>
>
> I am trying to install MySQL 5.6 on a Raspberry PI 3B. Using my normal
> procedure by downloading the yum repo rpm and installing MySQL through that
> is not working. There is no rpm information for arm7.
>
>
>
>
Dear Community
I am trying to install MySQL 5.6 on a Raspberry PI 3B. Using my normal
procedure by downloading the yum repo rpm and installing MySQL through that is
not working. There is no rpm information for arm7.
Can anyone please point me in a direction where I can find a
The problem and solution is posted here for posterity.
On a production CentOS 5.11 system, I recently had a cron job
that started failing. One of the thing that the cron job does
is connect to a MySQL server via TCP using SSL.
Debugging things got me to the point where invoking the mysql
Hi,
as that example is for maria db, teh oracle mysql rpm dose not ship with
something like
/etc/systemd/system/mysqld.service.d
Can I just create /etc/systemd/system/mysqld.service.d/limits.conf and
than I'm ready to go?
Thanks for your patience and regards . Götz
Am 29.04.15 um
+1 Thanks! That was a little bit confusing at first.
Regards . Götz
Am 30.04.15 um 04:21 schrieb carlh04...@gmail.com:
Thank you for clarifying this, Johan. Very much appreciated!
On Wed, 29 Apr 2015 22:28:00 +0200
Johan Kooijman wrote:
Carl,
By default my.cnf has to obey the
we can set ulimt to limit the number of open files
On Thu, Apr 30, 2015 at 3:22 PM, Götz Reinicke - IT Koordinator
goetz.reini...@filmakademie.de wrote:
+1 Thanks! That was a little bit confusing at first.
Regards . Götz
Am 30.04.15 um 04:21 schrieb carlh04...@gmail.com:
Thank
On 29/04/2015 09:31 AM, Götz Reinicke - IT Koordinator wrote:
Hi,
may be somewon has a working solution and information on that:
I installed the most recent mysql community on a server and do get a
lot
of errno: 24 - Too many open files.
There are suggestions to increase the
Hi,
may be somewon has a working solution and information on that:
I installed the most recent mysql community on a server and do get a lot
of errno: 24 - Too many open files.
There are suggestions to increase the open_files_limit, change/add that
to /etc/security/limits.conf and modify the
Gotz,
This is due to systemd, it overrules your settings. Add a file to systemd
config fixes it:
[root@mysql2 ~]# cat /etc/systemd/system/mariadb.service.d/limits.conf
[Service]
LimitNOFILE=1
LimitMEMLOCK=1
On Wed, Apr 29, 2015 at 8:31 AM, Götz Reinicke - IT Koordinator
Carl,
By default my.cnf has to obey the OS limits, so in this case the order is:
systemd /etc/security/limits* /etc/my*.
On Wed, Apr 29, 2015 at 3:22 PM, Carl E. Hartung carlh04...@gmail.com
wrote:
Hi Johan,
Does systemd also overrule /etc/my.conf?
Thx!
Carl
On Wed, 29 Apr 2015
Hi Johan,
Does systemd also overrule /etc/my.conf?
Thx!
Carl
On Wed, 29 Apr 2015 14:58:52 +0200
Johan Kooijman wrote:
Gotz,
This is due to systemd, it overrules your settings. Add a file to
systemd config fixes it:
[root@mysql2 ~]# cat /etc/systemd/system/mariadb.service.d/limits.conf
Thank you for clarifying this, Johan. Very much appreciated!
On Wed, 29 Apr 2015 22:28:00 +0200
Johan Kooijman wrote:
Carl,
By default my.cnf has to obey the OS limits, so in this case the
order is: systemd /etc/security/limits* /etc/my*.
On Wed, Apr 29, 2015 at 3:22 PM, Carl E.
On Mon, Mar 30, 2015 at 3:16 AM, Fernando Cassia fcas...@gmail.com wrote:
You should keep in mind the security-related changes coming in MySQL 5..7,
if you ever choose to upgrade.
Sorry, I erased this link by mistake while composing my reply. Here it goes.
On Mon, Mar 30, 2015 at 12:27 AM, Tim Dunphy bluethu...@gmail.com wrote:
I've been having some trouble creating a mysql user that can connect to
the database from localhost. It's always been a straight forward thing to
do in the past, so its time for a sanity check, if you guys don't mind.
On 30/03/15 05:22, Tim Dunphy wrote:
mysql FLUSH PRIVILEGES;
Yup! That was it. Thanks for the reminder! :)
Tim
From the mySQL man pages:
If you modify the grant tables indirectly using account-management statements
such as GRANThttps://dev.mysql.com/doc/refman/5.5/en/grant.html,
Hey all,
I've been having some trouble creating a mysql user that can connect to
the database from localhost. It's always been a straight forward thing to
do in the past, so its time for a sanity check, if you guys don't mind.
Ok, so here's the actual command with actual simplified password
[root@ops:~] #mysql --user=proftpd --password=testpattern -h localhost
On Sun, Mar 29, 2015 at 10:27 PM, Tim Dunphy bluethu...@gmail.com wrote:
Hey all,
I've been having some trouble creating a mysql user that can connect to
the database from localhost. It's always been a straight forward
mysql FLUSH PRIVILEGES;
Yup! That was it. Thanks for the reminder! :)
Tim
On Mon, Mar 30, 2015 at 12:15 AM, Steven Tardy sjt5a...@gmail.com wrote:
mysql grant all privileges on ftp.* to 'proftpd'@'localhost'
identified by
'testpattern';
Query OK, 0 rows affected (0.35 sec)
mysql
mysql grant all privileges on ftp.* to 'proftpd'@'localhost' identified by
'testpattern';
Query OK, 0 rows affected (0.35 sec)
mysql FLUSH PRIVILEGES;
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
On Thu, March 12, 2015 11:49, Tim Dunphy wrote:
Ok, yeah I can understand that. I'll correct it. Still need a way to
get SSL enabled however. Any suggestions there?
The method we use is to create an application specific directory under
/etc/pki and place its certificates and keys in there.
On Thu, Mar 12, 2015 at 8:57 AM Tim Dunphy bluethu...@gmail.com wrote:
Hey everybody,
I'm trying to get mysql master/slave replication to work under SSL. I've
created the certs for both the slave and the master. I've configured the
master and slave my.cnf. And it does appear that
Hey everybody,
I'm trying to get mysql master/slave replication to work under SSL. I've
created the certs for both the slave and the master. I've configured the
master and slave my.cnf. And it does appear that replication is actually
working.
Master is actually MariaDB (version
No: /etc/pki/CA should NOT be group writeable. Ditto for
/etc/pki/tls/cernts and private
Ok, yeah I can understand that. I'll correct it. Still need a way to get
SSL enabled however. Any suggestions there?
Thanks
Tim
On Thu, Mar 12, 2015 at 11:40 AM, m.r...@5-cent.us wrote:
Tim Dunphy
The mysqld process runs as the mysql user. It's parent which is the
mysqld_safe runs as the root user. That being said the mysql user needs
to have at least read permission to the locations where the ssl files are
located. By default on Centos the /etc/pki/CA/private directory has its
Tim Dunphy wrote:
The mysqld process runs as the mysql user. It's parent which is the
mysqld_safe runs as the root user. That being said the mysql user
needs to have at least read permission to the locations where the ssl
files
are located. By default on Centos the /etc/pki/CA/private
On Thu, March 12, 2015 10:40 am, m.r...@5-cent.us wrote:
Tim Dunphy wrote:
The mysqld process runs as the mysql user. It's parent which is the
mysqld_safe runs as the root user. That being said the mysql user
needs to have at least read permission to the locations where the ssl
files
On Thu, Mar 12, 2015 at 10:49 AM Tim Dunphy bluethu...@gmail.com wrote:
No: /etc/pki/CA should NOT be group writeable. Ditto for
/etc/pki/tls/cernts and private
Ok, yeah I can understand that. I'll correct it. Still need a way to get
SSL enabled however. Any suggestions there?
I
Hey Alberto,
Perfect! Thanks for your response. Moving the certs and keys to an
alternate location worked exactly right.
Master:
MariaDB [(none)] show variables like '%ssl%';
+---+--+
| Variable_name | Value|
On Thu, Mar 12, 2015 at 10:49 AM Tim Dunphy bluethu...@gmail.com wrote:
No: /etc/pki/CA should NOT be group writeable. Ditto for
/etc/pki/tls/cernts and private
I agree - Sorry I did not mean to imply that the directory permissions on
/etc/pki/CA should be modified. However it was
Hello,
We have MySQL running as a master which is replicating to a single slave
server. We are, however, considering what is required when a 'disaster'
of some sort happens to either server. By disaster, this could be some
event which requires the entire server to be rebuilt, and which would
-Original Message-
From: John Horne [mailto:john.ho...@plymouth.ac.uk]
Sent: Wednesday, August 13, 2014 7:53 AM
To: CentOS list
Subject: [CentOS] MySQL - replication - how to restore master?
Hello,
SNIP
However, I am having trouble finding out what to do should we lose
It's quite simple really.
Just make your master a slave of your slave.
It's called Multi Master.
see http://mysql-mmm.org/
On Wed, Aug 13, 2014 at 9:53 PM, John Horne john.ho...@plymouth.ac.uk
wrote:
Hello,
We have MySQL running as a master which is replicating to a single slave
server.
Hi.
I have a strange problem.
I installed cacti, and set it up.
When I click on the Plugins Management, I noticed Error
FATAL: Database or Table does not exist
Further testing revealed that at the moment MySQL can not create
temporary files in /tmp. It is same for ANY database!
SELinux is
Hi,
Have you verified that permissions on /tmp appear correct ?
An example from one of my systems
# ls -lsahd /tmp
4.0K drwxrwxrwt. 3 root root 4.0K Feb 14 07:01 /tm
So permissions 1777
Perhaps test creating a file in /tmp as root and as a non root user and let
us know the results that way
On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic cen...@plnet.rs wrote:
I have a strange problem.
I installed cacti, and set it up.
When I click on the Plugins Management, I noticed Error
FATAL: Database or Table does not exist
Further testing revealed that at the moment MySQL can not
On 02/13/2014 08:17 PM, Clint Dilks wrote:
Hi,
Have you verified that permissions on /tmp appear correct ?
An example from one of my systems
# ls -lsahd /tmp
4.0K drwxrwxrwt. 3 root root 4.0K Feb 14 07:01 /tm
So permissions 1777
Already checked.
[root@chiron ~]# ls -lsahd /tmp
4.0K
On 02/13/2014 08:49 PM, Les Mikesell wrote:
On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic cen...@plnet.rs wrote:
I have a strange problem.
I installed cacti, and set it up.
When I click on the Plugins Management, I noticed Error
FATAL: Database or Table does not exist
Further
On 02/13/2014 09:18 PM, Ljubomir Ljubojevic wrote:
On 02/13/2014 08:49 PM, Les Mikesell wrote:
On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic cen...@plnet.rs wrote:
I have a strange problem.
I installed cacti, and set it up.
When I click on the Plugins Management, I noticed Error
On 02/13/2014 09:21 PM, Ljubomir Ljubojevic wrote:
On 02/13/2014 09:18 PM, Ljubomir Ljubojevic wrote:
On 02/13/2014 08:49 PM, Les Mikesell wrote:
On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic cen...@plnet.rs
wrote:
I have a strange problem.
I installed cacti, and set it up.
When
On Fri, 20 Dec 2013, Luigi Rosa wrote:
I can confirm that this is a bug added to the latest releases og MySQL.
I tested it only in VM (both VMware and XEN).
How to reproduce.
* start a CentOS VM with MySQL
* abruptly turn the VM off (not shutdown, of course)
* restart VM
* MySQL starts but
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul Heinlein said the following on 20/12/2013 16:50:
On Fri, 20 Dec 2013, Luigi Rosa wrote:
I can confirm that this is a bug added to the latest releases og MySQL.
I tested it only in VM (both VMware and XEN).
How to reproduce.
* start a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I can confirm that this is a bug added to the latest releases og MySQL.
I tested it only in VM (both VMware and XEN).
How to reproduce.
* start a CentOS VM with MySQL
* abruptly turn the VM off (not shutdown, of course)
* restart VM
* MySQL starts
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a server with a faulty power supply that resets the server every 4/5
hours.
While I wait for the supplier to change the PS, I am facing an issue with MySQL.
When the system comes back on, mysqld script starts the daemon, but the
connections
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a server with a faulty power supply that resets the server every 4/5
hours.
While I wait for the supplier to change the PS, I am facing an issue with MySQL.
When the system comes back on, mysqld script starts the daemon, but the
connections
On Mon, 16 Dec 2013 10:51:54 +0100
Luigi Rosa li...@luigirosa.com wrote:
I have a server with a faulty power supply that resets the server
every 4/5 hours.
While I wait for the supplier to change the PS, I am facing an issue
with MySQL.
When the system comes back on, mysqld script
Last week I had a hard disk failure on my CentOS server.
I managed to re-install CentOS on a new disk.
I have the old mysql databases from /var/lib/mysql .
Can I just move them to my new disk?
Any help or suggestions gratefully received.
--
Timothy Murphy
e-mail: gayleard /at/ eircom.net
MySQL is usually confined in /var/lib/mysql, so if you move the /etc/my.cnf
and the /var/lib/mysql from the old server to the new one, you should be
able to start the server normally, otherwise you should get some useful
errors.
A typical error in such case is MySQL files ownership/permissions.
Marios Zindilis wrote:
On Fri, Nov 15, 2013 at 2:18 PM, Timothy Murphy gayle...@eircom.net
wrote:
Last week I had a hard disk failure on my CentOS server.
I managed to re-install CentOS on a new disk.
I have the old mysql databases from /var/lib/mysql .
Can I just move them to my new disk?
On Fri, Nov 15, 2013 at 6:18 AM, Timothy Murphy gayle...@eircom.net wrote:
Last week I had a hard disk failure on my CentOS server.
I managed to re-install CentOS on a new disk.
I have the old mysql databases from /var/lib/mysql .
Can I just move them to my new disk?
Any help or suggestions
Am 15.11.2013 um 16:55 schrieb Les Mikesell lesmikes...@gmail.com:
On Fri, Nov 15, 2013 at 6:18 AM, Timothy Murphy gayle...@eircom.net wrote:
Last week I had a hard disk failure on my CentOS server.
I managed to re-install CentOS on a new disk.
I have the old mysql databases from
On Fri, Nov 15, 2013 at 10:01 AM, Reindl Harald h.rei...@thelounge.net wrote:
abd what has the CPU type to do with the mysql datadir?
Really??? You've never used processors with different bit/byte order
than Intel's? I don't know specifically about Mysql but pretty much
anything that stores
On Fri, Nov 15, 2013 at 10:58 AM, Reindl Harald h.rei...@thelounge.net wrote:
I don't know specifically about Mysql but pretty much anything that stores
binary
representations to disk needs to be converted.
with this logic you would need to convert MS office files
containing embedded
On Fri, Nov 15, 2013 at 12:00 PM, Reindl Harald h.rei...@thelounge.net wrote:
and why did you strip the part where i googled for you the endianess
of MacOSX on PPC because i clearly statet mysql-data dirs used here
in production went from MySQL 3.x on Windows i686 over MySQL 4.0-4.5
on Apple
On Fri, Nov 15, 2013 at 12:16 PM, Reindl Harald h.rei...@thelounge.net wrote:
in other words you do not know anything about the mysql-internals
as you statet more than once, have no expierience and come up with
generic theory to defend your statements
Yes, if you do things that work in
On Fri, Nov 15, 2013 at 12:32 PM, Reindl Harald h.rei...@thelounge.net wrote:
Yes, if you do things that work in general, you don't have to know all
of the internals of every specific version of every specific program
that you might ever touch.
than better be quiet instead contradict and
On 11/15/2013 10:19 AM, Les Mikesell wrote:
On Fri, Nov 15, 2013 at 12:16 PM, Reindl Haraldh.rei...@thelounge.net
wrote:
in other words you do not know anything
Reindl is banned from this list for serial rudeness, but replies
privately to list postings with his 'wisdom'. please don't
ges and will leave
mysql-5.0-5.el5_9 in place for now. FYI, I searched through the rest of
the installed packages, the only one that has the client library is
mysql-5.0.95-5.el5_9.
php-mysql is linked against mysql-5.0-libs and talking to
a mysql-5.5 server. Should this cause an
Am 29.10.2013 um 22:56 schrieb Reindl Harald h.rei...@thelounge.net:
php-mysql is linked against mysql-5.0-libs and talking to
a mysql-5.5 server. Should this cause an unpredictable behavior?
no - how do you come to this idea?
In the last decade i saw very strange results while updating
or
On Wed, 2013-10-30 at 11:22 +0100, Leon Fauster wrote:
Am 29.10.2013 um 22:56 schrieb Reindl Harald h.rei...@thelounge.net:
php-mysql is linked against mysql-5.0-libs and talking to
a mysql-5.5 server. Should this cause an unpredictable behavior?
no - how do you come to this idea?
Am 30.10.2013 um 17:31 schrieb Matthew B. Brookover mbroo...@mines.edu:
On Wed, 2013-10-30 at 11:22 +0100, Leon Fauster wrote:
Am 29.10.2013 um 22:56 schrieb Reindl Harald h.rei...@thelounge.net:
no - how do you come to this idea?
In the last decade i saw very strange results while
On 10/30/2013 05:22 AM, Leon Fauster wrote:
Am 29.10.2013 um 22:56 schrieb Reindl Harald h.rei...@thelounge.net:
php-mysql is linked against mysql-5.0-libs and talking to
a mysql-5.5 server. Should this cause an unpredictable behavior?
no - how do you come to this idea?
In the last decade i
Am 28.10.2013 um 22:30 schrieb Matthew B. Brookover mbroo...@mines.edu:
On Mon, 2013-10-28 at 22:18 +0200, Eero Volotinen wrote:
2013/10/28 Matthew B. Brookover mbroo...@mines.edu
I upgraded a web server from CentOS 5.9 to 5.10. The instructions also
indicate that MySQL 5.0 is no longer
I upgraded a web server from CentOS 5.9 to 5.10. The instructions also
indicate that MySQL 5.0 is no longer supported so I followed the
instructions to upgrade to 5.5. Everything seems to be working so I
tried to remove MySQL 5.0 and MySQL 5.1. It seems there are still
dependencies on MySQL
2013/10/28 Matthew B. Brookover mbroo...@mines.edu
I upgraded a web server from CentOS 5.9 to 5.10. The instructions also
indicate that MySQL 5.0 is no longer supported so I followed the
instructions to upgrade to 5.5. Everything seems to be working so I
tried to remove MySQL 5.0 and MySQL
On Mon, 2013-10-28 at 22:18 +0200, Eero Volotinen wrote:
2013/10/28 Matthew B. Brookover mbroo...@mines.edu
I upgraded a web server from CentOS 5.9 to 5.10. The instructions also
indicate that MySQL 5.0 is no longer supported so I followed the
instructions to upgrade to 5.5. Everything
Hello,
I've only had experience with PostgreSQL sofar,
but have now to install MySQL (and WordPress)
on a CentOS 6.4 /64 bit server.
I have installed the mysql-5.1.69-1.el6_4.x86_64
package and executed the following commands:
# chkconfig mysqld on
# service mysqld start
# /usr/bin/mysqladmin
Docs says it's Windows specific:
http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_enable-named-pipe
On Fri, Sep 13, 2013 at 1:44 PM, Alexander Farber
alexander.far...@gmail.com wrote:
Hello,
I've only had experience with PostgreSQL sofar,
but have now to install
Thank you, that was it.
I didn't realize mysqld-nt means Windows only
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_skip-networking
On Sep 13, 2013, at 6:44 AM, Alexander Farber alexander.far...@gmail.com
wrote:
Hello,
I've only had experience with PostgreSQL sofar,
but have now to install MySQL (and WordPress)
on a CentOS 6.4 /64
On 06/06/2012 12:45 AM, Dennis Jacobfeuerborn wrote:
Hi,
it seems even a minimal install of Centos 6.2 now requires mysql-libs as a
dependency for postfix and cronie. When I try to install the mysql cluster
rpms from mysql.com I get a collision between the files.
Since this is the first time
Hello List,
I see that installing mysql in Centos 6.x creates a mysql user
with a login shell of /bin/bash. Is a default password also installed?
I certainly hope not, but it makes me nervous.
--
Stephen Clark
*NetWolves*
Director of Technology
Phone: 813-579-3200
Fax: 813-882-0209
Email:
Hello Steve,
On Tue, 2012-06-05 at 10:57 -0400, Steve Clark wrote:
I see that installing mysql in Centos 6.x creates a mysql user
with a login shell of /bin/bash. Is a default password also installed?
I certainly hope not, but it makes me nervous.
See for yourself:
# grep mysql
On 06/05/2012 11:13 AM, Leonard den Ottolander wrote:
See for yourself:
# grep mysql /etc/shadow
mysql:!!:15404::
Ah - good, from man 5 shadow...
encrypted password
Refer to crypt(3) for details on how this string is interpreted.
If the password field
Hi,
it seems even a minimal install of Centos 6.2 now requires mysql-libs as a
dependency for postfix and cronie. When I try to install the mysql cluster
rpms from mysql.com I get a collision between the files.
Since this is the first time I get into contact with mysql cluster I wonder
if somebody
On Thu, May 17, 2012 at 5:44 AM, Bob Hoffman b...@bobhoffman.com wrote:
is it possible to make each one of those instances a replicate/slave of
a different master
(thus a backup mysql server in a way?)
I just recently finished playing with this. I ended up brining up a
dedicated VM for this
On 5/17/2012 5:30 AM, Leon Jacobs wrote:
On Thu, May 17, 2012 at 5:44 AM, Bob Hoffmanb...@bobhoffman.com wrote:
is it possible to make each one of those instances a replicate/slave of
a different master
(thus a backup mysql server in a way?)
I just recently finished playing with this. I
If you adjust the my.cnf file to make separate instances of mysql.
How would you go through the mysql secure installation? Is is possible
or must it all be done manually
for each one?
is it possible to make each one of those instances a replicate/slave of
a different master
(thus a backup
Dear All Greetings,
i am seeking help from guys with mysql knowledge. i can see lot of these
files in mysql directory. And they are eventually filling up the space on
the server. what these files are? some exists with very old time stamps.
such as February 2012. can these be deleted?
This
On Thu, May 3, 2012 at 11:23 AM, Prabhpal S. Mavi
prabh...@digital-infotech.net wrote:
Dear All Greetings,
i am seeking help from guys with mysql knowledge. i can see lot of these
files in mysql directory. And they are eventually filling up the space on
the server. what these files are?
On 03/22/2012 11:18 AM, Andy Taylor wrote:
Hi,
I recently upgraded to the latest MySQL 5.0.95 package as part of the
CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for
performance testing. However, if I try to use any of the profiling
functionality I get this error:
Hi,
I recently upgraded to the latest MySQL 5.0.95 package as part of the
CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for
performance testing. However, if I try to use any of the profiling
functionality I get this error:
ERROR 1289 (HY000): The 'SHOW PROFILE' feature is
On 03/22/2012 11:18 AM, Andy Taylor wrote:
Hi,
I recently upgraded to the latest MySQL 5.0.95 package as part of the
CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for
performance testing. However, if I try to use any of the profiling
functionality I get this error:
On 03/22/2012 11:32 AM, Johnny Hughes wrote:
On 03/22/2012 11:18 AM, Andy Taylor wrote:
Hi,
I recently upgraded to the latest MySQL 5.0.95 package as part of the
CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for
performance testing. However, if I try to use any of the
On 03/22/2012 11:46 AM, Johnny Hughes wrote:
On 03/22/2012 11:32 AM, Johnny Hughes wrote:
On 03/22/2012 11:18 AM, Andy Taylor wrote:
Hi,
I recently upgraded to the latest MySQL 5.0.95 package as part of the
CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for
performance
On 03/22/2012 05:01 PM, Johnny Hughes wrote:
So, profiling was indeed in 5.0.77 and it is indeed not in 5.0.95
The default in configure for 5.0.77 was to have it turned on, whereas in
5.0.95 the default has been to turn it off :
+{ $as_echo $as_me:$LINENO: checking whether query profiling
Hello Johnny, Andy,
On Thu, 2012-03-22 at 12:01 -0500, Johnny Hughes wrote:
On 03/22/2012 11:46 AM, Johnny Hughes wrote:
OK ... I have verified that it is now turned off and that it was on in
5.0.77
from 5.0.95 build log:
..
checking whether query profiling should be included...
Hello listmates,
I got a rather strange situation that I can't quite make sense of. OK, I've
got a very large data file to sort (hundreds of millions of lines) and I
decided to use MySQL for the purpose. I inserted the stuff into a table
easily enough. Then I decided to sort it and got stuck as
On Mon, 2012-02-13 at 16:45 -0500, Boris Epstein wrote:
Hello listmates,
I got a rather strange situation that I can't quite make sense of. OK, I've
got a very large data file to sort (hundreds of millions of lines) and I
decided to use MySQL for the purpose. I inserted the stuff into a table
On Mon, Feb 13, 2012 at 4:58 PM, Adam Tauno Williams awill...@whitemice.org
wrote:
On Mon, 2012-02-13 at 16:45 -0500, Boris Epstein wrote:
Hello listmates,
I got a rather strange situation that I can't quite make sense of. OK,
I've
got a very large data file to sort (hundreds of millions
Easy. It is using temporary files the *correct* way.
1. Open file
2. Unlink file
3. Use file
4. Close file
This means (a) even if the process abends the resources allocated to the
file are released and (b) an external process can't see [or modify] the
temporary file.
When a file is
On Mon, 2012-02-13 at 17:06 -0500, Boris Epstein wrote:
On Mon, Feb 13, 2012 at 4:58 PM, Adam Tauno Williams awill...@whitemice.org
wrote:
On Mon, 2012-02-13 at 16:45 -0500, Boris Epstein wrote:
Hello listmates,
I got a rather strange situation that I can't quite make sense of. OK,
If the process is stopped the transaction cannot be resumed for a myriad
reasons; loss of the temporary file is a trivial concern.
--
System Network Administrator [ LPI NCLA ]
http://www.whitemiceconsulting.com
OpenGroupware Developer http://www.opengroupware.us
Adam Tauno Williams
On Mon, Feb 13, 2012 at 4:06 PM, Boris Epstein borepst...@gmail.com wrote:
I haven't thought of it this way. In fact it matches with this description:
http://dev.mysql.com/doc/refman/5.1/en/temporary-files.html
I can kind of see the advantages; the disadvantages, of course, are that a
On 02/13/2012 11:31 PM, Boris Epstein wrote:
In fact, I did look in /proc/{pid#}/fd and found the file names, thanks!
Coud quite figure out the size of those invisible files - but no matter,
hopefully I've got enough room.
ls -l /proc/{pid#}/fd
--
Ljubomir Ljubojevic
(Love is in the Air)
On Mon, Feb 13, 2012 at 6:53 PM, Ljubomir Ljubojevic off...@plnet.rswrote:
On 02/13/2012 11:31 PM, Boris Epstein wrote:
In fact, I did look in /proc/{pid#}/fd and found the file names, thanks!
Coud quite figure out the size of those invisible files - but no matter,
hopefully I've got
On Mon, 2012-02-13 at 18:59 -0500, Boris Epstein wrote:
Here we go:
[root@gala ~]# ls -l /proc/18702/fd
total 0
...
lrwx-- 1 root root 64 Feb 13 18:58 7 - /home/mysql/tmp/ibE0DGCO
(deleted)
lrwx-- 1 root root 64 Feb 13 18:58 8 -
/home/mysql/mysql_data/ib_logfile0
lrwx-- 1 root
1 - 100 of 322 matches
Mail list logo