View Git repositories
branches with status:
Name Status Last Modified Last Commit
lp:libeatmydata Mature 2014-10-29 23:02:34 UTC 2014-10-29
105. tag version 105

Author: Stewart Smith
Revision Date: 2014-10-29 23:02:34 UTC

tag version 105

lp:~stewart/percona-server/5.5-updatepam (Has a merge proposal) Development 2013-12-23 22:10:06 UTC 2013-12-23 This branch is empty.
lp:~stewart/percona-server/5.6-updatepam (Has a merge proposal) Development 2013-12-23 22:09:13 UTC 2013-12-23 This branch is empty.
lp:~stewart/percona-pam-for-mysql/libpsclient-doc (Has a merge proposal) Development 2013-12-23 21:55:43 UTC 2013-12-23
36. update documentation to mention libpe...

Author: Stewart Smith
Revision Date: 2013-12-23 21:54:02 UTC

update documentation to mention libperconaserverclient alongside libmysqlclient

lp:~stewart/percona-playback/playback-log Development 2013-10-15 02:39:20 UTC 2013-10-15
197. initial playback log plugin

Author: Stewart Smith
Revision Date: 2013-10-07 23:51:13 UTC

initial playback log plugin

lp:~stewart/bzr-fastimport/misc-fixes-for-git-import Development 2013-10-04 22:42:14 UTC 2013-10-04
358. misc fast-export fixes

Author: Stewart Smith
Revision Date: 2013-10-04 22:40:26 UTC

misc fast-export fixes

lp:~stewart/percona-xtrabackup/bug1213036 bug Development 2013-08-16 17:54:06 UTC 2013-08-16
637. improve execution speed of ib_increme...

Author: Stewart Smith
Revision Date: 2013-08-16 17:53:20 UTC

improve execution speed of ib_incremental tests by switching from forking thousands of mysql client executables to generating the SQL and feeding it to 1 mysql client process. On my laptop this takes t/ib_incremental_full_scan.sh execution time from 43-48 seconds down to <30 seconds.

lp:~stewart/percona-xtrabackup/test-combinations (Has a merge proposal) Development 2013-06-20 08:18:40 UTC 2013-06-20
623. remove incorrect free of servers.path...

Author: Stewart Smith
Revision Date: 2013-06-20 08:18:40 UTC

remove incorrect free of servers.path in testrun.c

lp:~stewart/percona-server/bug1168032 bug(Has a merge proposal) Development 2013-04-23 00:24:25 UTC 2013-04-23
508. we weren't detecting if we should res...

Author: Stewart Smith
Revision Date: 2013-04-23 00:21:15 UTC

we weren't detecting if we should restart the server on upgrade correctly. While we were correctly not re-initing the test database and data dir, we were also not restarting the server after upgrade, leaving nothing running :(. Thanks to David Six at PLMCE for walking through this.

lp:~stewart/dbd-drizzle/fixup-for-modern-perl (Has a merge proposal) Development 2013-03-21 02:45:50 UTC 2013-03-21
44. fix up building with more modern perl

Author: Stewart Smith
Revision Date: 2013-03-21 02:45:27 UTC

fix up building with more modern perl

lp:~stewart/drizzle/wiredtiger Development 2013-02-19 11:43:11 UTC 2013-02-19
2627. basic CREATE TABLE code for WiredTige...

Author: Stewart Smith
Revision Date: 2013-02-19 11:43:11 UTC

basic CREATE TABLE code for WiredTiger. We're not yet taking into account any of the details of the DDL submitted, just the table name. We manually test taht the table was created with 'wt list' command

lp:~stewart/drizzle/old-haildb Development 2013-02-15 01:25:49 UTC 2013-02-15
2376. merge lp:~brianaker/drizzle/lion-disa...

Author: Mark Atwood
Revision Date: 2011-07-30 02:54:01 UTC

merge lp:~brianaker/drizzle/lion-disable-dtrace

lp:~stewart/percona-xtrabackup/die-Die Development 2013-02-08 05:27:47 UTC 2013-02-08
488. clean up Die

Author: Stewart Smith
Revision Date: 2013-02-08 05:27:17 UTC

clean up Die

lp:~stewart/percona-playback/cppcheck-fixes Development 2012-11-30 01:28:39 UTC 2012-11-30
174. fix several cppcheck found bugs in te...

Author: Stewart Smith
Revision Date: 2012-11-30 01:26:31 UTC

fix several cppcheck found bugs in test suite: assert statement modifies n_log_entries (i.e. we were not actually checking the result of our test case properly)

lp:~stewart/percona-playback/c-notice-fix Development 2012-11-29 23:44:38 UTC 2012-11-29 This branch has not been pushed to yet.
lp:~stewart/percona-xtrabackup/2.0-basic-tests (Has a merge proposal) Development 2012-11-14 00:28:14 UTC 2012-11-14
477. add some basic tests of xtrabackup al...

