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 t

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 vers

Adding functions

2001-10-25 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 huma

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 t

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

2001-08-16 Thread Eric J. Schwertfeger
I've got a part of a complex system that isn't behaving as expected. I've got one perl program running with autocommit off that creates entries in a table and commits the changes. At some point, the rows have their state field changed from 'active' to 'closed', and these changes are then commit

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 v

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

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,

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 app