MySQL Binary Log Summary Tool - w/link!

2009-03-02 Thread Claudio Nanni
All Lately I am struggling with big tables maintenance, I've just made a very quick and dirty tool for having summaries from the binary log files, like how many times a table was updated, or inserted or deleted. Before going any further I would really appreciate your opinion to know if there is

MySQL Binary Log Summary Tool

2009-03-02 Thread Claudio Nanni
All Lately I am struggling with big tables maintenance, I've just made a very quick and dirty tool for having summaries from the binary log files, like how many times a table was updated, or inserted or deleted. Before going any further I would really appreciate your opinion to know if there is

Compiling a second mysql binary with a distinct configuration.

2007-09-15 Thread Lloyd Zusman
I'm running mysql-5.0.46 on a linux system on a VPS. As such, the yum package manager is being used to install a standardized mysql installation, and I due to other system dependencies, I can't change this. I need a second mysql installation on that machine that runs under a completely different

Re: Large size of MySql binary for Power PC

2006-09-05 Thread Michael Loftis
--On September 5, 2006 1:41:43 PM +0530 Arvind Kumar <[EMAIL PROTECTED]> wrote: Hi! Any help would be appriciated. I found MySQL binaries for embedded system (Processor: Power PC, OS:Linux) There is not much space available in the hard disk. It is around 20 MB. The binary size is large enou

Large size of MySql binary for Power PC

2006-09-05 Thread Arvind Kumar
Hi! Any help would be appriciated. I found MySQL binaries for embedded system (Processor: Power PC, OS:Linux) There is not much space available in the hard disk. It is around 20 MB. The binary size is large enough, could you please tell me how can i reduce binary size. Stripping, I already did.

Installing Mysql binary distribution

2004-05-19 Thread Laercio Xisto Braga Cavalcanti
Hi all, IĆ” trying to install and use a MySQL binary distribution doing the folowing steps: Download the file mysql-standard-4.0.20-pc-linux-i686.tar.gz groupadd mysql useradd -g mysql mysql cd /usr/local gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar

RE: Installing Mysql binary distribution

