suggestion for disk configuration

[Luca Ferrari]

Hi,
I have to install a  mysql server for managing several database, from small to 
quite big (tables with about 2M rows). I've got a SAS disk array and I was 
wondering what the best configuration could be:
1) raid 10
2) raid 5
3) a combination (e.g., raid10 for the data and raid 5 for the logs).

Any suggestion or link?

Thanks,
Luca

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

encrypt - password

[Luca Ferrari]

Hi all,
I've got an account table with password encrypted thru the encrypt() function, 
and I should transfer them to a table with password() function. I don't want 
to decrypt the password, and I'd like to know if there's a way to build the 
password hash from the encrypt one.

Any suggestion?

Thanks,
Luca

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

pam and crypt using mysql

[Luca Ferrari]

Hello,
sorry if this is not the right mailing list to ask this question, hope someone 
can point me to a better list in the case. 
My problem is that I'd like to use mysql as database for storing user accounts 
for different services, and I started using vsftpd. Now, following the 
instruction here http://www.howtoforge.com/vsftpd_mysql_debian_etch_p2 I have 
to configure the pam module using crypt=2 and to store the user password thru 
the password function. However, this didn't work, and after a lot of trials I 
found that the only way I can make them working is using crypt=1 and storing 
password thru the encrypt function.
Anyone that can provide me a reason why I'm not able to use the password 
function? Does it depends on some module I'm missing (with regard to mysql) 
or to a misconfigured linux server?


Thanks,
Luca

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migration from Oracle to MySQL

[Luca Ferrari]

On Thursday 26 July 2007 Rajesh Mehrotra's cat, walking on the keyboard, 
wrote:
 Check out
 http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html



Please note that PostgreSQL provides a gateway to other databases thanks to 
the DBI-Link extension, as well as it support more than only jdbc-4 driver 
(of course the 4 is the best).

Luca

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

sequences and auto_increment

[Luca Ferrari]

Hi all,
I'm new to MySQL coming from PostgreSQL backgroud. I'd like to know how to 
obtain the same effect of a sequence + concat as default value of a table in 
mysql. For example, consider the following table definition:

CREATE TABLE competenza
(
  id_competenza character varying(30) NOT NULL DEFAULT ('comp-06-'::text || 
(nextval('sequenza_competenza'::regclass))::text),
  descrizione character varying(100),
  CONSTRAINT competenza_pkey PRIMARY KEY (id_competenza)
) 

there, id_competenza is compound by a string comp-06 and the next value of a 
sequence (similar to auto_increment). In MySQL there're no sequences, or 
better, there's only an auto_increment action on an int field. How can I 
obtain the same effect of the concatenation of a sequence and a string?

Thanks,
Luca

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sequences and auto_increment

[Luca Ferrari]

On Tuesday 02 January 2007 16:51 Brent Baisley's cat, walking on the keyboard, 
wrote:

 CREATE TABLE competenza (
 competenza varchar(30) NOT NULL default 'comp-06-',
 id_competenza int unsigned not null auto_increment,
 descrizione varchar(100),
 PRIMARY KEY (competenza, id_competenza)
 )

 Since your PRIMARY KEY is a combination of 2 fields (competenza +
 id_competenza ), each competenza value will have it's own auto increment
 (id_competenza ) sequence. So id_competenza  won't be unique, but the
 combination of competenza + id_competenza will be.



Thanks for your suggestion, but this would make my queries more complex, since 
to get the id of a skill (italian is competenza) will require querying two 
fields.
It's true that I can simulate sequences with a table with auto_increment, but 
this means I need to insert a record before in such table to get the new id 
and then insert in my competenza table. This would require a transaction and 
will result even more complex than the above, I guess.

Any other idea?
Thanks,
Luca

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]