ps: forgot to mention this MDEV which is also relevant to the thread (i
think) that i made about backporting the default automatic value of
"table_definition_cache" from MySQL 5.6.8+ (400 + (table_open_cache / 2)
and limited to 2000) instead of a fixed value of 400 :
https://mariadb.atlassian.n
There was also a MDEV created about this very problem on MariaDB by
Guillaume : https://mariadb.atlassian.net/browse/MDEV-7292
But in my opinion, this specific test is only usefull to see scalability
issues or the cache warming impact but it doesnt really reflect a
typical real-world usage (th
Hi, Justin!
On Apr 21, Justin Swanhart wrote:
>
> It is in fact, negatively scaleable without partitioning it:
> http://www.percona.com/blog/2009/11/16/table_cache-negative-scalability/
This doesn't directly apply to MariaDB. We didn't partition it
because our table definition cache is lock-free
Hi,
It is in fact, negatively scaleable without partitioning it:
http://www.percona.com/blog/2009/11/16/table_cache-negative-scalability/
It is easy to reproduce.
On Tue, Apr 21, 2015 at 10:54 AM, Sergey Vojtovich wrote:
> Hi!
>
> I think original question was about 5.5.
>
> MySQL 5.6 has part
Hi,
We had similar issues and we went through a couple of exercises to
determine how file descriptors work with both mysql and mariadb. Please
correct me if I'm wrong...this is what I've seen based on a number of
repeated tests.
For innodb, regardless of how many queries you have or any other
par
Hi!
I think original question was about 5.5.
MySQL 5.6 has partitioned table cache, but rather to overcome the negative
scalability aspect of increasing number of concurrent connections.
No version of MariaDB has partitioned table cache. At least yet.
Regards,
Sergey
On Tue, Apr 21, 2015 at 10
Hi,
Is that a MariaDB table_cache improvement? MySQL 5.6 has partitioned table
cache to overcome the negative scalability aspect of increasing table cache.
--Justin
On Tue, Apr 21, 2015 at 10:34 AM, Sergey Vojtovich wrote:
> Hi!
>
> On Tue, Apr 21, 2015 at 10:11:12AM -0700, Justin Swanhart wr
Hi!
On Tue, Apr 21, 2015 at 10:11:12AM -0700, Justin Swanhart wrote:
> Hi,
>
> If a MyISAM table is not in the table_open_cache, it will be opened by the
> query that needs the table. To increase the chances of the table being in
> the table_open_cache, increase the size to 4000 for a start (1/1
Hi,
If a MyISAM table is not in the table_open_cache, it will be opened by the
query that needs the table. To increase the chances of the table being in
the table_open_cache, increase the size to 4000 for a start (1/10 of your
current open files).
Be careful though. Increasing the table_open_ca
On 04/21/2015 05:07 PM, Justin Swanhart wrote:
Hi,
Are you using MyISAM or InnoDB? What are the values of
table_open_cache, table_definition_cache and innodb_open_files?
It is a mixture of MyISAM and InnoDB, but we got complaints especially
about the MyISAM tables.
Options table_open_cache
Hi,
Are you using MyISAM or InnoDB? What are the values of table_open_cache,
table_definition_cache and innodb_open_files?
--justin
On Tue, Apr 21, 2015 at 6:26 AM, Honza Horak wrote:
> Hey, with limited experiences with mariadb deployments, I'm wondering how
> many open files by the mysqld d
Hey, with limited experiences with mariadb deployments, I'm wondering
how many open files by the mysqld daemon is still sane (expected).
We have a customer that reports hundreds of thousands of open files with
600 connections (thread_pool_max_threads is used). Those processes seem
rather stall
Hi,
On Tue, Apr 21, 2015 at 5:41 AM, Umarzuki Mochlis
wrote:
> $ sudo service garb start
> garb: unrecognized service
>
> After I installed galera-3, the above error appeared when I tried to
> start garb service.
>
>From 3.9, garbd has moved to galera-arbitrator-3 package.
Best,
Nirbhay
> OS
Hello,
A new question has been asked in "MariaDB Java Client" by jihoonko. Please
answer it at
http://mariadb.com/kb/en/is-mariadb-client-library-for-java-applications-working-on-java-6/
as the person asking the question may not be subscribed to the mailing list.
--
$ sudo service garb start
garb: unrecognized service
After I installed galera-3, the above error appeared when I tried to
start garb service.
OS: Ubuntu 14.04
galera-3 v25.3.9-trusty
___
Mailing list: https://launchpad.net/~maria-discuss
Post to :
15 matches
Mail list logo
