To find a list of tables in a schema:

$ sqlcli -u TEST,TEST -d SYNCMANA "SELECT * FROM TABLES WHERE SCHEMANAME = 'TEST'"

To find a list of triggers on a table:

$ sqlcli -u DBSERVICE,SECRET -d SYNCMANA "SELECT * FROM TRIGGERS WHERE TABLENAME = 'T'"

To describe a table’s structure:

$ cat me && echo "-----" && 
   loadercli -d SYNCMANA -u TEST,TEST -b ./me && echo "-----" && 
   cat tabledef.txt
dataextract for dataload table T
outstream file 'tabledef.txt'
outstream file 'idontcare'

-----
Loader protocol: '/home/cjcollier/.sdb/loader/log/loader.prt'
Loader packages: '/home/cjcollier/sdb/loader/packages'

User TEST connected to database SYNCMANA schema TEST on local host.
dataextract for dataload table T
outstream file 'tabledef.txt'
outstream file 'idontcare'
Successfully executed

-----
//
CREATE TABLE "T"
(
        "I"  Integer  NOT NULL,
        "C"  Varchar (32) UNICODE,
        PRIMARY KEY ("I")
)
 NO …

Slides from my presentations at the PHP Québec Conference are below:

• Copyright, Contracts and Licenses for PHP Developers (PDF, 650KiB)
• SQLite: A fast, transactional DBMS embedded in PHP 5 (PDF, 55KiB)

I will make the audio of the licensing session, along with a transcript, available as soon as possible.

Update:

Transcript now available.

…

... from Andrew that he doesn't find the time to maintain mysqldevelopment.com any longer and write MySQL related blog articles :-(.

It would be too bad to let mysqldevelopment.com die, so I hope that there's a way to keep it alive in some form or another. I know that it's a huge amount of work for a single person to keep such a site up to date, so maybe there's a way to integrate the content into MySQL Forge or to create a Wiki to make it easy to anybody who just has something interesting to contribute it. I would also integrate it into the db4free.net project, if there's no other way. Any rescue is better than letting it …

and doesn’t seem to take it too nicely :-(

I decided to install the mysql beta on my laptop (Mac Intel @2G ram and 2GHZdual core) and my sunfire (@8G ram and 16 1GHZ Ultrasparcs).

(I have it installed on a x86-64 box as well, but that machine is busy at the moment)..

so for a quick sanity check I ran mysqlslap to see how it performs.

I chose to simulate a 20 concurrent users

sunfire$ mysqlslap -psunfire -c 20 -i 20
Benchmark
        Average number of seconds to run all queries: 1.714 seconds
        Minimum number of seconds to run all queries: 0.941 seconds
        Maximum number of seconds to run all queries: 2.539 seconds
        Number of clients running queries: 20
        Average number of queries per client: 0

vs

laptop$ mysqlslap -i 20 -c 20
Benchmark
        Average number of seconds to run all queries: 1.201 seconds
        Minimum number of seconds to run all queries: 1.072 …

I have been blogging since last June (is it really that long) and www.mysqldevelopment.com has been going for over a year now. But as the frequency of posts on this blog and updates on the site will testify recently I just haven't had the time I used to have with regards to MySQL. One of the good and bad things with the web is that it's relatively cheap to just leave stuff hanging around where in traditional media, books for example, the costs of continual production mean things go out of print never to be seen again. This means that the web is full of sites and pages which are left untouched for months or years. Most of the time that isn't a problem but often, especially with IT related sites the information can be way off the mark.

It's with that in mind that as from 1st May 2006 www.mysqldevelopment will no longer exist and this will be my last MySQL related blog entry. I no longer have the time or energy to commit to it and with …

Once we've issued the command start slave;, The Replication should ideally start, But as well all know nothing works initially. So to check everything is working, issue the following command.

mysql> show slave status\G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 192.168.5.99
                Master_User: repl
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.000009
        Read_Master_Log_Pos: 37822065
             Relay_Log_File: ruturaj-vartak-relay-bin.000028
              Relay_Log_Pos: 37822202
      Relay_Master_Log_File: mysql-bin.000009
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB: test
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: …

Once we've issued the command start slave;, The Replication should ideally start, But as well all know nothing works initially. So to check everything is working, issue the following command.

mysql> show slave status\G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 192.168.5.99
                Master_User: repl
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.000009
        Read_Master_Log_Pos: 37822065
             Relay_Log_File: ruturaj-vartak-relay-bin.000028
              Relay_Log_Pos: 37822202
      Relay_Master_Log_File: mysql-bin.000009
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB: test
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: …

MySQL Users Conference 2006 - April 24-27, 2006 - Santa Clara, CA

I’m presenting “MySQL Cluster: New Features and Enhancements”. It’s going to be a riot. Lots of sexy new stuff to go on about. I’ll also be running a Cluster BoF and am really looking forward to chatting to people about Cluster and what we can do to make it better for our users.

So come along and talk to me while I’m there.

I’ll be sure to use the word “thongs” in the Australian sense as much as possible.

So come along, or I’ll be forced to ask “Where the bloody hell are ya?“

MemberDB - A Membership Database

I released 0.4 today. A rather long awaited release. No doubt there’ll be bugs and the need for a 0.4.1 or something - but this is relatively bug free and has a bunch of new cool stuff to chew on.

It’s also the first real release to support MySQL 5.0 (previous releases won’t work as MemberDB heavily uses views).

So, I didn't get to meet Oracle's Monica, mainly because she kinda vanished. I had my own talk after hers, and when I went downstairs to the exhibition she was already gone. The Oracle booth had a few people manning it, but not much crowd.

Same for the Sybase stand, actually. They had a video running, explaining how they'd been the first database doing this and that.... not sure how much that actually impresses people, pointing to the glorious past.

MySQL didn't have its own booth this time, but I toured round Tuesday and Wednesday, met many interesting people and was introduced to even more. I found that MySQL truly has a lot of friends, both big and small. And apart from our big partners (HP, Novell, Red Hat, IBM), many if not most of the smaller booths were actually companies who deploy their solutions on MySQL. That was a nice surprise! …