Re: MySQL 4.1.11 innodb cache can't be flushed after restart ?

2006/4/7, Charles Q. Shen <[EMAIL PROTECTED]>: > Hi all, > > I am running MySQL 4.1.11 with an innoDB table holding about 17GB of > records. I took a few hundreds of randomly selected records from the table > and measured the average access time: > > 1st test: average access time is 600ms > 2nd tes

Replication for historical data

Hi, I have a customer who wants to be able to replicate their live MySQL database to a second server, but not to have any data deleted. i.e., they want to accumulate the data. I don't believe you can do this with replication. Does anyone know a way of doing this? Cheers, Ian. -- MySQL Gener

Replication for historical data

Hi, I have a customer who wants to be able to replicate their live MySQL database to a second server, but not to have any data deleted. i.e., they want to accumulate the data. I don't believe you can do this with replication. Does anyone know a way of doing this? Cheers, Ian. -- MySQL Gene

How could I know which transaction or thread hold the lock

Hello: How could I know which transaction or thread hold the lock? For example: show innodb status\G ---TRANSACTION 0 78076313, ACTIVE 3906 sec, process no 12729, OS thread id 2952076208 starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1024 MySQL threa

Re: Many Attributes Required Design Query

Hi All, what do you all think about using OSCommerce for this? I have no previous experience with it, but have been looking at it the last 2days. This company has been playing with it, but they were concerned with the many attributes and the requirement of inputting so many records as I origi

RE: Determining if a trigger exists

There is a TRIGGERS table in the information_schema Eg. select Trigger_Name from TRIGGERS where trigger_name = 'TI_AGENT' AND trigger_schema = 'PROPLINK' -Original Message- From: Adrian Co [mailto:[EMAIL PROTECTED] Sent: Friday, 7 April 2006 1:54 PM To: mysql@lists.mysql.com Subject:

Determining if a trigger exists

Hi, Whats the simplest way to determine if a trigger already exists? i.e. For tables you have: CREATE TABLE IF NOT EXISTS ... Is there a way to do CREATE TRIGGER IF NOT EXISTS I'm using MySQL 5.0 btw. Thanks! Regards, Adrian -- MySQL General Mailing List For list archives: http://lists.mys

MySQL 4.1.11 innodb cache can't be flushed after restart ?

Hi all, I am running MySQL 4.1.11 with an innoDB table holding about 17GB of records. I took a few hundreds of randomly selected records from the table and measured the average access time: 1st test: average access time is 600ms 2nd test: average access time is 30ms 3rd test: average access time

VPN Recommendation

Hello, What is the recommended speed for my VPN Server and Client (OpenVPN)? The VPN Server is also the Database Server using MySQL (win32). The VPN Client contains the application (using MyODBC) connecting to the VPN Server and acessing the Server. My speed VPN Server (512Kbps) and Client (256

Re: Many Attributes Required Design Query

[EMAIL PROTECTED] wrote: I agree with the basic design: one table for all of your basic objects (shirts, pants, coats, shoes, etc), one table for all of your attributes (see Barry's response), a sku table equating objects (differentiated by their attributes) and their inventory quantities (on h

Return virtual records

Can anyone explain how I might be able to return a numbers of records based on the sum of a quantity in a field in the same table? (After I read that it sounds even confusing to me). Let me explain. I have records like this, Part#Qty 1254 5 1414

Re: Key and Primary Key

news <[EMAIL PROTECTED]> wrote on 04/06/2006 09:39:33 AM: > IF I have a table like this: > id int not null, > field2 int not null, > .., > primary key (id), > key (field2) > ) ENGINE=MyISAM; > > The primary key is id only or (id, field2)? > If this is the case which constraint are aplied on f

Re: Key and Primary Key

news <[EMAIL PROTECTED]> wrote on 06/04/2006 14:39:33: > IF I have a table like this: > id int not null, > field2 int not null, > .., > primary key (id), > key (field2) > ) ENGINE=MyISAM; > > The primary key is id only or (id, field2)? > If this is the case which constraint are aplied on fiel

Re: need to select correct package

Dominik Klein wrote: The user -a output is : uname -a, but anyway ... Linux wizon.secureserver.net 2.6.9-11.EL #1 Fri May 20 18:17:57 EDT 2005 i686 i6 I didn't understand what is secound command is. You should have just pasted it into your command line and paste back the output into yo

Key and Primary Key

IF I have a table like this: id int not null, field2 int not null, .., primary key (id), key (field2) ) ENGINE=MyISAM; The primary key is id only or (id, field2)? If this is the case which constraint are aplied on field2? -- Three words describe our society:homo homini lupus -- MySQL Gene

