MySQL Magazine Fall Issue -- Call for Articles

Hey everyone, it is that time again. The next issue of the magazine should be released on October the 15th. It’s time to start sending in those ideas for articles. Articles have to be done by the end of this month so don’t delay. Remember, you too can become rich and famous by writing for MySQL

MySQL University session on September 4: Building MySQL Client Applications

Hi, this Thursday, Hartmut Holzgraefe will give a MySQL University session: http://forge.mysql.com/wiki/Building_MySQL_Client_Applications (topic: Building MySQL Client Applications) Please register for this session by filling in your name on the session Wiki page. Registering is not required

Re: Impossible WHERE in explain

Thanks a lot. I got the answer. Impossible where in explian comes when the query doesn't make any sense to the mysql optimizer. Please visit the link below for more details.

[ANN] PBXT Beta Version Released!

Hi All! I am pleased to announce that the Beta version of PBXT has just been released. PBXT is a fast, lightweight, transactional storage engine for MySQL. More information is available at http://www.primebase.org. You can download the source code at http://www.primebase.org/download. I

Re: [ANN] PBXT Beta Version Released!

Paul McCullagh, What's the advantage of using PBXT over InnoDb or the new Falcon transactional engine? TIA Mike Hi All! I am pleased to announce that the Beta version of PBXT has just been released. PBXT is a fast, lightweight, transactional storage engine for MySQL. More information

question about the mysql prepare/execute commands

I have a question about the prepare/execute commands provided by mysql. I devised a benchmark, comparing updating a table using a statement-at-a-time versus using a prepare/execute pair. The table had a million rows. The statement-at-a-time file looked like: reset query cache; update company

mysql_install_db calls mysqld, which hangs (MySQL 6.0.6 under FreeBSD 7.0-STABLE)

Hi, this is my first time installing the MySQL server. I have built and installed the databases/mysql60-server via the FreeBSD ports system (using default configuration options). But let me discuss my installation procedure, adopted from the manual: The mysql group and user are already added by

Re: question about the mysql prepare/execute commands

To hazard a guess here: the mysql console typically starts up in autocommit mode. The neccesity of commiting after each statement/execution could be costing you some cycles. What is the table type of your test data? I would not expect transactions in MyISAM would give you any beifit but under

Single Sign On

Does mysql support Kerberos/GSSAPI authentication? If not, is there plans for it to support it? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Really bad situation

The setup: Slackware 11 server running MySQL version 5.0.24a. Data tables are InnoDB. Mostly used by a Tomcat server on the same 10.10.10.x network. Firewall and port forwarding are managed by GuardDog and GuideDog. The outside world has no direct access to the server and can not present

Re: question about the mysql prepare/execute commands

the table is myisam, so anything having to do with transactions won't have any effect. On Tue, Sep 2, 2008 at 4:54 PM, Michael Dykman [EMAIL PROTECTED] wrote: To hazard a guess here: the mysql console typically starts up in autocommit mode. The neccesity of commiting after each