- developers - lists.mariadb.org

[Maria-developers] Can not start mariadb
by planas 02 Aug '11

02 Aug '11

When I try to start maria, Ubuntu 11.04, a local install mariadb 5.2.7 sudo /usr/bin/mysqld_safe I get 110801 22:40:54 mysqld_safe Logging to syslog. 110801 22:40:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 110801 22:40:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended If I try sudo /etc/init.d/mysql start I get * Starting MariaDB database server mysqld [fail] sudo /usr/bin/mysqld_safe -h localhost or 127.0.0.1 with the same results as before. I have been researching this problem and have found nothing definite about the problem of how to solve it. I have tried a complete reinstall from the repository and it has not helped. I have verified my.conf appears to be correct based on information I have found on the web. I have enclosed the output from mysqlbug: GNU nano 2.2.6 File: /tmp/mysqlbug-3129/mysqlbug C++ compiler: g++-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2 Environment: System: Linux planas-pingy-1104 2.6.38-9-generic #43-Ubuntu SMP Thu Apr 28 15:2$ Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using built-in specs. COLLECT_GCC=/usr/bin/gcc COLLECT_LTO_WRAPPER=/usr/lib/x86_64-linux-gnu/gcc/x86_64-linux-gnu/4.5.2/lto-wr$ Target: x86_64-linux-gnu Configured with: ../src/configure -v --with-pkgversion='Ubuntu/Linaro 4.5.2-8ub$ Thread model: posix gcc version 4.5.2 (Ubuntu/Linaro 4.5.2-8ubuntu4) Compilation info (call): CC='gcc -static-libgcc' CFLAGS='-O2 -fno-omit-frame-p$ Compilation info (used): CC='gcc -static-libgcc' CFLAGS=' -O2 -fno-omit-frame-$ Configure command: ../configure '--build=x86_64-linux-gnu' '--host=x86_64-linu$ -- Jay Lozier jslozier(a)gmail.com

3 2

Re: [Maria-developers] [Commits] Rev 3138: Early check of subquery cache hit rate added to limit its performance impact in the worst case. in file:///home/bell/maria/bzr/work-maria-5.3-scache_impact/
by Oleksandr Byelkin 01 Aug '11

01 Aug '11

Hi! 01.08.2011 10:12, Timour Katchaounov пишет: > Sanja, > > Could you explain why these new constants are defines, > and not declared const variables: > > === modified file 'sql/sql_expression_cache.cc' > --- a/sql/sql_expression_cache.cc 2011-07-28 14:10:29 +0000 > +++ b/sql/sql_expression_cache.cc 2011-08-01 06:34:55 +0000 > @@ -26,6 +26,11 @@ > hit_rate = hit / (miss + hit); > */ > #define EXPCACHE_MIN_HIT_RATE_FOR_MEM_TABLE 0.2 > +/** > + Number of cache miss to check hit ratio (maximum cache performance > + impact in the case when the cache is not applicable) > +*/ > +#define EXPCACHE_EARLY_CHECK 200 > > > All of these are potentially possible to tune, why make them > compile-time defines? Heh, that is what I wanted to discuss. On one hand too many parameters is bad on other hand too simple is not good also... [skip]

1 0

[Maria-developers] WL#234 New (by Knielsen): @@binlog_do_not_replicate filtering of binlog events
by worklog-noreply＠askmonty.org 01 Aug '11