Author: Stewart Smith
Revision Date: 2012-11-14 00:27:40 UTC

add some basic tests of xtrabackup alongside some commonly used innodb server options. Also do some basic incremental tests with some server options. This is a starting point for further, more exhaustive testing of XB and server options combinations

lp:~stewart/percona-xtrabackup/2.0-bug1077800 (Has a merge proposal) Development 2012-11-12 05:06:44 UTC 2012-11-12 This branch is empty.
lp:rsws Development 2012-11-10 04:14:55 UTC 2012-11-10
1. initial

Author: Stewart Smith
Revision Date: 2012-11-09 08:08:56 UTC

initial

lp:~stewart/gypsy/gypsy (Has a merge proposal) Development 2012-11-07 01:05:09 UTC 2012-11-07
38. a whole bunch of thwacking to get it ...

Author: Stewart Smith
Revision Date: 2012-11-07 01:04:38 UTC

a whole bunch of thwacking to get it to compile on Ubuntu 12.04

lp:~stewart/percona-server/5.5-merge-scripts Development 2012-10-30 04:25:13 UTC 2012-10-30
316. staging

Author: Stewart Smith
Revision Date: 2012-10-30 04:25:13 UTC

staging

lp:~stewart/percona-xtrabackup/1.6-parallel-test-suite-POC Development 2012-10-19 08:36:02 UTC 2012-10-19
352. and wait

Author: Stewart Smith
Revision Date: 2012-10-19 08:36:02 UTC

and wait

lp:~stewart/percona-server/5.6-slow-query-plugin-prototype Development 2012-09-21 04:58:42 UTC 2012-09-21
306. Prototype slow query log audit plugin...

Author: Stewart Smith
Revision Date: 2012-09-21 03:54:12 UTC

Prototype slow query log audit plugin.

This plugin (named extended_slow_query_log) implements the MySQL
Slow Query log.

The built-in slow query log holds LOCK_log for an awfully long time, and
I thought I could do it better.

This plugin uses a lock-free algorithm to write to the log file: call write(2)
with the complete log entry and let the OS kernel take care of the rest.
While this MAY not work for NFS (at least certain versions), this will work
for the most common case of local disk.

I had to extend the plugin API slightly to get all the same information as
the MySQL slow query log.

The main challenge is log file rotation, as if you just close(2) a file
descriptor that others may be write(2)ing to then bad things may happen
(namely that the file descriptor gets reused for something else.. say an
innodb data file, and writing part of your slow query log as an innodb
page will not end in hugs and puppies).

My solution to log file rotation is to basically count how many people
may be using it and waiting until this drops to zero before closing the
file descriptor. This avoids taking any locks around calling write(),
which is the most time consuming part of writing the log.

I know of one more possible improvement to this: reduce the number of
malloc() calls (we should be able to cache this for each thd).

I ran two benchmarks on my laptop (Intel(R) Core(TM) i7-2620M CPU @
2.70GHz) - 2 cores, 4 threads total.

1) Using existing slow query log code

eatmydata ./mysql-test-run.pl --start-and-exit --mysqld=--slow-query-log \
--mysqld=--long-query-time=0

../client/mysqlslap -u root test -S var/tmp/mysqld.1.sock -q 'select 1;'
--number-of-queries=1000000 --concurrency=64 --create-schema=test
Benchmark
 Average number of seconds to run all queries: 18.293 seconds
 Minimum number of seconds to run all queries: 18.293 seconds
 Maximum number of seconds to run all queries: 18.293 seconds
 Number of clients running queries: 64
 Average number of queries per client: 15625

2) Using my audit plugin
eatmydata ./mysql-test-run.pl extended_slow_query_log --start-and-exit

mysql> INSTALL PLUGIN extended_slow_query_log SONAME
'extended_slow_query_log.so';
Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL extended_slow_query_log_enable=1;
Query OK, 0 rows affected (0.00 sec)

../client/mysqlslap -u root test -S var/tmp/mysqld.1.sock -q 'select 1;'
--number-of-queries=1000000 --concurrency=64 --create-schema=test
Benchmark
 Average number of seconds to run all queries: 15.812 seconds
 Minimum number of seconds to run all queries: 15.812 seconds
 Maximum number of seconds to run all queries: 15.812 seconds
 Number of clients running queries: 64
 Average number of queries per client: 15625

(these numbers have been pretty stable over sevaral runs)

 and a third, without any slow query log enabled:

 ./client/mysqlslap -u root test -S var/tmp/mysqld.1.sock -q 'select 1;'
 --number-of-queries=1000000 --concurrency=64 --create-schema=test
 Benchmark
  Average number of seconds to run all queries: 13.006 seconds
  Minimum number of seconds to run all queries: 13.006 seconds
  Maximum number of seconds to run all queries: 13.006 seconds
  Number of clients running queries: 64
  Average number of queries per client: 15625

