Solaris 10 performance improvements??

2004-11-16 Thread Jon Hancock
Hello list, It has been my understanding from reading this list for a few years that Solaris doesn't match Linux on MySQL performance. I don't recall the exact reasons (different threading code?). Anyway, I'm exploring the latest Solaris 10. The virtualization features (Containers) are

Re: Solaris 10 performance improvements??

2004-11-16 Thread Jon Hancock
Shankar Unni wrote: Jon Hancock wrote: However, I can't consider using it unless MySQL performs well. Any ideas or personal experience with MySQL 4.1.x on Solaris 10? Well, for one thing, your workload is unique, so the only way you can make your decision *is* for you to actually *consider

Re: Lucene with MYSQL

2004-07-29 Thread Jon Hancock
Carlos Proal wrote: Hi, i have been using Lucene MySQL but separately, MySQL is written in C/C++ with a JDBC driver available and Lucene is coded in Java, so (besides the mysql team opinion) you can mix searches throught both apis and referring to each other with the PrimaryKey. Does anyone

so long I keep longing

2003-11-06 Thread Jon Hancock
for 4.1.1... .anyone have a good guess for getting a build of 4.1.1 ??? thanks, Jon

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-27 Thread Jon Hancock
Heikki, I have two questions in regards to the tablespace changes: 1 - You mention being able to store indexes in a seperate tablespace. How far off is this for MySQL to implement? I would like to see FULLTEXT indexes stored in seperate tablspace (seperate RAID channel) so the two features

Partial replicate InnoDB - MyISAM

2003-10-27 Thread Jon Hancock
ideas on how to do this? thanks, Jon - Original Message - From: Chris Nolan [EMAIL PROTECTED] To: Jon Hancock [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, October 27, 2003 8:45 PM Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 Hi, As I have said before

Re: Partial replicate InnoDB - MyISAM

2003-10-27 Thread Jon Hancock
see below... - Original Message - From: Chris Nolan [EMAIL PROTECTED] To: Jon Hancock [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 10:49 AM Subject: Re: Partial replicate InnoDB - MyISAM Hmm How much lag time can you afford between the master's contents

install script errors

2003-09-29 Thread Jon Hancock
Hello, I am installing mysql 4.1.0 rpm on SuSE 8.2. I am logged in as root and run the rpm command as follows: rpm -Uvh MySQL-server-4.1.0-0.i386.rpm The script completes but gives two errors. The errors in mysql_install_db are on lines 166 and 383. Both lines are the same: if test $in_rpm

Re: innodb and fragmentation

2003-09-20 Thread Jon Hancock
When you issue this null ALTER TABLE, is the entire table locked during the build? i.e. Is the only way to defragment to effectively take the table offline during the rebuild? Is there a method to estimate time to do this rebuild? thanks, Jon - Original Message - From: Per Andreas Buer

utf8 in 4.1 for Windows

2003-07-29 Thread Jon Hancock
I have read in past postings that UTF8 is not yet working with MySQL 4.1 on the Windows build. Can anyone verify this? If it is not yet working, can anyone give an estimate when a build will be available that should work? thanks, Jon

need 4.1 binaries

2003-02-10 Thread Jon Hancock
We are in a critical state with our app. We would like to dump Oracle 9i and go to MySQL. We have to do the due diligence on the port over the next few weeks. However, we must have full native support for UTF8. Its my understanding this is only in MySQL 4.1. Our dev and test platform is