You can enable/disable the general query log on the fly :
https://mariadb.com/kb/en/mariadb/general-query-log/
Another solution is to use MaxScale as a proxy between the app and the
database to log only specific queries :
https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-14/maxscal
As a side note, the documentation for the engine independent table statistics
isn't very complete :
- Is there a reason not to activate it and what are the possible downsides of
its activation
- How much could it slow down an ANALYZE and possibly other operations?
- There are no practical example
To be able to give the best answer we must first know what is motivating
the move from LP.
Aside of that, if the already self-hosted lists are working well and you
already know how to maintain properly it its probbaly the best course
but mail routing (rate-limiting, avoiding blacklisting, poss
It was a project that i followed while on Kickstart
(https://www.kickstarter.com/projects/1839007321/mysql-cli) but i didnt
take time to try it since it has been released.
Its definitely an interresting project and they already make a debian
package.
I will give it a try on the next days if
I will try not to feed the troll.
Here is the commit that added this message :
https://github.com/MariaDB/server/commit/ddd275bde7a8edb64449761989d4d472739b3d2a#diff-e7d51f293adc9257284fbdec858056df
Le 06/08/2015 13:11, Reindl Harald a écrit :
Am 06.08.2015 um 13:04 schrieb Guillaume Lefran
You might want to enable "numa interleave" for Maria (if your instance
will use more than the memory of a single physical CPU for example), for
that you can pass the option "--numa-interleave" to mysqld_safe or
simply add "numa_interleave" in the configuration under the
"[mysqld_safe]" section.
0 :
https://mariadb.atlassian.net/browse/MDEV-7261
Le 22/04/2015 00:31, Jean Weisbuch a écrit :
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 cac
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
As long as its limited to beta and alpha releases i dont think its that
bad to enable it by default as users using these versions should already
be aware of their not production-ready state.
As it seems to be simple to enable/disable the plugin with the
"feedback" variable, it shouldnt be a prob
In my opinion, the A option is the way to go, it will be simpler to
manage, simpler and easier to backup/restore, easier to scale/load
balance and i dont see why it would be more of a security issue.
Le 04/03/2015 17:12, Peter Boston a écrit :
I don’t know the following questions are valid he
Just as a side note, its possible to remove the TRANSACTIONAL=x option
by adding TRANSACTIONAL=default on the ALTER statement.
A similar issue arises if for example ROW_FORMAT=PAGE is used on the
ARIA table as it doesnt exists on InnoDB, it will issue a warning
"InnoDB: assuming ROW_FORMAT=COM
The packages are usually not available on every mirrors when the release
mail is sent, it usually takes few hours for all mirrors to have the new
packages.
Le 27/01/2015 19:28, Peter Laursen a écrit :
On OpenSuse 12.3 YaST "Online Update" does not find 10.0.16 as an
update available for alread
It seems that the limitation has been introduced on MySQL 5.6.20 :
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html
Le 20/01/2015 01:03, Reindl Harald a écrit :
InnoDB: The total blob data length (13476124) is greater than 10% of
the redo log file size (5120). Please increase inn
I already asked the exact same question some times ago and it shouldnt
have any impact to change the value when the threadpool is used.
Le 03/12/2014 02:56, Federico Razzoli a écrit :
Hi all
Would someone kindly explain (or document) how @@thread_cache_size affects the
pool-of-threads? Do val
By any chance, have you tried different "optimizer_switch" values?
I think that "join_cache_level" might also have an influence on the
index used by the optimizer.
ps: when you are pasting the output from "SHOW INDEX" or similar, you
should set this text in "preformated" mode on your mail clie
To focus back on the original question, would it be interesting to
define dynamically the buffer pool size on a similar fashion as the
Windows installed does when installing MariaDB using packages on
Debian/Ubuntu (or other applicable distros that shows dialog when
installing packages from an i
I personally never had time to give much looks to P_S, i gave it some
looks but never seriously dug onto and really had to keep it enabled on
a production server, its a nice feature but i think that if someone
knows it and needs it, they will be able to enable it but most of the
"common" users
Hi,
mysqltuner does only take some buffers to calculate the maximum buffer
size, for example it does not take in account the Aria table cache or
the TokuDB table cache (if you have TokuDB enabled) or other MariaDB
specific buffers it more to give you an idea of the possible memory
usage than
Hello,
I am maintening a fork of mysqlreport which is a tool that gives stats
and infos about MariaDB/MySQL and that has been integrated on the Debian
packages of MySQL and MariaDB for years (i dont know about other
distros), you can find it on the debian/additions/ directory of the sources.
Hello,
Lately, i did modify mytop
(https://mariadb.atlassian.net/browse/MDEV-4476) to use
INFORMATION_SCHEMA.PROCESSLIST instead of SHOW PROCESSLIST (when
available) to gather running processes informations as it's more
flexible and has more informations but the value of the PROGRESS column
(this thread was originaly from maria-developpers)
The mariadb.com/.org distinction is not really clear as both have a
similar layout, designs and duplicate contents, plus distincting both
sites from the sole TLD is not the most visible one ; i must admit that
the first time i ended up on mar
Hello,
You can use the Oracle InnoDB instead of XtraDB on MariaDB, it could be
interresting to test if it makes a real difference on your specific usecase.
To do so, you must put that in our my.cnf file :
ignore-builtin-innodb
plugin-load=ha_innodb.so
innodb
Regards.
Le 02/07/2
Le 16/11/2012 22:46, Daniel Bartholomew a écrit :
The following question has been posted to the Knowledgebase:
https://kb.askmonty.org/en/drop-in-replacement-on-debian/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Is there a way to make MariaDB install over MySQL on a
23 matches
Mail list logo