lp:~stewart/percona-xtrabackup/bug1053747 (Has a merge proposal) Development 2012-09-21 00:43:32 UTC 2012-09-21 This branch is empty.
lp:~stewart/percona-server/bug1017192 (Has a merge proposal) Development 2012-09-02 22:27:57 UTC 2012-09-02
293. Fix bug lp:1017192 Server crashes in ...

Author: Stewart Smith
Revision Date: 2012-09-02 22:26:25 UTC

Fix bug lp:1017192 Server crashes in add_identifier on concurrent ALTER TABLE and SHOW ENGINE INNODB STATUS

Fix and test comes from MariaDB: https://mariadb.atlassian.net/browse/MDEV-364

lp:~stewart/percona-server/bug1011047 bug(Has a merge proposal) Development 2012-08-24 04:37:16 UTC 2012-08-24
294. Add a test for server not starting wi...

Author: Stewart Smith
Revision Date: 2012-08-24 04:37:16 UTC

Add a test for server not starting with userstats enabled/plugin installed (bug lp:1011047)

lp:~stewart/percona-xtrabackup/staging-1.6 Development 2012-08-02 04:03:13 UTC 2012-08-02
348. merge fix for Bug #996493: innobackup...

Author: Stewart Smith
Revision Date: 2012-08-02 04:03:13 UTC

merge fix for Bug #996493: innobackupex --apply-log doesn't read config from backup-my.cnf

lp:~stewart/pandora-build/pandora-for-playback (Has a merge proposal) Development 2012-07-04 02:18:39 UTC 2012-07-04
275. fix have_libmysqlcient for when mysql...

Author: Stewart Smith
Revision Date: 2012-07-04 02:11:53 UTC

fix have_libmysqlcient for when mysql_config isn't a full path.

lp:~stewart/percona-server/bug1012488 (Has a merge proposal) Development 2012-06-27 06:57:16 UTC 2012-06-27
275. merge latest PAM plugin sources

Author: Stewart Smith
Revision Date: 2012-06-27 06:56:15 UTC

merge latest PAM plugin sources

lp:~stewart/percona-server/5.1-bug832679 bug Development 2012-06-25 05:39:00 UTC 2012-06-25
448. add test case for bug#832679. A serie...

Author: Stewart Smith
Revision Date: 2012-06-25 05:38:09 UTC

add test case for bug#832679. A series of commands gives InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock()

lp:~stewart/percona-server/bug987737 Development 2012-06-14 06:35:32 UTC 2012-06-14 This branch has not been pushed to yet.
lp:~stewart/drizzle/catalog-in-path-not-chdir (Has a merge proposal) Development 2012-04-20 19:16:14 UTC 2012-04-20
2487. have ahhhfuck.test do the repeat inte...

Author: Stewart Smith
Revision Date: 2012-04-20 19:16:14 UTC

have ahhhfuck.test do the repeat internally, so it just fails.

lp:mythremote Development 2012-03-30 05:03:43 UTC 2012-03-30
8. quickly released: 12.03

Author: Stewart Smith
Revision Date: 2012-03-30 05:03:43 UTC

quickly released: 12.03

lp:~stewart/percona-xtrabackup/drop-remote-host (Linked to a blueprint)(Has a merge proposal) Development 2012-03-09 06:01:24 UTC 2012-03-09
403. remove the (now unused) --sshopt and ...

Author: Stewart Smith
Revision Date: 2012-03-09 05:53:17 UTC

remove the (now unused) --sshopt and --scpopt options to innobackupex. This goes along with the --remote-host removal, all in favor of streaming backups

lp:~stewart/percona-xtrabackup/bug483827 Development 2012-02-13 01:08:52 UTC 2012-02-13
386. merge support for mysqld_multi sectio...

Author: Stewart Smith
Revision Date: 2012-02-10 06:02:48 UTC

merge support for mysqld_multi sections: bug#483827

lp:~stewart/percona-server/5.1.61 Development 2012-02-07 04:30:03 UTC 2012-02-07 This branch has not been pushed to yet.
lp:~stewart/mythremote/quickly_trunk Development 2012-02-05 06:22:39 UTC 2012-02-05
6. quickly released: 12.02

Author: Stewart Smith
Revision Date: 2012-02-05 06:22:30 UTC

quickly released: 12.02

lp:~stewart/drizzle/fix-create-schema-for-catalogs (Has a merge proposal) Development 2012-01-18 04:59:14 UTC 2012-01-18
2495. fix up problem with constant schema i...

Author: Stewart Smith
Revision Date: 2012-01-18 04:59:14 UTC

fix up problem with constant schema identifiers for DATA_DICTIONARY and INFORMATION_SCHEMA that came up on certain compilers choosing orders for static constructor execution.

