Re: [ANN] PBXT 1.5.02 Beta Released!

2010-07-16 Thread Paul McCullagh
list, or do I just have to spambrand all senders ? Some weeks it feels as if there's more productspamming than posting going on. On Fri, Jul 16, 2010 at 4:25 PM, Paul McCullagh >wrote: Hi All, I have just released PBXT 1.5.02 Beta. This version adds a 2nd level (SSD based) cac

[ANN] PBXT 1.5.02 Beta Released!

2010-07-16 Thread Paul McCullagh
reported here: https://bugs.launchpad.net/pbxt. If you have any questions or comments, please let me know. Best regards, Paul -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com -- MySQL General Mailing List For list archives: http

[ANN] PBXT 1.0.11 Pre-GA Released!

2010-05-12 Thread Paul McCullagh
org/wiki/Main_Page) to provide the service level you require. Best regards, Paul -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: how things get messed up

2010-02-16 Thread Paul McCullagh
Just like to mention that http://www.blobstreaming.org was created to solve this problem in MySQL. The Launchpad project is here: https://launchpad.net/pbxt On Feb 16, 2010, at 3:23 PM, Johan De Meersman wrote: On Mon, Feb 15, 2010 at 10:53 AM, Martijn Tonies wrote: databases are made

[ANN] PBXT 1.0.10 RC4 Released

2009-12-31 Thread Paul McCullagh
Hi All! I have just released PBXT 1.0.10 RC4. The major feature of this release is the implementation of the pbxt_flush_log_at_trx_commit system variable. This variable allows a trade off between the durability of most recently written transactions, and overall update speed of the engine.

[ANN] PBXT 1.0.09 RC3 Released

2009-09-11 Thread Paul McCullagh
-discuss. I look forward to hearing from you! :) Best regards, Paul -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

[ANN] PBXT 1.0.08 RC2 Released!

2009-06-30 Thread Paul McCullagh
-- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: InnoDB deadlocks

2009-03-09 Thread Paul McCullagh
deadlocking problems with them before. All "good" reasons not to serialize all transactions, and therefore a good reason to use the method that continues to support deadlock detection. Best regards, Paul -- Paul McCullagh PrimeBase Technologies www.primebase.org www.bl

[ANN] PBXT 1.0.07 RC Released!

2008-12-18 Thread Paul McCullagh
tried out the engine yet, please do! Best regards, Paul -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL Guru Needed!!

2008-12-12 Thread Paul McCullagh
And you may also try: Ronald Bradford: http://42sql.com Another frequent conference speaker that really knows his stuff! Ask him about mentoring program... On Dec 12, 2008, at 8:21 PM, Ewen Fortune wrote: As an alternative you also have www.percona.com www.pythian.com www.openquery.com.au ww

[ANN] PBXT 1.0.06 Beta Released

2008-11-10 Thread Paul McCullagh
ere: https://code.launchpad.net/ ~drizzle-pbxt/drizzle/pbxt. Please e-mail me if you have any questions or if you need help with PBXT. Bugs reports can be submitted on Launchpad: https://bugs.launchpad.net/pbxt . Best regards, Paul -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstr

Re: [ANN] PBXT Beta Version Released!

2008-09-03 Thread Paul McCullagh
This functionality is provided by the "BLOB Streaming" engine from: www.blobstreaming.org . Best regards, Paul On Sep 2, 2008, at 9:12 PM, mos wrote: Paul McCullagh, What's the advantage of using PBXT over InnoDb or the new Falcon transactional engine? TIA Mike Hi A

[ANN] PBXT Beta Version Released!

2008-09-02 Thread Paul McCullagh
was a source of some mistakes when building the plugin, so I think it is really cool! My thanks to all who have tested PBXT so far. If you haven't tried out the engine yet, please do! Let me know if you have any comments or questions, I'll be glad to help. Best regards, Paul

[ANN] PBXT 1.0.04 Alpha has just been released

2008-08-03 Thread Paul McCullagh
Hi All, I have just released PrimeBase XT (PBXT) 1.0.04 Alpha and it is available for download from http://www.primebase.org/download. For this release I have concentrated on performance as I explained in my blog post: http://pbxt.blogspot.com/2008/08/new-pbxt-release-1004-improves.html .

[ANN] PBXT 1.0.03 Alpha has just been released

2008-06-04 Thread Paul McCullagh
Hi All, I have released PrimeBase XT (PBXT) 1.0.03 Alpha and it is available for download from http://www.primebase.org/download. I have also posted binary plugins for a few platforms, in particular: 32-bit and 64-bit Linux and Mac OS X (x86). These plugins can be loaded at runtime by the

