getting size of query rows

2004-01-24 Thread Juan Nin
Hi! I want to get amount of disk space used by certain rows on disk, not a whole table, but only some rows. Is this possible? For example I got a table like: CREATE TABLE `categories` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `parent_category_id`

Re: Mysql and postfix

2003-04-01 Thread Juan Nin
From: Arthur Lessard [EMAIL PROTECTED] This is probably a topic that has been beaten to death, but I need help in finding a resource for getting postfix to support mysql on RedHat 8.0. You can use Simon J. Mudd's SRPMs or Tuomo Soini's ones... Simon J. Mudd's: http://postfix.wl0.org/en/

Fw: Mysql and postfix

2003-04-01 Thread Juan Nin
From: Arthur Lessard [EMAIL PROTECTED] Thanks, Juan, and Patrik as well, this helped immensely. I can get postfix working, and it seems to read the mysql tables on startup, which it wouldn't do before. great :) However, I still have one bad problem - it won't accept mail.

MySQL vs. PostgreSQL recent article?

2003-03-31 Thread Juan Nin
Hi, Does anybody know of any MySQL vs. PostgreSQL recent article? I mean, that it covers MySQL 4.x and PostgreSQL 7.3.x Thanks in advance, Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Re: auto generated column data: is it possible?

2003-03-21 Thread Juan Nin
From: Victoria Reznichenko [EMAIL PROTECTED] Why do you want to store the sum of columns? You can just sum them when you retrieve data. The database has got about 1 million records, and it gorws day by day The query I need returns lots of records, and calculating it while retrieving data is

auto generated column data: is it possible?

2003-03-20 Thread Juan Nin
Hi, I got the following question: Imagine I have a table with 3 colums (column1, column2, column3), which are of type INT. I want the data in column3 to be generated automatically from the one in column1 and column2 when it is inserted For example a sum, that the data in column3 be the sum of

Re: performance issue of innodb

2003-02-28 Thread Juan Nin
From: Frank LIU [EMAIL PROTECTED] I also did some other test: I ceated two tables both only have two columns, and both load 5 rows. Talbe A has two int type columns, Table B has an int type as primary key, and a mediumblob column. I insert a 4k data into blob column of each row. It

Re: Re: SELECT DISTINCT question

2003-02-28 Thread Juan Nin
From: Sheryl Canter [EMAIL PROTECTED] DISTINCT removes duplicates: rows that are the same in *all* columns. Would this be all columns in the table, or all columns retrieved by the SELECT statement? in the SELECT statement :) SELECT queries do not alter your rows, you can only do

MySQL 4.1 status / yahoogroups kind project

2003-02-26 Thread Juan Nin
Hi, I'd like to know when the final MySQL 4.1 is expected to be released. I know it's in alpha state now, so I guess it's not recomendable for production yet.. What about 4.0? Can it be already used for production? Another thing.. I'm about to make a kind of yahoogroups in PHP. It's for a