lp:~stewart/percona-xtrabackup/fix-ubuntu-oneiric-51-debug-build-trunk (Has a merge proposal) Development 2012-01-09 04:49:02 UTC 2012-01-09
367. merge fix for oneiric 5.1 debug build...

Author: Stewart Smith
Revision Date: 2012-01-09 04:48:33 UTC

merge fix for oneiric 5.1 debug builds: disable mysql maintainer mode when building MySQL part of XB

lp:~stewart/percona-xtrabackup/fix-ubuntu-oneiric-51-debug-build (Has a merge proposal) Development 2012-01-09 02:15:34 UTC 2012-01-09
316. disable mysql maintainer mode when ru...

Author: Stewart Smith
Revision Date: 2012-01-09 02:15:09 UTC

disable mysql maintainer mode when running configure for XB MySQL part build. This means we disable -Werror, which is probably what we want for the MySQL part anyway

lp:~stewart/percona-dev-puppet/trunk Development 2012-01-05 22:48:56 UTC 2012-01-05
35. merge adding of libwrap0-dev to debia...

Author: Stewart Smith
Revision Date: 2012-01-05 22:48:56 UTC

merge adding of libwrap0-dev to debian hosts

lp:~stewart/drizzle/schema-identifier-has-catalog (Has a merge proposal) Development 2012-01-05 06:57:17 UTC 2012-01-05
2491. force a identifier::Schema to be cons...

Author: Stewart Smith
Revision Date: 2012-01-05 06:50:30 UTC

force a identifier::Schema to be constructed with a identifier::Catalog. This is close to the final 'big' part for CATALOG support. We also have to modify all around the server that creates identifier::Schema so it does so properly. Since a single Session cannot span schemas, we get off a wee bit easy :) The big limitation in this patch is that INFORMATION_SCHEMA and DATA_DICTIONARY only appear in the LOCAL catalog (and this really needs to be fixed before CATALOGs other than LOCAL are supported).

lp:~stewart/drizzle/tableidentifier-use-catalog-member (Has a merge proposal) Development 2012-01-05 01:03:20 UTC 2012-01-05
2490. use the table identifier and catalog ...

Author: Stewart Smith
Revision Date: 2012-01-05 00:58:48 UTC

use the table identifier and catalog in the identifier in constructing the path in build_table_filename instead of the global drizzled::catalog::local_identifier(). Another step towards full CATALOG support

lp:~stewart/drizzle/tableshare-use-tableidentifier (Has a merge proposal) Development 2012-01-04 22:32:21 UTC 2012-01-04
2489. merge table_identifier unittest fix

Author: Stewart Smith
Revision Date: 2012-01-04 22:32:21 UTC

merge table_identifier unittest fix

lp:~stewart/galera/bug907623 bug(Has a merge proposal) Development 2012-01-04 04:27:23 UTC 2012-01-04
109. Fix test_net_consumer_nto1 and test_n...

Author: Stewart Smith
Revision Date: 2012-01-04 04:23:33 UTC

Fix test_net_consumer_nto1 and test_net_consumer to also bind to port 0 to enable simultaneous test runs on a single machine