Re: A question about index

2008-05-20 Thread Paul McCullagh
On May 21, 2008, at 8:46 AM, Paul McCullagh wrote: On May 21, 2008, at 8:09 AM, Moon's Father wrote: Now I want to know which way you use to create index of a table. 1、ix_u (item_id,item_count) ix_item_count (item_count) This makes sense if you have queries which search "i

Re: A question about index

2008-05-20 Thread Paul McCullagh
On May 21, 2008, at 8:09 AM, Moon's Father wrote: Now I want to know which way you use to create index of a table. 1、ix_u (item_id,item_count) ix_item_count (item_count) This makes sense if you have queries which search "item_id AND item_count", and queries which just search the column

Re: [ANN] PBXT storage engine version 1.0-Alpha released

2008-03-18 Thread Paul McCullagh
Yes, definitely. Previous versions of PBXT built on Windows, so there can't be much work to get it going. But I don't think I will get around to firing up my Windows VM until after the conference... On Mar 18, 2008, at 8:30 AM, Sebastian Mendel wrote: Paul McCullagh schrieb:

Re: [ANN] PBXT storage engine version 1.0-Alpha released

2008-03-17 Thread Paul McCullagh
a publicly available bugs database? Yes, on sourceforge.net: http://sourceforge.net/projects/pbxt Go to the Tracker menu, and then select Bugs. Here is the direct link: http://sourceforge.net/tracker/?group_id=180250&atid=892419 Kind regards, Paul Cheers Giuseppe Paul McCullagh wrote: Hi Al

[ANN] PBXT storage engine version 1.0-Alpha released

2008-03-14 Thread Paul McCullagh
have is an option to relax durability. The transaction log is always flushed on commit. A system variable to control the writing/flushing behavior of PBXT will be added to the next release. Don't forget to look me up at the conference! Best regards, Paul McCullagh -- MySQL General

Re: Determining Table Storage Engine Type on Crashed Table

2007-11-23 Thread Paul McCullagh
Maybe this will work: SHOW CREATE TABLE table_name; On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote: Hey everybody, Hopefully some of you are already enjoying time off. I am not...yet :) Anyway, is there a way to determine what storage engine a table is using if it's crashed? When

Re: a scheme for the future mysql-protocol, Re: [ANN] New PBXT/MyBS release enables JDBC-based BLOB streaming!

