RE: limitations of mySQL i.e. number of rows

Thanks for the info Dan. I'll check the resources you mentioned. Regards Andy From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Tue 8/22/2006 1:38 PM To: Andy Ford Cc: mysql@lists.mysql.com Subject: Re: limitations of mySQL i.e. number of rows

limitations of mySQL i.e. number of rows

Hi everyone I have a requirement to store in the region of 3 million entries per month (30 ish days) of data in a mySQL database totalling a maximum of 2 months (6 Million entries). The database will be 'probably' reside on a Sun V240. I have a similar size database running on an old Sun E450

remote monitoring of mySQL

What would be the best approach to remote monitoring of numerous mySQL databases remotely i.e. number of threads. number of open tables etc etc Can I do it with DBD::Perl Thanks Andy -- perl -e "print qq^bIG VeRN ! ^^qq^#'#Yv#=http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

RE: new insallation of mysql not starting

ables created 050429 11:32:12 InnoDB: Started; log sequence number 0 0 050429 11:32:13 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050429 11:32:13 mysqld ended Thanks Andy -Original Message- From: Andy Ford [mailto:[EMAIL P

new insallation of mysql not starting

I have just upgraded a mySQL installation on a Soalri 2.8 box for the source. It compiled and installed without error. The startup script redirect STDOUT & STDERR into /dev/null so this is what I did ... /usr/bin/mysqld_safe --datadir=/data/mysql-data/ --pid-file=/data/mysql-data/mysql.pid St

How to move a database to a new directory

I have run out of disk space in the directory where I have a mySQL database. How do I go about moving it and reconfiguring mySQL to see the new location. Thanks Andy This e-mail is private and may be confidential and is for the intended recipient only. If misdirected, please notify us by telep

RE: graphs

Perl and GD would do the trick. Take a look at how RDDtools does it! Andy -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 13, 2005 11:08 PM To: prathima rao; mysql@lists.mysql.com Subject:Re: graphs prathima rao wrote: >hello, > >

Re: compilation errors in c++ wrapper

Whoops - every c/c++ program must have a main function. That's what the cryptic message was... Andy On Wed, 2005-01-12 at 17:35 +0000, Andy Ford wrote: > Hi everyone. > I have been putting together a c++ wrapper for the mysql c libraries and > have stumbled across the following er

compilation errors in c++ wrapper

Hi everyone. I have been putting together a c++ wrapper for the mysql c libraries and have stumbled across the following error... >g++ -L/usr/local/mysql/lib -I/usr/local/mysql/include -o connection connection.cpp -lmysqlclient -lnsl -lsocket -lz -lm Undefined first referenc

SOLVED (at last) Re: c program Bus Error (core dumped)

Andy On Tue, 2005-01-11 at 16:10 +0000, Andy Ford wrote: > I have a slight variation on that for my Solaris 2.8 machine... > > >g++ -m64 -o check check.cpp -L/usr/local/mysql/lib > -L/usr/local/lib/sparcv9/ -lmysqlclient -lsocket -lnsl -lm > // this part works fine > &g

Re: c program Bus Error (core dumped)

eeing this? This is a 64bit kernel Solaris 2.8 Sunfire V120. I'm thinking it may be an architecture thing!! Thanks Andy On Tue, 2005-01-11 at 15:29 +, Andy Ford wrote: > I can get something working however. > > int main(char **args) { > MYSQL_RES *result; >

Re: c program Bus Error (core dumped)

I have a slight variation on that for my Solaris 2.8 machine... >g++ -m64 -o check check.cpp -L/usr/local/mysql/lib -L/usr/local/lib/sparcv9/ -lmysqlclient -lsocket -lnsl -lm // this part works fine When running 'check' I get ... >check ld.so.1: ./check: fatal: libstdc++.so.5: open failed: No suc

Re: c program Bus Error (core dumped)

ing Cool with the connection version = 40107l Done. ... but that is as far as I can go until I can fix the Bus Error Regards Andy On Tue, 2005-01-11 at 14:19 +, Andy Ford wrote: > Thanks Jose ... > > but I still get the Bus Error message with the following code... > > in

Re: c program Bus Error (core dumped)

Thanks Jose ... but I still get the Bus Error message with the following code... int main(char **args) { MYSQL_RES *result; MYSQL_ROW row; MYSQL *connection, mysql; int state; int PORTNUM = 3306; mysql_init(&mysql); connection = mysql_real_connect(&mysql, "localhost"

Re: ALTER TABLE....with CHANGE syntax

Which version are you running. Quite often when you see a 'check the version you are running' message indicates a syntax error in your mySQL statement.. Andy On Tue, 2005-01-11 at 05:13 -0800, Karam Chand wrote: > Hello, > > Can somebody tell me from which version of MySQL is - > > ALTER TABLE

Re: c program Bus Error (core dumped)

I can send the truss output of anyone can decipher it!! Regards Andy On Tue, 2005-01-11 at 13:05 +, Andy Ford wrote: > Hi everyone. > > I have been trying to write a simple c program to access a local mySQL > database (with the help of David Logan). With the following code I

c program Bus Error (core dumped)

Bus Error (core dumped) The 'Bus Error' I have Googled for but can't find a resolution. Any ideas? Thanks again.. Andy On Tue, 2005-01-11 at 12:05 +, Andy Ford wrote: > Got it ... > > Thanks David > > >gcc -m64 test.c -L/usr/local/mysql/lib -lmysql

RE: compilation errors in mySQL C app

> +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -Original Message- > From: Andy Ford [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 11 January 2005 9:37 PM > To: Logan, David (SST - Adelaide) > Cc: mysql@lists.mysql.com > Subject: RE: compil

RE: compilation errors in mySQL C app

> Database Administrator > HP Managed Services > 148 Frome Street, > Adelaide 5000 > Australia > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -Original Message- > From: Andy Ford [mailto:[EMAIL PROTECTED] > Sent:

compilation errors in mySQL C app

Hi everyone I am trying to compile a simple C program to connect to a mySQL database (on localhost) and run a simple query. I am getting the following errors... >gcc test.c -L/usr/local/mysql/lib -lmysqlclient -o test ld: warning: file /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): wrong EL

mySQL C++ API (which libraries)

Hi fellow developers ... I'm about to move my Perl code to C++ for security. Which mySQL libraries are the best ones to use? There are so may available I thought I'd consult the community in the know! Thanks Andy -- perl -e "print qq^bIG VeRN ! ^^qq^#'#Yv#=http://lists.mysql.com/mysql To unsubs

Re: Removing Entries From a MySQL Table

Or simply, Delete from table_name; Andy -Original Message- From: Sommerfield, Thomas P <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; MySQL Mailing List <[EMAIL PROTECTED]> Sent: Tue Jul 20 22:16:14 2004 Subject: RE: Removing Entries From a MySQL Table Hello; DELETE F

Re: Hash Index

A hash is a key value pair i.e. if you want a value for a unique key (in perl anyway) you can do this... %status = ( 1 => "true", 0 => "false" ); If I have a variable that hold an integer such as $test = 1 I c

table locking using perl DBI

I have a perl cgi script that needs to lock the tables. Unfortunately, as HTTP is a one shot protocol, once the cgi script completes execution, the tables are unlocked. I need it to stay locked until another cgi script unlocks them! Is there any other way of achieving this!? Thanks Andy --

update if insert fails

Hi Is there such a statement where, if the insert fails (due to a duplicate record) an update will happen Thanks Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How do I determine the row number or key when table has no key fields

I thought LIMIT limited you to N number of CONCURRENT record. ie. limit 10 or limit 20 I believe Ross would like to select select 1000 records and then do a sub select of records 1-20 and then 21-40 on this record set Or am I barking up the wrong tree? Andy On Fri, 2004-04-02 at 14:05, Andy Eas

Re: Replication between different database names

I guess what I'm trying to ask is . is it possible for a MySQL server to be a slave to many MySQL masters? And can all of this information go into one my.cnf file so on startup the masters will all start syncing their data to the one slave Thanks Andy On Fri, 2004-04-02 at 12:49,

Re: Replication between different database names

I've no idea!! My apologies for the blank response I am rather new to replication and still trying to discover what I actually need to do. I have managed to get two databases with the same name across two different servers replicating correctly. When I change the name on the slave however, re

Replication between different database names

I have a central mysql server that is required to be a slave to many different master databases on my customer sites. Is it possible to replicate many masters to one slave where the masters have the same DB name?? i.e. do this . customer A central site DB = cu