01 Aug '11

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: @@binlog_do_not_replicate filtering of binlog events CREATION DATE..: Mon, 01 Aug 2011, 09:40 SUPERVISOR.....: Monty IMPLEMENTOR....: Knielsen COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 234 (http://askmonty.org/worklog/?tid=234) VERSION........: Server-9.x STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: DESCRIPTION: This worklog is about introducing a new session variable @@binlog_do_not_replicate. When this variable is set, an associated flag bit is set in events logged into the binlog. The first stage of this worklog is to introduce an option --slave-ignore-do-not-replicate-events. When this is set, the slave will skip any events received with the binlog-do-not-replicate bit set. The second stage is to do this filtering on the master. When --slave-ignore-do-not-replicate-events is set on the slave, the master will avoid sending these events to that slave at all, saving on bandwidth but otherwise working the same way as stage 1. The motivation for this worklog is to allow an application to do changes that are replicated in a way external to the internal MySQL replication, but which still keeps the events in the binlog for debugging/point-in-time recovery, or for standard replication to other servers. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v4.0.0)

1 0

[Maria-developers] Review of mysql-test-run speedup patch
by Kristian Nielsen 31 Jul '11

31 Jul '11

Hi Serg, Can you review below patch? (sorry for no commit mail, I forgot to configure outgoing mail on my new laptop before committing). I was for a long time annoyed that mtr takes 20 seconds starting up before it starts running the first test. So being bored one evening I ran a Perl profiler on the code and fixed the culprit. (BTW, I haven't forgotten your suggestion to change include/long_test.inc information to be in a separate file instead; I just haven't gotten around to it yet.) - Kristian.

2 2

Re: [Maria-developers] [Commits] Rev 3135: Subquery cache going on disk management fix: Do not go on disk if hit rate is not good. in file:///home/bell/maria/bzr/work-maria-5.3-subquerycachedisk/
by Sergey Petrunya 28 Jul '11

28 Jul '11

Hi Sanja, Ok to push. On Thu, Jul 28, 2011 at 05:10:29PM +0300, sanja(a)askmonty.org wrote: > At file:///home/bell/maria/bzr/work-maria-5.3-subquerycachedisk/ > > ------------------------------------------------------------ > revno: 3135 > revision-id: sanja(a)askmonty.org-20110728141029-adkbj1vedh86m3uc > parent: igor(a)askmonty.org-20110723064728-j2sgq39rp528eaol > committer: sanja(a)askmonty.org > branch nick: work-maria-5.3-subquerycachedisk > timestamp: Thu 2011-07-28 17:10:29 +0300 > message: > Subquery cache going on disk management fix: Do not go on disk if hit rate is not good. <skip> BR Sergey -- Sergey Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog

1 0

[Maria-developers] Is it time to change 5.3 bugs status from Fix Committed to Fix Released?
by Sergey Petrunya 28 Jul '11

28 Jul '11

Hello, The bug database has 197 bugs with status="Fix committed" and target_milestone=5.3. Since we've released 5.3, is it time to change status on these bugs to "Fix released"? BR Sergey -- Sergey Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog

1 0

Re: [Maria-developers] [Commits] Rev 3135: Subquery cache going on disk management fix: Do not go on disk if hit/miss ration less than 2. in file:///home/bell/maria/bzr/work-maria-5.3-subquerycachedisk/
by Sergey Petrunya 28 Jul '11

28 Jul '11

Hi Sanja A summary of our discussion on irc/skype: Please change EXPCACHE_DISK_HITMISS_RATIO to be a "hit ratio", i.e "fraction of accesses that result in cache hits", as that's this is the most common number people use when they think about cache performance. Please change one limit into two: 1. A very poor hit ratio that will cause cache to stop working altogether (like the below patch does) 2. A moderately poor ratio that will cause the in-memory table to be emptied (instead of being converted to on-disk table). Suggested names: EXPCACHE_MIN_HIT_RATIO_FOR_DISK_TABLE, EXPCACHE_MIN_HIT_RATIO_FOR_MEM_TABLE. Please supply both definitions with comments about their meaning. On Thu, Jul 28, 2011 at 01:18:56PM +0300, sanja(a)askmonty.org wrote: > === modified file 'sql/sql_expression_cache.cc' > --- a/sql/sql_expression_cache.cc 2011-07-19 20:19:10 +0000 > +++ b/sql/sql_expression_cache.cc 2011-07-28 10:18:55 +0000 > @@ -16,6 +16,8 @@ > #include "mysql_priv.h" > #include "sql_select.h" > > +#define EXPCACHE_DISK_HITMISS_RATIO 2 > /* > Expression cache is used only for caching subqueries now, so its statistic > variables we call subquery_cache*. > @@ -26,7 +28,7 @@ Expression_cache_tmptable::Expression_ca > List<Item> &dependants, > Item *value) > :cache_table(NULL), table_thd(thd), items(dependants), val(value), > - inited (0) > + hit(0), miss(0), inited (0) > { > DBUG_ENTER("Expression_cache_tmptable::Expression_cache_tmptable"); > DBUG_VOID_RETURN; > @@ -180,10 +182,12 @@ Expression_cache::result Expression_cach > if (res) > { > subquery_cache_miss++; > + miss++; > DBUG_RETURN(MISS); > } > > subquery_cache_hit++; > + hit++; > *value= cached_result; > DBUG_RETURN(Expression_cache::HIT); > } > @@ -224,12 +228,26 @@ my_bool Expression_cache_tmptable::put_v > if ((error= cache_table->file->ha_write_tmp_row(cache_table->record[0]))) > { > /* create_myisam_from_heap will generate error if needed */ > - if (cache_table->file->is_fatal_error(error, HA_CHECK_DUP) && > - create_internal_tmp_table_from_heap(table_thd, cache_table, > - cache_table_param.start_recinfo, > - &cache_table_param.recinfo, > - error, 1)) > + if (cache_table->file->is_fatal_error(error, HA_CHECK_DUP)) > goto err; > + else > + { > + if ((hit/miss) < EXPCACHE_DISK_HITMISS_RATIO) > + { > + DBUG_PRINT("info", ("hit/miss ratio is not so good to go to disk")); > + free_tmp_table(table_thd, cache_table); > + cache_table= NULL; > + DBUG_RETURN(FALSE); > + } > + else > + { > + if (create_internal_tmp_table_from_heap(table_thd, cache_table, > + cache_table_param.start_recinfo, > + &cache_table_param.recinfo, > + error, 1)) > + goto err; > + } > + } > } > cache_table->status= 0; /* cache_table->record contains an existed record */ > ref.has_record= TRUE; /* the same as above */ > > === modified file 'sql/sql_expression_cache.h' > --- a/sql/sql_expression_cache.h 2011-07-19 20:19:10 +0000 > +++ b/sql/sql_expression_cache.h 2011-07-28 10:18:55 +0000 > @@ -85,6 +85,8 @@ private: > List<Item> &items; > /* Value Item example */ > Item *val; > + /* hit/miss counters */ > + uint hit, miss; Please change to be ulong (same type as subquery_cache_hit/miss) > /* Set on if the object has been succesfully initialized with init() */ > bool inited; > }; > -- BR Sergey -- Sergey Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog

1 0

[Maria-developers] WL#233 New (by Aag): Partial Range Indx
by worklog-noreply＠askmonty.org 28 Jul '11

28 Jul '11

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Partial Range Indx CREATION DATE..: Thu, 28 Jul 2011, 10:44 SUPERVISOR.....: IMPLEMENTOR....: COPIES TO......: CATEGORY.......: Maria-RawIdeaBin TASK ID........: 233 (http://askmonty.org/worklog/?tid=233) VERSION........: WorkLog-4.0 STATUS.........: Un-Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: DESCRIPTION: A way to make Indices significantly useful in some usage scenarios: Scoping the index to a specific range of values. This can be useful if some queries are only performed on a specific subset of the rows. Example: A process that implements a state machine for each row. All finished tasks have the state -1. To lookup the next task to perform only states > -1 have to be considered. Creating an index for the criteria to find the next task quickly would also index all the finished tasks. Which can make index creation expensive and waste several Gigabytes of diskspace (assuming millions of entries in the DB). While partitioning promises similar effects (a second axis for query optimizations) it is rendered utterly useless by its restriction that the partioning index must occur in *all* primary and unique keys which means one cannot define a large natural key via unique and a small artificial ID as primary key and then partition by an unrelated aspect (such as the state in my example). Range-restricted indices would allow similar optimizations: specify a range-restricted column as first column and then add the remaining criteria as other columns. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v4.0.0)

1 0

[Maria-developers] WL#232 New (by ColinCharles): Add missing SHUTDOWN statement
by worklog-noreply＠askmonty.org 28 Jul '11

28 Jul '11

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Add missing SHUTDOWN statement CREATION DATE..: Thu, 28 Jul 2011, 03:26 SUPERVISOR.....: IMPLEMENTOR....: COPIES TO......: Monty CATEGORY.......: Server-RawIdeaBin TASK ID........: 232 (http://askmonty.org/worklog/?tid=232) VERSION........: WorkLog-4.0 STATUS.........: Un-Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: DESCRIPTION: >From http://www.jebriggs.com/blog/2011/07/mysqls-missing-shutdown-statement/ Databases are more easily managed if all operations and logging are available to DBAs and scripts at the SQL client command line. So an additional improvement would be to add a SQL command like Oracles SHUTDOWN. See the blog post for a comparison table Reference from Oracle: http://www.dba-oracle.com/concepts/shutdown_commands.htm http://dev.mysql.com/doc/refman/5.5/en/mysql-shutdown.html http://dev.mysql.com/doc/refman/5.5/en/server-shutdown.html http://dev.mysql.com/doc/refman/5.5/en/kill.html http://dev.mysql.com/doc/refman/5.5/en/stop-slave.html USD$100 committed from James Briggs at the MariaDB BoF at OSCON 2011 ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v4.0.0)

1 0

[Maria-developers] WL#231 New (by Monty): Faster UNIQUE key generation with ALTER TABLE
by worklog-noreply＠askmonty.org 27 Jul '11

27 Jul '11

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Faster UNIQUE key generation with ALTER TABLE CREATION DATE..: Wed, 27 Jul 2011, 16:49 SUPERVISOR.....: Monty IMPLEMENTOR....: COPIES TO......: CATEGORY.......: Server-RawIdeaBin TASK ID........: 231 (http://askmonty.org/worklog/?tid=231) VERSION........: Server-5.5 STATUS.........: Un-Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 30 (hours remain) ORIG. ESTIMATE.: 30 PROGRESS NOTES: DESCRIPTION: Faster UNIQUE key generation with ALTER TABLE Generate also unique keys by sorting (as we do with non unique keys) to speed up alter tables with unique keys significantly. This worklog is for doing this for MyISAM and Aria tables. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v4.0.0)

1 0