Re: Many Attributes Required Design Query

Barry <[EMAIL PROTECTED]> wrote on 04/06/2006 03:52:53 AM: > Mark Sargent wrote: > > Hi All, > > > > I have the job of creating a DB for an online clothing company. I have > > some experience with relational design and sql and php. I'm stumped as > > they have products that contain numerous a

Re: need to select correct package

Thank You, Thank you very much for your help. Sorry for mailing personally,

Re: need to select correct package

The user -a output is : uname -a, but anyway ... Linux wizon.secureserver.net 2.6.9-11.EL #1 Fri May 20 18:17:57 EDT 2005 i686 i6 I didn't understand what is secound command is. You should have just pasted it into your command line and paste back the output into your mail. i686 i6 Tha

Re: need to select correct package

balaraju mandala wrote: Hi DK, The user -a output is : Linux wizon.secureserver.net 2.6.9-11.EL #1 Fri May 20 18:17:57 EDT 2005 i686 i6 I didn't understand what is secound command is. i686 i6 Thats the needed infortmation. get your package here: Red Hat Enterprise Linux 4 RPM (x86) downlo

Re: need to select correct package

Hi DK, The user -a output is : Linux wizon.secureserver.net 2.6.9-11.EL #1 Fri May 20 18:17:57 EDT 2005 i686 i6 I didn't understand what is secound command is. On 4/6/06, Dominik Klein <[EMAIL PROTECTED]> wrote: > > please read what i wrote and do so - I cannot help you without this info > as

Re: need to select correct package

please read what i wrote and do so - I cannot help you without this info as I do not know any "Linux Enter prise ver4" please post your replies to the mysql mailing list, not to my email-address balaraju mandala schrieb: Hi DK, I just want use MySql for personal use. But i am confused which

Re: very long query for such a simple result

Ed, That's not really what I meant. I know what the function SUM() does. But Sum() takes an _expression_ and '1' doesn't seem like much of an _expression_ to me. So what is that 1 equates to and where in the MySQL documentation can I find this explained. The _expression_ here is '1', whi

Re: select all events from (today-N) days

Ok. I found something. But wondering if this is most efficient Events for yesterday: select count(*) from EVENT_DATA where FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() - INTERVAL 1 DAY); Events for last week select count(*) from EVENT_DATA where FROM_UNIXTIME(utime,'%U') = (DATE_FORMAT(CURDATE(),'

Re: need to select correct package

Post output of the commands uname -a and /lib/libc.so.6|head -1 What do you plan on doing with MySQL? Clustering or "rather normal" DB usage? Then we can tell you - or actually you should at least then be able to decide yourself ;) balaraju mandala schrieb: Hi Comunity, I have some probl

select all events from (today-N) days

Hi: I have a date/time field (utime) which has unix time in epoch time. I want to select events from yesterday and another statement for all events from previous week. I have tried the functions listed at http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html. But I either get a synta

need to select correct package

Hi Comunity, I have some probleme for selecting correct package of mysql software from download section in the site. I am confused which Linux version i have to use, as there are different packages. please help me.

Re: very long query for such a simple result

Ed Reed wrote: That's not really what I meant. I know what the function SUM() does. But Sum() takes an expression and '1' doesn't seem like much of an expression to me. So what is that 1 equates to and where in the MySQL documentation can I find this explained. Thanks again. It doesn't car

Re: Many Attributes Required Design Query

Hello Mark, What exactly is your question? How to design the tables for the different types of clothing? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questio

Re: Many Attributes Required Design Query

Mark Sargent wrote: Hi All, I have the job of creating a DB for an online clothing company. I have some experience with relational design and sql and php. I'm stumped as they have products that contain numerous attributes, and are wishing to get away, if possible, with entering separate recor

Many Attributes Required Design Query

Hi All, I have the job of creating a DB for an online clothing company. I have some experience with relational design and sql and php. I'm stumped as they have products that contain numerous attributes, and are wishing to get away, if possible, with entering separate records for each and every

Re: very long query for such a simple result

That's not really what I meant. I know what the function SUM() does. But Sum() takes an expression and '1' doesn't seem like much of an expression to me. So what is that 1 equates to and where in the MySQL documentation can I find this explained. Thanks again. >>> Peter Brawley <[EMAIL PROTEC

Re: Thank you MySQL Cluster

Atle Veka wrote: Thank you MySQL Cluster, for ignoring my information request after submitting about a year and a half ago. I was told in email that I was supposed to be contacted, that never happened. Thank you for automatically signing me up for all sorts of MySQL mailinglists for seminars that