Re: Configure prob with FreeBSD/Linuxthreads

2003-01-30 Thread Gianluca Sordiglioni
> > gcc -v > Using built-in specs. > Configured with: FreeBSD/i386 system compiler > Thread model: posix > gcc version 3.2.1 [FreeBSD] 20021119 (release) Okay. > Because with native threads, enabling the second CPU (and thus locking > MySQL to one thread, one process, -period-, because running an

Re: Configure prob with FreeBSD/Linuxthreads

2003-01-29 Thread Gianluca Sordiglioni
, SMP vs NonSMP kernel)). I dunno. I don't see any reason to use LinuxThreads. What kind of advantages they have? I neved had performance problems on heavy-used databases (7 mil records, 50 tps) on FreeBSD 4.6. Gianluca Sordiglioni DB Manager Vox2Web Srl - Italy tel. +390245054533 -

Re: /tmp datadir

2002-12-19 Thread Gianluca Sordiglioni
> Mysql server is working good for 5-10 minutes and then changes > directory to /tmp - it starts telling ERROR 1049: Unknown database > 'test'. > > Restarting the server helps for next 5-10 minutes. There are no errors > in error-log, query log etc. > SHOW VARIABLES still telling datadir from cnf

FULLTEXT index time

2002-12-16 Thread Gianluca Sordiglioni
ost | gufiweb | Query | 0 | NULL | show processlist| +-+--+---+-+-+---+-- +-+ 2 rows in set (1.74 sec) Gianluca Sordiglioni DB Manager Vox2Web Srl te

Re: Mysql Replication

2002-12-03 Thread Gianluca Sordiglioni
u own mysql_connect() and mysql_query(). Gianluca Sordiglioni DB Manager Vox2Web Srl tel. 0245054533 - Original Message - From: "Massimo Bandinelli" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 20, 2002 4:22 PM Subject: Mysql Replication A question

Re: Slave sincronize

2002-11-20 Thread Gianluca Sordiglioni
Massimo Bandinelli wrote: > > I've problems sincronizing a Slave DB with a Master. > > I've a db created with name "foo-db" from phpmyadmin but the mysql shell doesn't >accept > > > create database foo-db; > > Do you know something about this?? Check your privileges. Use mysql_fix_privilege_t

Datafiles on raw devices

2002-09-03 Thread Gianluca Sordiglioni
es someone thought a solution? Is this feature Linux only, or FreeBSD also? Thank you, -- Gianluca Sordiglioni DB Manager vox2web srl - gruppo OmniaNetwork spa phone: +39 02 45054533 - Before posting, please check: http://www.