Hi Jared and Sergei.
I've been doing some work with Postgresql, and have learned more abouthow
partial indexes are used.
It seems partial indexes are a general "design pattern" they use to:
1) have smaller indexes by including less rows2) reduce write-amplification
performance issuesas Postgresql
Yes, that's another good example of 11.3 where you caneither use a pg partial
index, or a pg/mysql unique nullable column with active=true or null.
Thanks, James Briggs.
--
Cassandra/MySQL DBA. Available in San Jose area or remote.
cass_top: https://github.com/jamesbriggs/cassandr
an be accomplished in both pg and MySQL usingNULLs in
a unique index, but the pg partial index allows the original data valuesto be
used without a NULL work column, so might be slightly more convenient/obvious.)
Thanks, James Briggs.
--
Cassandra/MySQL DBA. Available in San Jose area or remote.
cas
re, but ISC has no numbers to tell sponsors, etc.)
Thanks, James Briggs.
From: Justin Swanhart
To: Michael Widenius
Cc: MariaDB Developers
Sent: Tuesday, March 10, 2015 8:29 PM
Subject: Re: [Maria-developers] [Maria-discuss] Enabling feedback pluging for
MariaDB 10.1.4
It tells
ex invisible session)
#1 likely means changing the .frm format, which would cause
backwardcompatibility issues.
Are there any upcoming changes to .frm planned?
Any comments or suggestions? Thanks, James Briggs.
--
Cassandra/MySQL DBA. Available in San Jose area or remote.
cass_top: https://github.com/
Hi Kazuhiko Shiozaki-san.
My permute-indexes tool is handy when doingperformance tuning/optimizer
analysis:
https://github.com/jamesbriggs/mysql-permute-indexes
Thanks, James Briggs.
--
Cassandra/MySQL DBA. Available in San Jose area or remote.
cass_top: https://github.com/jamesbriggs/cassandra
Hi Sergei.
I signed the MCA in 2013 when I submitted my SHUTDOWN patch.So the licence is
the MCA.
Thanks, James Briggs.
--
Cassandra/MySQL DBA. Available in San Jose area or remote.
cass_top: https://github.com/jamesbriggs/cassandra-top
From: Sergei Golubchik
To: James Briggs
Cc: Maria
are only 50% implemented in MariaDB and need some design effort.
Thanks, James Briggs.
--
Cassandra/MySQL DBA. Available in San Jose area or remote.
________
From: James Briggs
To: Maria-developers
Sent: Monday, September 8, 2014 2:52 PM
Subject: Patch: CREATE
Hi List.
Below is tests/view.pl for testing CREATE VIEW options.
It tests several thousand permutations and was used to find MDEV-6709
Thanks, James Briggs.
--
Available for MySQL/NoSQL DBA/Programming in San Jose area or remote.
tests/view.pl:
#!/usr/bin/perl
# Program: view.pl
# Licence
email.)
- Please take a look at the style, and the 411 comments.
Thanks, James Briggs.
--
Available for MySQL/NoSQL DBA/Programming in San Jose area or remote.
$ cat create_force_view.patch
--- ../mariadb-10.1.0/sql/sql_view.h2014-06-27 04:50:36.0 -0700
+++ sql/sql_view.h2014-09-
Hi folks.
I created this MDEV based on the
"bad news" in my previous comment
about create view (actually things
are worse than I thought, since
implementing the missing options
will break user applications and
affect replication backward compatibility):
(MDEV-6365) CREATE VIEW Ignores RESTRICT/
years. :)
Thanks, James.
On Thu, 6/19/14, sriram patil wrote:
Subject: Re: [Maria-developers] Doubt in bin logging for CREATE VIEW
To: "James Briggs"
Cc: "maria-developers@lists.launchpad.net"
Date: Thursday, June 19, 2014, 2:46
Hi Sriram.
The good news ... nice catch, you earned your GSoC salary!
The mysql_register_view() has a dozen
different ways to fail:
- RAM: my_error(ER_OUT_OF_RESOURCES, MYF(0));
- disk: sql_create_definition_file()
- name collision
- etc.
So the create view statement can
definitely fail on the
Hi Sriram.
- I read your new blog and some of the test code. Looks good.
- I think you should add a section to the MDEV with
examples of what the final syntax will look like
for each statement so we can check for standards
(ANSI and de facto) and esthetics. Looks correct to
me so far though - dro
Hi Roberto.
1) nf is a bigint, so why are you inserting a string value ('-18')?
2) is there some reason you aren't using indexes?
3) after you resolve 1 and 2, do repair table.
Thanks, James.
On Tue, 6/17/14, Roberto Spadim wrote:
Subject: [Maria-d
Hi Sriram.
I read your CREATE OR REPLACE DATABASE
code and have some comments:
1) I noticed that you directly mysql_rm_db the database
before creating it. Please ask your mentor if
it would be better to rename it, obtain a
successful create status, then delete the old db.
Currently, if the disk
er/
James.
On Thu, 3/20/14, sriram patil wrote:
Subject: Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF NOT
EXISTS, and DROP IF EXISTS" Project
To: "James Briggs"
Cc: maria-developers@lists.launchpad.net
Date: Thursday, March 20, 2014, 5:34 AM
H
Hi Sriram.
If you could add "CREATE VIEW … FORCE" too, that would be awesome.
See the Oracle Enterprise docs for the behavior:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8004.htm
Thanks, James.
On Wed, 3/19/14, Sergei Golubchik
Hi Roberto.
I don't know anything about courses inside Oracle or Mariadb.com.
But I googled around and found the following outside resources:
- MySQL Internals Manual (online)
- Understanding MySQL Internals By Sasha Pachev (O'Reilly)
- Peter Z's InnoDB internals lecture videos are online
- I wr
Roberto:
Also consider using DTrace on the Mac or Solaris, and the oprofile linux module.
Later, James.
On Tue, 6/25/13, Hartmut Holzgraefe wrote:
Subject: Re: [Maria-developers] Debug interface
To: maria-developers@lists.launchpad.net
Date: Tues
My understanding is that Rackspace Cloud MySQL uses Virtuozzo to control IO per
user.
James.
On Mon, 6/24/13, Roberto Spadim wrote:
Subject: Re: [Maria-developers] RFC: Pausing a query thread
To: "Peter Laursen"
Cc: "Sergei Golubchik" ,
"maria-
Hi Roberto.
1) By default, replication applies to mysql.* tables also. GRANTS aredocumented
to be immediately be applied without FLUSH PRIVILEGES.
2) Most people just have one or two mysql instances perserver machine for
production work.
3) If you would like more detailed answers in the future,
Hi folks.
1) I like the idea of using wontfix for issues that don't make
sense to fix, and wishlist for issues that don't have time
to fix now.
2) wishlist items would be a good starting point for new
contributors to work on. Kind of like "linux kernel janitors",
but without the fail, hopefully.
wn command like WAIT|IMMEDIATE|ABORT.
This code is released under the Open Source BSD-new License, according to the
MariaDB Contributor Agreement.
Thanks, James Briggs.
james.bri...@yahoo.com
http://www.jebriggs.com/blog/2013/05/patch-to-add-shutdown-statement-to-mysql-mariadb/
--- sql_parse.cc
24 matches
Mail list logo
