Re: MYSQL Database

2004-01-20 Thread Sam Vilain
Jochem > > -- > I don't get it > immigrants don't work > and steal our jobs > - Loesje > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql

Re: MySQL GPL License Question

2004-01-14 Thread Sam Vilain
avoiding the SQL server - then you would need to purchase a commercial license from MySQL AB to avoid the requirement for the derived work to be covered by the GPL. -- Sam Vilain, [EMAIL PROTECTED] It is better to be violent, if there is violence in our hearts, than to put on the cloak of nonviolence to

Re: VARCHAR 255 versus TINYTEXT

2004-01-12 Thread Sam Vilain
w-like object, that requires another access to the tablespace to retrieve. Based on this possibly rash assumption, it would seem that it is a good idea to use a TINYTEXT if you have a column which is usually not selected, if you are scanning the entire table (via unindexed columns) a lot. -- Sam

Re: Deciding whether to convert to InnoDB

2004-01-05 Thread Sam Vilain
Mysql runs at 100% pretty > much constantly. > > Now would InnoDB help in this situation? Would it allow us to increase > the thread count to push more through in a shorter amount of time > (because the tables wouldn't be locking)? > > And if s

Re: Binary Log replay utility?

2004-01-04 Thread Sam Vilain
No-one out there doing step-by-step replay of binary logs ? On Tue, 30 Dec 2003 17:52, Sam Vilain wrote; > Hi there, > > Is there a utility out there to do transaction-at-a-time view and/or > replay with MySQL's binary log ? Primarily for audit / debug > purpose

Binary Log replay utility?

2003-12-29 Thread Sam Vilain
Hi there, Is there a utility out there to do transaction-at-a-time view and/or replay with MySQL's binary log ? Primarily for audit / debug purposes. I'm only interested in using it with the proper database back-end, not ISAM. -- Sam Vilain, [EMAIL PROTECTED] In married life

Profiling? Fair I/O Scheduling?

2001-09-26 Thread Sam Vilain
plex queries, but finding out which ones are hitting the database the hardest is not simple. Any ideas? Has anyone else run into this before? -- Sam Vilain, [EMAIL PROTECTED] Easyspace: an accredited ICANN GPG: http://sam.vilain.net/sam.ascregistrar & web hosting company 7D7