Re: innodb and vbulletin 1.1

2002-01-21 Thread Eric J. Schwertfeger
On Fri, 19 Jan 2001, Byron Albert wrote: Hello, I have a few questions. First I work on a very high traffic site that uses vbulletin 1.1 to run its bb. The bb is very high traffic around 60-200 concurrent users. We are starting to run into some serious locking issues, and I am

Re: InnoDB Clarifications for InnoDB newbie

2001-11-15 Thread Eric J. Schwertfeger
On Thu, 15 Nov 2001 [EMAIL PROTECTED] wrote: I am using 4.0 and switching from MyISAM to InnoDB, so quite newbie on this: I'm still using 3.23.4X (differs depending on which machine I'm on), but I'm pretty sure that none of the questions have answers that change too much between those

Adding functions

2001-10-26 Thread Eric J. Schwertfeger
Before I overcommit myself, I want to find out a few things: 1) How much work does it take to add functions (not procedures)? 2) Is anyone already working on these functions? 3) Is anyone else interested in these functions? The function I need is a unix-timestamp to

Re: Berkeley or InnoDB?

2001-09-04 Thread Eric J. Schwertfeger
On Fri, 31 Aug 2001, Ary Medeiros wrote: I'm porting an application to MySQL and I need to support transactions. I will appreciate so much if someone could give me some impressions about which one is better. BerkeleyDB or InnoDB? I have to agree with the other poster on this. When I first

Re:DBI bug, InnoDB bug, MySQL bug, or I'm just plain missing something.

2001-08-17 Thread Eric J. Schwertfeger
On Fri, 17 Aug 2001, Heikki Tuuri wrote: Problem resolved, thank you very much. It was indeed my missing a concept, description below: it was not immediately clear to me what your application does. Does one connection update the table and another connection do the SELECT? Yes, as it's two

Re: InnoDB, BDB, and Gemini

2001-05-11 Thread Eric J. Schwertfeger
On Fri, 11 May 2001, Kevin McBrearty wrote: I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very

Problem getting INNOBASE (3.23.37) working on FreeBSD (4.2)

2001-05-10 Thread Eric J. Schwertfeger
I'm trying to get INNOBASE tables working with MySQL on FreeBSD and I've run into something unusual. Basically, when I create a table with type = innobase then do a stat on the table, it returns a table type of MyISAM. I've verified that this is what the table really is by looking for the

Re: Problem getting INNOBASE (3.23.37) working on FreeBSD (4.2)

2001-05-10 Thread Eric J. Schwertfeger
On Thu, 10 May 2001, Jeremy Zawodny wrote: On Thu, May 10, 2001 at 11:29:06AM -0700, Eric J. Schwertfeger wrote: I'm trying to get INNOBASE tables working with MySQL on FreeBSD and I've run into something unusual. Basically, when I create a table with type = innobase then do

Re: Problem getting INNOBASE (3.23.37) working on FreeBSD (4.2)

2001-05-10 Thread Eric J. Schwertfeger
On Thu, 10 May 2001, Dan Nelson wrote: The first two are as expected, the third isn't. However, this is with a mysqld that was configured with --with-innobase. So why is have_innodb=NO? The name of the option changed in 3.23.37. Use --with-innodb instead. Never trust printed