lp:~stewart/junk/percona-jenkins Development 2011-12-22 03:48:11 UTC 2011-12-22
9. rename boost_dev to playbackbuild (as...

Author: Stewart Smith
Revision Date: 2011-12-22 03:48:11 UTC

rename boost_dev to playbackbuild (as we do need it for playback... also galera though. Add libssl-dev to requirements for Galera as the boost asio lib needs it

lp:~stewart/percona-server/release-notes-5.5.18-23.0 (Has a merge proposal) Development 2011-12-16 08:32:24 UTC 2011-12-16
200. minor fix to sphinx syntax in 5.5.18 rn

Author: Stewart Smith
Revision Date: 2011-12-16 08:32:05 UTC

minor fix to sphinx syntax in 5.5.18 rn

lp:freddy-query Development 2011-12-05 05:56:24 UTC 2011-12-05
7. add test for checksums of blobs

Author: Stewart Smith
Revision Date: 2011-12-05 05:56:24 UTC

add test for checksums of blobs

lp:~stewart/percona-server/bug758788 bug(Has a merge proposal) Development 2011-12-02 00:25:05 UTC 2011-12-02
416. prepend 'InnoDB: ' to dict_size_limit...

Author: Stewart Smith
Revision Date: 2011-12-02 00:25:05 UTC

prepend 'InnoDB: ' to dict_size_limit warnings

lp:~stewart/percona-server/5.1-mysql-branch Development 2011-11-22 03:12:34 UTC 2011-11-22
398. Import Percona Server patch: bug86091...

Author: Stewart Smith
Revision Date: 2011-11-11 06:55:55 UTC

Import Percona Server patch: bug860910.patch

# name : bug860910.patch
# maintainer : Alexey
#
# Fixes LP bug #860910 / MySQL bug #62557
#

lp:~stewart/pandora-build/tbb (Has a merge proposal) Development 2011-11-16 02:15:51 UTC 2011-11-16
273. add a Intel Threading Building Blocks...

Author: Stewart Smith
Revision Date: 2011-11-16 02:15:34 UTC

add a Intel Threading Building Blocks (TBB) m4 macros

lp:~stewart/drizzle/geoip-functions Development 2011-11-15 07:56:10 UTC 2011-11-15
2461. merge gcc 4.6 build fix

Author: Stewart Smith
Revision Date: 2011-11-15 07:38:57 UTC

merge gcc 4.6 build fix

lp:~stewart/percona-server/5.1-silly-docs Development 2011-10-27 10:03:44 UTC 2011-10-27
327. Added FAQ question on making coffee

Author: Stewart Smith
Revision Date: 2011-10-27 10:02:09 UTC

Added FAQ question on making coffee

lp:~stewart/percona-server/Percona-Server-5.1.54-12-bug814404 bug Development 2011-10-05 01:57:49 UTC 2011-10-05
199. fix source dircetory for handlersock...

Author: Stewart Smith
Revision Date: 2011-10-05 01:57:49 UTC

fix source dircetory for handlersocket and udf build for PS5.1.54

lp:~stewart/percona-server/issue18216 bug Development 2011-10-04 23:32:31 UTC 2011-10-04
234. backport bug 814404 fix to 5.1.57: A...

Author: Stewart Smith
Revision Date: 2011-10-04 23:30:57 UTC

backport bug 814404 fix to 5.1.57: Assertion failure in file handler/ha_innodb.cc line 3825

lp:~stewart/percona-xtrabackup/bug677279-trunk Development 2011-09-20 17:58:44 UTC 2011-09-20
309. merge bug677279 fix

Author: Stewart Smith
Revision Date: 2011-09-20 17:58:13 UTC

merge bug677279 fix

lp:~stewart/percona-server/solaris-5.1 Development 2011-08-15 14:49:14 UTC 2011-08-15
282. use bash for install tests from makefile

Author: Stewart Smith
Revision Date: 2011-08-15 14:49:14 UTC

use bash for install tests from makefile

lp:~stewart/drizzle/use-catalog-for-path-no-pbms Development 2011-07-26 18:29:29 UTC 2011-07-26
2278. merge trunk

Author: Stewart Smith
Revision Date: 2011-07-26 18:29:29 UTC

merge trunk

lp:~stewart/drizzle/bug751191 bug(Has a merge proposal) Development 2011-06-21 06:17:18 UTC 2011-06-21
2344. global g_refresh_version wasn't prote...

Author: Stewart Smith
Revision Date: 2011-06-21 06:15:45 UTC

global g_refresh_version wasn't protected against races. Make it an atomic variable.

lp:~stewart/percona-server/bug693415 bug(Has a merge proposal) Development 2011-06-20 12:19:13 UTC 2011-06-20
123. fix innodb_buffer_pool_shm to try to ...

Author: Stewart Smith
Revision Date: 2011-06-20 12:18:44 UTC

fix innodb_buffer_pool_shm to try to start innodb without shm key so we can then use a mysqltest trick to skip the test if things like sysctl shmmax aren't set appropriately for the test. This is a slightly different fix than in 5.1 (which just puts it in the 'big' test category).

lp:~stewart/drizzle/bzuse-catalog-for-path-no-pbms (Has a merge proposal) Development 2011-06-17 12:13:50 UTC 2011-06-17
2277. add backwards compatibility code in I...

Author: Stewart Smith
Revision Date: 2011-06-17 12:13:50 UTC

add backwards compatibility code in Innobase engine for both opening table and dropping table to, if catalog is 'local', look for table in event of ENOENT in data dict path without LOCAL

lp:~stewart/drizzle/drizzle-libeatmydata Development 2011-05-23 15:08:26 UTC 2011-05-23
2314. remove unneeded libeatmydata files

Author: Stewart Smith
Revision Date: 2011-05-22 09:29:52 UTC

remove unneeded libeatmydata files

lp:~stewart/drizzle/xtrabackup-17-dev (Has a merge proposal) Development 2011-05-22 02:51:19 UTC 2011-05-22
2317. move some xtrabackup sources into cor...

Author: Stewart Smith
Revision Date: 2011-05-22 02:49:12 UTC

move some xtrabackup sources into correct place in subtree

lp:~stewart/drizzle/use-catalog-for-path (Has a merge proposal) Development 2011-04-11 01:02:25 UTC 2011-04-11
2273. remove some debug printouts from the ...

Author: Stewart Smith
Revision Date: 2011-04-11 01:02:25 UTC

remove some debug printouts from the CATALOG work.

lp:~stewart/percona-xtrabackup/xtrabackup-copyright-for-scripts (Has a merge proposal) Development 2011-03-31 06:37:37 UTC 2011-03-31
243. add copyright header to xb_stats.sh test

Author: Stewart Smith
Revision Date: 2011-03-31 06:37:37 UTC

add copyright header to xb_stats.sh test

lp:~stewart/drizzle/multitenant Development 2011-03-20 03:27:44 UTC 2011-03-20
2263. remove the string db_arg only identif...

Author: Stewart Smith
Revision Date: 2011-03-19 16:07:22 UTC

remove the string db_arg only identifier::Schema constructor - force every use of identifier::Schema to supply a Catalog identifier. This means we go change everywhere in the server that creates just about any type of identifier. We get the identifier from Session. This patch still has bugs around various SHOW commands and doesn't fix the keys to hash things to include the catalog name... but this does enable you to cerate two catalogs and have schemas in each and tables in them.

lp:~stewart/+junk/d-mt bug Development 2011-03-19 16:32:12 UTC 2011-03-19
2263. remove the string db_arg only identif...

Author: Stewart Smith
Revision Date: 2011-03-19 16:07:22 UTC

remove the string db_arg only identifier::Schema constructor - force every use of identifier::Schema to supply a Catalog identifier. This means we go change everywhere in the server that creates just about any type of identifier. We get the identifier from Session. This patch still has bugs around various SHOW commands and doesn't fix the keys to hash things to include the catalog name... but this does enable you to cerate two catalogs and have schemas in each and tables in them.

lp:~stewart/drizzle/bug728260 bug(Has a merge proposal) Development 2011-03-03 07:37:39 UTC 2011-03-03
2216. remove the FORCE clause from ALTER TA...

Author: Stewart Smith
Revision Date: 2011-03-03 07:36:08 UTC

remove the FORCE clause from ALTER TABLE. Previously you could do ALTER TABLE t1 FORCE - which ended up doing nothing useful at all. This has done nothing since MySQL 5.1.42 (at least)

lp:haildb bug Development 2011-01-12 00:14:47 UTC 2011-01-12
72. update soname to be newer as things h...

Author: Stewart Smith
Revision Date: 2011-01-12 00:14:47 UTC

update soname to be newer as things have been added and changed in this dev cycle

lp:~stewart/drizzle/warning-stack-frame-32k bug(Has a merge proposal) Development 2010-11-08 13:26:28 UTC 2010-11-08
1945. one last sqlite_server stack fix

Author: Stewart Smith
Revision Date: 2010-11-08 12:09:23 UTC

one last sqlite_server stack fix

lp:~stewart/drizzle/update-innobase-and-read-committed-fix-lockwaittimeout Development 2010-10-27 04:31:36 UTC 2010-10-27
2111. increase lock-wait-timeout

Author: Stewart Smith
Revision Date: 2010-10-27 04:31:14 UTC

increase lock-wait-timeout

lp:haildb/2.x Development 2010-10-04 04:47:01 UTC 2010-10-04
40. merge 2.2.0 release

Author: Stewart Smith
Revision Date: 2010-10-04 04:47:01 UTC

merge 2.2.0 release

lp:~stewart/haildb/convert-tests-to-subunit Development 2010-09-30 14:13:15 UTC 2010-09-30
66. add skeleton subunit code to remainin...

Author: Stewart Smith
Revision Date: 2010-09-30 14:13:15 UTC

add skeleton subunit code to remaining tests

lp:~stewart/haildb/embedded-innodb-1.0.6.6750-branch-point Development 2010-09-29 09:47:10 UTC 2010-09-29
2028. branches/zip: Allocate the merge sort...

Author: marko
Revision Date: 2010-02-24 08:56:43 UTC

branches/zip: Allocate the merge sort buffers from a heap, not stack.

The merge sort can use up to 48KiB of buffers when merging blocks.
That can cause a stack overflow, especially on 64-bit systems when not
building with inlined functions. This was reported as Issue #462.

row_merge_dup_report(): Allocate buf and offsets from a heap.

row_merge_heap_create(): Allocate space for buf[3] too. Fix bogus
sizeof arithmetics that happened to work, because
sizeof(ulint)==sizeof(void*).

row_merge_blocks(), row_merge_blocks_copy(): Allocate buf[3] from heap.

row_merge_insert_index_tuples(): Allocate buf from graph_heap.

rb://258 approved and tested by Sunny Bains

lp:~stewart/haildb/innodb-1.0.6-from-svn Development 2010-09-29 07:28:05 UTC 2010-09-29
1948. branches/zip: Increment version numbe...

Author: vasil
Revision Date: 2009-12-01 12:49:05 UTC

branches/zip: Increment version number from 1.0.6 to 1.0.7

1.0.6 has been released

lp:~stewart/drizzle/embedded-innodb-temporary-table-debug-test Development 2010-08-07 03:46:41 UTC 2010-08-07
1610. some debugging only

Author: Stewart Smith
Revision Date: 2010-08-07 03:46:41 UTC

some debugging only

lp:~stewart/drizzle/embedded-innodb-disable-innobase-build Development 2010-05-17 12:53:56 UTC 2010-05-17
1476. Merged embedded-innodb-type-blob into...

Author: Stewart Smith
Revision Date: 2010-05-17 12:53:56 UTC

Merged embedded-innodb-type-blob into embedded-innodb-disable-innobase-build.

lp:~stewart/haildb/historical Mature 2010-04-15 22:27:49 UTC 2010-04-15
6. innodb plugin 1.0.6

Author: Stewart Smith
Revision Date: 2010-04-14 16:57:03 UTC

innodb plugin 1.0.6

lp:vapour Development 2010-04-12 21:48:34 UTC 2010-04-12
28. vapour.c is rather derived from memca...

Author: Stewart Smith
Revision Date: 2010-04-12 21:48:34 UTC

vapour.c is rather derived from memcached_light.c, ack the BSD (C) on it, even though not in original memcached_light.c source...

lp:~stewart/drizzle/show-table-message-function (Linked to a blueprint)(Has a merge proposal) Development 2010-03-18 10:36:55 UTC 2010-03-18
1340. set creation_timestamp and update_tim...

Author: Stewart Smith
Revision Date: 2010-03-18 10:36:55 UTC

set creation_timestamp and update_timestamp to 0 before displaying the table proto in SHOW_TABLE_MESSAGE(). We can't just remove them as they're required fields :/ .... so we have to display a lie.

lp:~stewart/drizzle/drizzle-libtcc-function Development 2010-03-17 08:02:24 UTC 2010-03-17
1338. Very early LIBTCC() hack to have a fu...

Author: Stewart Smith
Revision Date: 2010-03-17 08:01:25 UTC

Very early LIBTCC() hack to have a function which executes C code in the database server. This is PURE EVIL.

lp:~stewart/drizzle/embedded-innodb-merge-datadictionary Development 2010-02-08 07:41:51 UTC 2010-02-08
1293. Merged embedded-innodb-init into embe...

Author: Stewart Smith
Revision Date: 2010-02-08 07:41:51 UTC

Merged embedded-innodb-init into embedded-innodb-merge-datadictionary.

lp:~stewart/drizzle/sum-distinct-create-internal-temporary-table Development 2010-02-08 01:10:11 UTC 2010-02-08
1301. Merged table-proto-message-error-chec...

Author: Stewart Smith
Revision Date: 2010-02-08 01:10:11 UTC

Merged table-proto-message-error-checking into sum-distinct-create-internal-temporary-table.

lp:~stewart/drizzle/bug492391-i_s-concurrency bug(Has a merge proposal) Development 2010-01-14 02:00:29 UTC 2010-01-14
1266. need _XOPEN_SOURCE defined on Linux t...

Author: Stewart Smith
Revision Date: 2010-01-14 02:00:29 UTC

need _XOPEN_SOURCE defined on Linux to get portable recursive mutex definition.

lp:~stewart/drizzle/concurrency-IS Development 2010-01-05 12:21:38 UTC 2010-01-05
1254. A recursive mutex due to how subselec...

Author: Stewart Smith
Revision Date: 2010-01-05 12:19:53 UTC

A recursive mutex due to how subselects with conditions work. fillTable can
call fillTable!

We need this to be *much* better. This is, however, the *much* smaller patch
to both illustrate the problem and fix it.

lp:~stewart/drizzle/schema-dbopt-not-crash-safe bug Development 2009-12-10 13:09:11 UTC 2009-12-10
1242. fsync() the schema file (db.opt) and ...

Author: Stewart Smith
Revision Date: 2009-12-10 13:08:07 UTC

fsync() the schema file (db.opt) and the directory it's in to help ensure crash safety.

lp:~stewart/drizzle/dead-index-type-removal-from-proto (Has a merge proposal) Development 2009-12-08 04:00:56 UTC 2009-12-08
1241. remove RTREE and FULLTEXT index types...

Author: Stewart Smith
Revision Date: 2009-12-08 04:00:56 UTC

remove RTREE and FULLTEXT index types from table proto definition

lp:bzr-importmbox Development 2009-11-16 02:49:31 UTC 2009-11-16
1. initial

Author: Stewart Smith
Revision Date: 2009-11-16 02:47:08 UTC

initial

lp:~stewart/drizzle/decimal-scale-precision Development 2009-11-08 22:36:06 UTC 2009-11-08
1201. have scale and precision stored in ta...

Author: Stewart Smith
Revision Date: 2009-11-08 22:35:28 UTC

have scale and precision stored in table proto and not field_length for DOUBLE and DECIMAL types

lp:~stewart/drizzle/hopefully-even-builds-fields-proto Development 2009-11-03 00:09:49 UTC 2009-11-03
1204. field comment set in table proto in p...

Author: Stewart Smith
Revision Date: 2009-10-29 13:44:35 UTC

field comment set in table proto in parser

lp:~stewart/drizzle/table-fields-in-proto-in-parser Development 2009-10-29 00:57:18 UTC 2009-10-29
1191. field NULL | NOT NULL in proto in par...

Author: Stewart Smith
Revision Date: 2009-10-29 00:52:58 UTC

field NULL | NOT NULL in proto in parser. Only for CREATE TABLE. Change default in proto to reflect default in SQL.

lp:~stewart/drizzle/fix-key_type Development 2009-10-19 23:47:36 UTC 2009-10-19
1184. use a real enum in table proto for ke...

Author: Stewart Smith
Revision Date: 2009-10-06 09:02:24 UTC

use a real enum in table proto for key_type instead of some horrible magic int thing.

lp:~stewart/drizzle/perf-events Development 2009-10-09 10:41:21 UTC 2009-10-09
1166. A very basic, proof of concept perf_u...

Author: Stewart Smith
Revision Date: 2009-10-09 10:09:45 UTC

A very basic, proof of concept perf_udf() that counts CPU instructions like the BENCHMARK() function does wall time.

It uses the very new (~linux 2.6.31, and at least .32 to get the headers)
perf_events interface to Linux to use the *hardware* Performance Management Unit
to monitor the CPU instructions spent. Since this has proper support in kernel,
and the abstraction is awesome, we actually get only the instructions spent executing
*this* thread - i.e. our connection to the database.

The end result is, much like you can use BENCHMARK() to see how fast MD5('pants')
is when run 1,000,000 times... we can find out how many CPU instructions are executed:

drizzle> select perf_udf(1, MD5('pants'));
+---------------------------+
| perf_udf(1, MD5('pants')) |
+---------------------------+
| 43540 |
+---------------------------+
1 row in set (0 sec)

drizzle> select perf_udf(100, MD5('pants')), perf_udf(10000, MD5('pants')), perf_udf(100000, MD5('pants'));
+-----------------------------+-------------------------------+--------------------------------+
| perf_udf(100, MD5('pants')) | perf_udf(10000, MD5('pants')) | perf_udf(100000, MD5('pants')) |
+-----------------------------+-------------------------------+--------------------------------+
| 702098 | 69246981 | 682496729 |
+-----------------------------+-------------------------------+--------------------------------+
1 row in set (0.38 sec)

and it does have sensible ratios too, so we can tell that 1000 times as much
work does really take about 1000 times as long:

drizzle> select perf_udf(1000000, MD5('pants')) /perf_udf(1000, MD5('pants'));
+---------------------------------------------------------------+
| perf_udf(1000000, MD5('pants')) /perf_udf(1000, MD5('pants')) |
+---------------------------------------------------------------+
| 1001.58248635599 |
+---------------------------------------------------------------+
1 row in set (3.5 sec)

Currently this code is a bit crude, only 1 measurement only on 1 cpu (so if
your hardware doesn't aggregate across cores, the data will be wrong if your
connection migrates)

lp:~stewart/libdrizzle/remove-tinyint Development 2009-10-02 07:33:25 UTC 2009-10-02
119. remove tinyint

Author: Eric Day
Revision Date: 2009-10-02 07:32:57 UTC

remove tinyint

lp:~stewart/drizzle/staging-mtr2-myisam-tmp bug Development 2009-07-20 09:21:30 UTC 2009-07-20
1096. merge trunk

Author: Stewart Smith
Revision Date: 2009-07-20 09:19:41 UTC

merge trunk

lp:~stewart/drizzle/mtr2-tests Development 2009-06-16 05:02:45 UTC 2009-06-16
1077. slightly out of order variables resul...

Author: Stewart Smith
Revision Date: 2009-06-16 05:02:45 UTC

slightly out of order variables result from fixing up server state

lp:memberdb/0.6 bug Mature 2009-05-17 02:13:06 UTC 2009-05-17
372. remove need for mysql_prelude.sql

Author: Stewart Smith
Revision Date: 2009-05-17 02:12:18 UTC

remove need for mysql_prelude.sql

lp:~stewart/+junk/assassass Development 2009-03-05 00:10:37 UTC 2009-03-05 This branch has not been pushed to yet.
lp:~stewart/+junk/libbadsleep Development 2008-11-25 03:43:13 UTC 2008-11-25
2. add license and readme

Author: Stewart Smith
Revision Date: 2008-11-25 03:42:55 UTC

add license and readme

lp:~stewart/+junk/libclosefun Development 2008-11-25 03:40:03 UTC 2008-11-25
1. initial

Author: Stewart Smith
Revision Date: 2008-11-25 03:39:46 UTC

initial

lp:~stewart/+junk/libeatmydata Mature 2008-11-25 03:15:20 UTC 2008-11-25
6. Add fdatasync() wrapper

Author: Mohsen Hariri
Revision Date: 2008-10-14 05:41:18 UTC

Add fdatasync() wrapper

1100 of 103 results