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
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
Andy
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#=D+ ^
Managed Services (in:control) Developer, Telindus, RG27 9HY
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
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 PROTECTED]
Sent: Friday
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
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,
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 +, Andy Ford wrote:
Hi everyone.
I have been putting together a c++ wrapper for the mysql c libraries and
have stumbled across the following error...
g++ -L
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
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#=D+ ^
This e-mail is private and may
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
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: Tuesday, 11 January 2005 8:59 PM
To: mysql@lists.mysql.com
Subject: compilation errors in mySQL C app
Hi everyone
I am
: 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: compilation errors in mySQL C app
Hi David
Yes it is something like you say...
file /usr/local/bin/gcc
/usr/local/bin/gcc: ELF 32
..
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 -lmysqlclient -lsocket -lnsl -lm
-o test
.. seemed to work
I get a 'Bus Error (core dumped)' when I run it - but that's a problem
with the code!!
Thanks
Andy
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 am
getting
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
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,
at 14:19 +, Andy Ford wrote:
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
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 such
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;
MYSQL_ROW row;
MYSQL *connection
On Tue, 2005-01-11 at 16:10 +, 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
When running 'check' I get ...
check
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 FROM
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 can do
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
--
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]
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 =
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,
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,
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
29 matches
Mail list logo