Better option then polling ?

Hello, I am fairly new to mysql and have a strange request I am not sure if "stored procedures" will solve this. I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed. Lets say for example the

Database load and table design ?

Hello, Currently I am using syslog-sql to store syslog data in a mysql database. The table format is something like: ID hostnamefacilityprioritydatemessage ID is auto incrementing Now I am writting a perl app to calculate stats based on the data in the table w

ERROR 2013: Lost connection to MySQL server during query

Hello, Earlier today I tried to make some table alterations on a mysql server (4.0.24) and kept on receiving this error: ERROR 2013: Lost connection to MySQL server during query I would login to the server, either through the socket or using the IP. Then connect to a database and try the followi

Index problem ?

Hello, Currently I am using sysklogd-sql to store syslog messages in a MySQL 4.0.24. The current number of rows is around 3,799,700. The table layout is as follows: ID machine facility priority date1 message Now ID is the primary key and it had one index called hostname containing (mach

Re: ERROR 2013: Lost connection to MySQL server during query

Daniel Kasak wrote: Michael Gale wrote: Hello, Earlier today I tried to make some table alterations on a mysql server (4.0.24) and kept on receiving this error: ERROR 2013: Lost connection to MySQL server during query I would login to the server, either through the socket or using the IP. Then

Index help ?

Hello, I have the following table setup: IDhostnamefacilityprioritydatemessage ID is auto incrementing. This is used to store all of the syslog messages, currently there are over 7 million: The following query takes forever: Select machine,count(*) from syslog WHERE da

data length vs index length ??

Hello, Currently I have a large mysql table (36 million rows) and according to the mysql-admin the data length is 6.5GB and my index length is 8.8GB. I am new to mysql, but I would assume that my index should not consume more space then my data ? But in order to provide the data in a timely man

InnnoDb - change innodb_buffer_pool_size ?

Hello, I am running mysql 4.0.20 with Innodb and we have upgrade grade the RAM in the system from 1GB to 4GB :). Now If I change the: innodb_buffer_pool_size From 500M to 3G the service will not start. I remember reading something about this before and I believe I need to delete the ib_lo

Re: InnnoDb - change innodb_buffer_pool_size ?

Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: Michael Gale [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 10:04 PM To: mysql@lists.mysql.com Subject: InnnoDb - change innodb_buffer_pool_size ? Hello

Re: InnnoDb - change innodb_buffer_pool_size ?

Hello, Even if I change the value to 2G it still will not load ? Because the value was 500M before do I not have to remove the ib* files and have them recreated ? Michael Michael Gale wrote: Hello, I am running mysql 4.0.20 with Innodb and we have upgrade grade the RAM in the

Master and slave with different versions

Hello, Right now we are running a mysql-max db with InnoDb for transaction tracking. This is a older version of mysql running mysql-3.23 build 50. We are planning on upgrading to mysql 4.0 latest in a couple of weeks (hopefully). Anyways in order to do proper backups with InnoDB I am g

Re: IMPORTANT: Please Verify Your Message

iving junk mail using > Spamcease Just this once, > click the link below so I can receive your emails. You won't have to do this again. > > http://www.tgpwizards.com/spamcease2/verify.php?id=1094016 -- Michael Gale Network Administrator Utilitran Corporation -- MySQL Genera

mysqld being killed by VM

? It appears that the mysqld-max process will try and use all the memory in the box and so the kernel will kill the process. Also if I used mysqld_safe would it restart after this ? -- Michael Gale Network Administrator Utilitran Corporation -- MySQL General Mailing List For list archives

mysql 4.1 cluster

Hello, Anyone running mysql 4.1 with cluster support ? Is it sort of production ready ? -- Michael Gale -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Data loading

ing a loop with INSERTS ? -- Michael Gale Network Administrator Utilitran Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql bin files

can uses these to restore mysql data. So am I correct in thinking that I can safely backup any hostname-bin-### files older then let's say a week to a backup server and then delete them from the data directory ? We are running mysql-3.23 build 50. -- Michael Gale -- MySQL General Mailing