2004-05-19 Thread Jeffus Chris - cjeffu
First of all check the *.err log in your data dir. It will likely give you some clue as to what is happening. -Original Message- From: Laercio Xisto Braga Cavalcanti [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 3:08 PM To: [EMAIL PROTECTED] Subject: Installing Mysql binary

UDF and mysql binary distr

2003-02-28 Thread Diana Soares
Hi, For the busy ones, here's my question (then i explain): is it possible to add an UDF to a binary distr (.rpm for RH-8, downloaded from mysql.com) ? I'm having problems in creating an UDF (i create but when a use it mysqld restarts automatically). I've already created UDF functions in the past

Re: Mysql - Binary vs. Source

2002-12-18 Thread Michael T. Babcock
Lenz Grimmer wrote: Sorry, but that would not be true. We actually *do* distribute most binaries in gzipped tar archives. tar.gz is not limited to contain source files only. I posted a self-correction. I still think the download page is unnecessarily misleading in some ways. Perhaps fixi

Re: Mysql - Binary vs. Source

2002-12-18 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 18 Dec 2002, Michael T. Babcock wrote: > This binary/source confusion comes from the download page; it says > "Binary packages (tar.gz)" for the source download and "Linux RPM > packages (rpm)" for the binary package. Could someone please cha

Re: Mysql - Binary vs. Source

2002-12-18 Thread Michael T. Babcock
Santiago Alba wrote: I installed binary version (source distribution)... not with rpm This binary/source confusion comes from the download page; it says "Binary packages (tar.gz)" for the source download and "Linux RPM packages (rpm)" for the binary package. Could someone please change th

Binary Compilers? (was: Compiling MySQL binary?)

2002-12-14 Thread Brian Radford
Maybe it's just me, but I'm getting this sinking feeling I just asked another "google" question! :-/ How about I simplify my request to any recommendations for compiler(s) that would be suitable to compile binaries for Mac OS X's Darwin 6.1 and/or... Windows XP... Thank you! Brian -- Brian S.

Binary Compilers? (was: Compiling MySQL binary?)

2002-12-14 Thread Scott Ford
Maybe it's just me, but I'm getting this sinking feeling I just asked another "google" question! :-/ How about I simplify my request to any recommendations for compiler(s) that would be suitable to compile Binaries for Mac OS X's Darwin 6.1 and/or... Windows XP... Thank you! Brian -- Brian S.

Compiling MySQL binary?

2002-12-14 Thread Brian Radford
Hello, I'm interested in compiling my own MySQL binaries but I'm not quite sure of what all I will need to do so. From what I understand, thus far, I will need a MySQL source package and a compiler. Is there anything else I will need to complete this task and does anyone have a recommendation

re: newbie really need help > mysql binary installation problem

2002-11-19 Thread Victoria Reznichenko
David, Monday, November 18, 2002, 2:53:33 AM, you wrote: DW> I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel DW> 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess DW> in the documentation in the mysql.com web site. DW> I am using bash shell, here

Upgrading mysql with mysql binary vs. compiling

2002-11-18 Thread Greg Macek
Is there any reason I should use my MySQL supplies binaries to upgrade my currently installed version? I compile the running version (3.23.49). Is there any difficulty in doing this? Any pitfalls to watch out for, or should I just continue to compile my own and upgrade via that path? - Greg --

newbie really need help > mysql binary installation problem

2002-11-18 Thread David Wu
Hi guys, I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess in the documentation in the mysql.com web site. I am using bash shell, here is the list of commands i went through: shell> groupadd mysql s

Use mysql binary or build my own ?

2002-06-14 Thread David BORDAS
Hi list, I've got a mysql dedicated server. Some piece of hardware : SMP : 2 * Intel PIII 1 Ghz 1Go of ram Scsi - Raid 5 Hdds Linux red-hat 7.2 This system run mysql 3.23.49 (tar.gz binary from Mysql.com ). I only have one MyIsam table with around 5 Millions of records ( around 1.2 Go disk space

Re: Mysql binary logs

2002-03-29 Thread Marc Prewitt
You might want to use the mysqlbinlog utility to look at the binlog. The binlog format has changed at least once in past versions and could change again. However, the output from mysqlbinlog just a straight text format of updates/inserts/deletes which happen to a database. -Marc Konstantin Yo

Mysql binary logs

2002-03-29 Thread Egor Egorov
Konstantin, Friday, March 29, 2002, 11:31:23 AM, you wrote: KY> I want to ask about binary log - what kind of info it KY> writes and how I can use it. Is this info is connected KY> with optimizing mysql work. mysqld writes in a log file all SQL commands that update data and info about how long

Mysql binary logs

2002-03-29 Thread Konstantin Yotov
Hello! :) I want to ask about binary log - what kind of info it writes and how I can use it. Is this info is connected with optimizing mysql work. Thanks. Kosyo __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http

Re: MySQL Binary

2001-11-24 Thread Mike(mickalo)Blezien
On Fri, 23 Nov 2001 23:46:40 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote: >>At 10:14 PM -0600 11/23/01, Mike(mickalo)Blezien wrote: >>>Hello all, >>> >>>I'm a bit confused. Does the Mysql-Max only come with BDB/Innodb >>>support or does >>>both the Mysql and Mysql-Max binaries both support tr

Re: MySQL Binary

2001-11-24 Thread Paul DuBois
At 10:14 PM -0600 11/23/01, Mike(mickalo)Blezien wrote: >Hello all, > >I'm a bit confused. Does the Mysql-Max only come with BDB/Innodb >support or does >both the Mysql and Mysql-Max binaries both support transactions?? Max only. > >thx's > >Mike(mickalo)Blezien >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Error Install MySQL Binary on AIX

2001-08-28 Thread Michael Widenius
Hi! > "ajgrif" == ajgrif <[EMAIL PROTECTED]> writes: >> Description: ajgrif> I downloaded the lated AIX binary from mysql.com, and unpacked it to /usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db per the INSTALL-BINARY file. This is the error I

Re: Error Install MySQL Binary on AIX

2001-08-27 Thread Sinisa Milivojevic
_db > >Fix: > > > >Submitter-Id: > >Originator: Andrew Griffin ([EMAIL PROTECTED]) > >Organization: Emerson Process Management > >MySQL support: none > >Synopsis: > >Severity: non-critical > >Priority:medium > >

Error Install MySQL Binary on AIX

2001-08-27 Thread ajgrif
s Management >MySQL support: none >Synopsis: >Severity: non-critical >Priority: medium >Category: mysql >Class: support >Release: mysql-3.23.41 (Official MySQL binary) >Environment: System: AIX aixtest1 3 4 000165744C00 So