2007-10-22 Thread Paul McCullagh
Oct 2007, at 04:35, Paul McCullagh wrote: For this release I have completed changes to the MySQL Connector/J 5.0.7, to allow BLOB data to be transparently stored and retrieved from the MyBS BLOB repository. The new version of the driver is called MySQL Connector/J SE (streaming enabled

Re: Reply-to is to originator rather than to list

2007-10-22 Thread Paul McCullagh
Hi Rob, I agree this is a problem for one major reason: I never know, if someone replies to my post, without the CC to the list, whether the writer wants to take the conversation off the list, or if he just hit reply (instead of reply-to-all) out of habit. If the default is to reply to the

[ANN] New PBXT/MyBS release enables JDBC-based BLOB streaming!

2007-10-19 Thread Paul McCullagh
Hi All, I have just released PBXT 0.9.90 and MyBS version 0.5.03. PBXT is a transactional storage engine for MySQL (http://www.primebase.com/xt), and MyBS is a storage engine that enables streaming of BLOB data directly in and out of a MySQL database (http://www.blobstreaming.org) . For t

[ANN] BLOB streaming engine (MyBS), version 0.5 Alpha released

2007-07-27 Thread Paul McCullagh
n for more information and examples of use: http://www.blobstreaming.org/documentation. Best regards, Paul Paul McCullagh SNAP Innovation GmbH http://www.blobstreaming.org http://pbxt.blogspot.com http://www.primebase.com/xt -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Blob data

2007-06-27 Thread Paul McCullagh
nent is added to the BLOB references returned in the rowset. Security of the BLOB streaming stuff is one of the major issues, so further comments, questions and ideas are welcome! Best regards, Paul On Jun 26, 2007, at 4:36 PM, Ann W. Harrison wrote: Paul McCullagh wrote: It will also

Re: Blob data

2007-06-26 Thread Paul McCullagh
Hi Konstantin, On Jun 26, 2007, at 1:37 PM, Konstantin Osipov wrote: * Paul McCullagh <[EMAIL PROTECTED]> [07/06/26 15:35]: I am about to release the first version of the BLOB Streaming engine. We are not that far yet (obviously), but our aim is to create an open platform which w

[ANN] First release of the BLOB Streaming engine for MySQL

2007-06-26 Thread Paul McCullagh
be to enable the uploading of BLOBs using the HTTP PUT method, and the implementation of basic security. Best regards, Paul Paul McCullagh SNAP Innovation GmbH http://www.blobstreaming.org http://pbxt.blogspot.com http://www.primebase.com/xt -- MySQL General Mailing List For list archives: ht

Re: Blob data

2007-06-26 Thread Paul McCullagh
Hi Steve, Some very good points. We are working on a solution for BLOBs in the a MySQL database at www.blobstreaming.org. Any good solution will have to take your comments into account... On Jun 22, 2007, at 9:24 AM, Steve Edberg wrote: At 12:11 PM +0530 6/22/07, Ratheesh K J wrote: Hell

Re: Lock Tables Question

2007-06-05 Thread Paul McCullagh
Hi David, On Jun 5, 2007, at 3:55 PM, David T. Ashley wrote: My only concern with GET_LOCK() is that lock is server-global rather than database-global. This makes attacks possible in a shared setting (some bad person could disable your database code by going after your lock). My solution

Re: Function returns with NOTHING in a particular database

2007-05-08 Thread Paul McCullagh
Hi Zsolt, The problem probably has something to do with an exception that is not handled. Try using a cursor (for example): BEGIN DECLARE done INT DEFAULT 0; declare Akt_keszlet float(5,2) ; DECLARE cur CURSOR FOR SELECT IFNULL( (Select tr_aktualis_keszlet From `termek_raktarhel

Re: advice for blob tables?

2007-04-21 Thread Paul McCullagh
Hi Michael, You are not the only one with this problem. We work in the print/ publishing sector and have many customers that need this type of functionality as well. So this is not going to help you right away, but we have consulted with MySQL and are starting an initiative for the impleme

PBXT 0.9.86 the MySQL Conference 2007 release!

2007-04-09 Thread Paul McCullagh
I will also be taking part in a number of lightning rounds so check out this page for a complete list of my sessions: http://www.mysqlconf.com/cs/mysqluc2007/view/e_spkr/3104 I'm looking forward to seeing you all there! Best regards, Paul Paul McCullagh SNAP Innovation GmbH http://www.p

PBXT 0.9.85 storage engine with support for Windows released

2007-03-16 Thread Paul McCullagh
: http://www.primebase.com/xt/download/pbxt-release.txt Just a reminder: I'll be speaking about PBXT and storage engine development at the MySQL Conference and Expo: http://www.mysqlconf.com/cs/mysqluc2007/view/e_spkr/3104 See you there! :) Best regards, Paul Paul McCullagh

Re: Retrieving foreign keys and references

2007-02-21 Thread Paul McCullagh
Hi Tim, Foreign key definitions are parsed but ignored by MyISAM tables. Try InnoDB or PBXT (http://www.primebase.com/xt) :) On Feb 21, 2007, at 9:35 AM, Tim Johnson wrote: On Wednesday 21 February 2007 17:01, Rolando Edwards wrote: SHOW CREATE TABLE providers\G Hi Rolando: That doesn't do

Binary distribution of the PBXT pluggable Storage Engine now available

2007-02-08 Thread Paul McCullagh
/download/plugin-readme.txt Best regards, Paul Paul McCullagh SNAP Innovation GmbH www.primebase.com/xt pbxt.blogspot.com sourceforge.net/projects/pbxt PrimeBase XT (PBXT) is a transactional storage engine for MySQL which can be loaded dynamically by the pluggable storage engine API of MySQL 5.1

PBXT Storage Engine 0.9.8 with Referential Integrity released

2007-01-31 Thread Paul McCullagh
le shortly. Best regards, Paul Paul McCullagh SNAP Innovation GmbH www.primebase.com/xt pbxt.blogspot.com sourceforge.net/projects/pbxt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

PBXT 0.9.73 Storage Engine for MySQL 5.1.12 Beta released

2006-11-03 Thread Paul McCullagh
and test the pluggable engine. Best regards, Paul McCullagh SNAP Innovation GmbH (*) MVCC - Multi-version concurrency control 6 Steps to build and test PBXT for MySQL 5.1.12 --- This description assumes the following: * The user's name is &#

Re: MyISAM vs InnoDB

2006-11-01 Thread Paul McCullagh
On Nov 1, 2006, at 12:56 PM, Leandro Guimarães Faria Corcete DUTRA wrote: Em Tue, 31 Oct 2006 15:24:44 -0500, Francis escreveu: MyISAM vs InnoDB ? What is the best to use Always use a DBMS, and MySQL is no (proper) DBMS without a transactional backend. There are InnoDB, which is not co

Re: Performance of different length/size datatypes

2006-10-31 Thread Paul McCullagh
Just wondering: this link seems to refer to Firebird/InterBase, not MySQL. In particular, MySQL stores Blobs "in row", the text describes the "out of row" storage of Blobs. As a result, I don't think there is much difference in the performance of BLOB and VARCHAR(255) in MySQL (VARCHAR is

[ANN] Beta version of the PBXT storage engine has been released

2006-10-04 Thread Paul McCullagh
://www.primebase.com/xt For more details and news, please checkout my blog: http:// pbxt.blogspot.com Best regards, Paul McCullagh SNAP Innovation GmbH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: South American timber products.

2006-09-14 Thread Paul McCullagh
?!:( A license to SPAM: On Sep 12, 2006, at 4:57 AM, Agrapin S.A. - Timber Industry and Trading wrote: This message is in full compliance with U.S. Federal requirements for commercial email under bill S.1618 Title lll, Section 301, Paragraph (a)(2)(C) passed by the 105th U.S. Congress and

Re: Unicode

2006-09-11 Thread Paul McCullagh
Hi Charlie, The performance problem may be due to using UTF-8 instead of unicode. Try declaring your text column as: my_text VARCHAR(...) UNICODE I am guessing, but it may be that the search is slow because MySQL has to convert UTF-8 to UNICODE before doing the comparison. BTW, don't use

Re: Shell

2006-09-09 Thread Paul McCullagh
Hi Steve, You have to edit a file called ".tcshrc" which resides in your users home directory, and add ":/usr/local/mysql/bin" to the PATH environment variable. The tricky part is, this file is not visible to any text editor (for example BBEdit), so I always use a command line editor, for

Re: problem with InnoDB

2006-09-07 Thread Paul McCullagh
On Sep 7, 2006, at 3:32 PM, <[EMAIL PROTECTED]> wrote: I need to know the number of rows that a query will return before actually executing the query. So I am sending select count(*) before sending select *. Actually I need to reject queries if the number of records that it will return is huge,

Re: table sizes, rolling data.

2006-08-30 Thread Paul McCullagh
If you use an auto_increment column (e.g. id int auto_increment) then your trigger could do something like this: DELETE FROM table WHERE id < new.id - 100; On Aug 30, 2006, at 3:49 PM, Dan Buettner wrote: You could accomplish this with a trigger on the table - on INSERT, execute a DELETE st

Re: mysql naming convention

2006-08-11 Thread Paul McCullagh
On Aug 11, 2006, at 6:00 PM, James Harvard wrote: FWIW a couple of weeks ago I read of a good reason not to use uppercase letters in table column names. I can't remember what it was now, but it seemed like sense at the time! My personal preference is to always use lowercase and separate any w

Re: question about the query against to the federated engine tables

2006-08-09 Thread Paul McCullagh
As a storage engine, federated does not have the information as to exactly which columns have been selected. This information is simply not passed down to the engine. However, if there is index support for a query then MySQL will indicate to the engine if it is only interested in the columns o

PBXT version 0.9.6 has been released

2006-08-08 Thread Paul McCullagh
4.1.16 and runs on Mac OS X and Linux. Any questions, comments and bug reports can be sent directly to me. Thanks for your support! Best regards, Paul McCullagh SNAP Innovation GmbH PBXT Release Notes == --- 0.9.6 - 2006-08-05 RN35: NOTE: This version is incompatible

Re: PBXT version 0.9.5 has been released

2006-07-07 Thread Paul McCullagh
Hi DÆVID, Thanks for your feedback. What version of IE are you using? You got a point about the style. I'll look into it... Please reply to me directly, or write to [EMAIL PROTECTED] Thanks, Paul On Jul 6, 2006, at 9:17 PM, Daevid Vincent wrote: Your site has a bunch of JS errors (using IE)

PBXT version 0.9.5 has been released

2006-07-05 Thread Paul McCullagh
directly to me. Thanks for your support! Best regards, Paul McCullagh SNAP Innovation GmbH PBXT Release Notes == --- 0.9.5 - 2006-07-03 RN15: This version concludes the re-structuring of the PBXT implementation. I have made a number of major changes, including: - All