Re: MySQL binary/source

2001-07-07 Thread Sinisa Milivojevic
"MikeBlezien" <[EMAIL PROTECTED]> writes: > > > I assume this is the correct one to download then: > mysql-3.23.39-pc-linux-gnu-i686.tar.gz > > > Mike(mickalo)Blezien > Yes. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> /

Re: MySQL binary/source

2001-07-06 Thread MikeBlezien
I assume this is the correct one to download then: mysql-3.23.39-pc-linux-gnu-i686.tar.gz >>"MikeBlezien" <[EMAIL PROTECTED]> writes: >>> >>> Thanks. Which files would I need to download then?? Just the RPM's or RPM's and >>> the tarball binary? >>On Fri, 6 Jul 2001 16:54:12 +0300, Sinisa Mi

Re: MySQL binary/source

2001-07-06 Thread Sinisa Milivojevic
"MikeBlezien" <[EMAIL PROTECTED]> writes: > > Thanks. Which files would I need to download then?? Just the RPM's or RPM's and > the tarball binary? > > > Mike(mickalo)Blezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work!

Re: MySQL binary/source

2001-07-06 Thread MikeBlezien
Thanks. Which files would I need to download then?? Just the RPM's or RPM's and the tarball binary? >>On Fri, 6 Jul 2001 16:41:05 +0300, Sinisa Milivojevic <[EMAIL PROTECTED]> wrote: Use our MySQL-Max binary as it contains InnoDB. Our binaries are built in the most optimial manner, a

Re: MySQL binary/source

2001-07-06 Thread Sinisa Milivojevic
"MikeBlezien" <[EMAIL PROTECTED]> writes: > Hello All, > > Our company is going to be setting up on a dedicated server, so I am in the > process of doing some "crash course" learning as a system admin. We are looking > at a server with RedHat Linux 6.2 O/S and we want to install MySQL laster stab

MySQL binary/source

2001-07-06 Thread MikeBlezien
Hello All, Our company is going to be setting up on a dedicated server, so I am in the process of doing some "crash course" learning as a system admin. We are looking at a server with RedHat Linux 6.2 O/S and we want to install MySQL laster stable version w/InnoDB enabled. Now from the docs, it s

errors trying to compile programs with mysql binary

2001-06-07 Thread Jordan Kanev
Hi All, I have installed mysql 3.23.38 from binary distribution. Problem is that when I try to compile some program for mysql i got this error message: -- gcc -o nacctd -Wall -O2 -Wstrict-prototypesmain.o daemon.o process.o utils.o config.o capture-linux.o

MySQL binary with BerkeleyDB

2001-04-10 Thread Florin Andrei
I saw that MySQL now includes BDB in the source tree. When will be released a binary package with BDB and transactions support already compiled? I'm interested in the Linux, Irix and Windows versions. -- Florin Andrei - Befor

Re: mysql++ binary RPM broken

2001-03-16 Thread Sinisa Milivojevic
Jerome Abela writes: > I encountered a few problems with the genuine 1.7.8-1 binary RPM for > mysql++. > > - If I compile: > Connection con("temp","localhost","root","temp",3306,0,60,1,"",0); > The linker complains: undefined reference to >`MysqlConnection::MysqlConnection(char cons

mysql++ binary RPM broken

2001-03-15 Thread Jerome Abela
I encountered a few problems with the genuine 1.7.8-1 binary RPM for mysql++. - If I compile: Connection con("temp","localhost","root","temp",3306,0,60,1,"",0); The linker complains: undefined reference to `MysqlConnection::MysqlConnection(char const *, char const *, char const *, char con

Re: Problem with MySQL Binary (mysql-3.23.32-unknown-freebsdelf4.2-i386)

2001-03-12 Thread Dan Nelson
In the last episode (Mar 12), [EMAIL PROTECTED] said: > >Description: >When I try and run scripts/mysql_install_db I get the error >'/usr/libexec/ld-elf.so.1: > /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception"' I also got the same >error when I tried to run mysql using > /usr

Problem with MySQL Binary (mysql-3.23.32-unknown-freebsdelf4.2-i386)

2001-03-12 Thread drew
>Description: When I try and run scripts/mysql_install_db I get the error '/usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception"' I also got the same error when I tried to run mysql using /usr/local/mysql/bin/mysql as stated in the Subject I have FreeBSD