search for: performance_schema

We also spotted these sql connections getting aborted, upon upgrading MySQL from 5.6 to 5.7. (Going back to 5.6 we don't see them!) Turning on mysql general query logging we can see it is Dovecot's mysql connections that inquire about or update quota usage in particular: *** /logs//mysql.log *** 2019-10-30T10:52:22.624690-07:00 2 Connect dovecot at localhost on npomail using

...ns (you need performance schema enabled): mysql> SELECT ess.user, ess.host, (a.total_connections - a.current_connections) - ess.count_star as not_closed, ((a.total_connections - a.current_connections) - ess.count_star) * 100 / (a.total_connections - a.current_connections) as pct_not_closed FROM performance_schema.events_statements_summary_by_account_by_event_name ess JOIN performance_schema.accounts a on (ess.user = a.user and ess.host = a.host) WHERE ess.event_name = 'statement/com/quit' AND (a.total_connections - a.current_connections) > ess.count_star; +-------+-----------+------------+------...

...hat would be the case. They're definitely there on this database server: MariaDB [mysql]> show databases; +--------------------+ | Database | +--------------------+ | bacula | | information_schema | | jfwiki | | jokefire | | mysql | | performance_schema | +--------------------+ 6 rows in set (0.00 sec) Any other ideas? Thanks, Tim On Sat, Aug 15, 2015 at 3:07 PM, Richard <lists-centos at listmail.innovate.net > wrote: > > > > Date: Saturday, August 15, 2015 13:53:28 -0400 > > From: Tim Dunphy <bluethundr at gmail.com...

...eed performance schema enabled): > > mysql> SELECT ess.user, ess.host, (a.total_connections - a.current_connections) - ess.count_star as not_closed, ((a.total_connections - a.current_connections) - ess.count_star) * 100 / (a.total_connections - a.current_connections) as pct_not_closed FROM performance_schema.events_statements_summary_by_account_by_event_name ess JOIN performance_schema.accounts a on (ess.user = a.user and ess.host = a.host) WHERE ess.event_name = 'statement/com/quit' AND (a.total_connections - a.current_connections) > ess.count_star; > +-------+-----------+------------+-...

...DB [mysql]> show databases; > > +--------------------+ > >| Database | > > +--------------------+ > >| bacula | > >| information_schema | > >| jfwiki | > >| jokefire | > >| mysql | > >| performance_schema | > > +--------------------+ > > 6 rows in set (0.00 sec) > > > > Any other ideas? > > > > Thanks, > > Tim > > > > On Sat, Aug 15, 2015 at 3:07 PM, Richard wrote: > > > >> > >> > >> > Date: Saturday, August 15...

...n > this database server: > > MariaDB [mysql]> show databases; > +--------------------+ >| Database | > +--------------------+ >| bacula | >| information_schema | >| jfwiki | >| jokefire | >| mysql | >| performance_schema | > +--------------------+ > 6 rows in set (0.00 sec) > > Any other ideas? > > Thanks, > Tim > > On Sat, Aug 15, 2015 at 3:07 PM, Richard wrote: > >> >> >> > Date: Saturday, August 15, 2015 13:53:28 -0400 >> > From: Tim Dunphy <bl...

...;> >| Database | > >> > +--------------------+ > >> >| bacula | > >> >| information_schema | > >> >| jfwiki | > >> >| jokefire | > >> >| mysql | > >> >| performance_schema | > >> > +--------------------+ > >> > 6 rows in set (0.00 sec) > >> > > >> > Any other ideas? > >> > > >> > Thanks, > >> > Tim > >> > > >> > On Sat, Aug 15, 2015 at 3:07 PM, Richard wrote: &...

...gt; > +--------------------+ >> >| Database | >> > +--------------------+ >> >| bacula | >> >| information_schema | >> >| jfwiki | >> >| jokefire | >> >| mysql | >> >| performance_schema | >> > +--------------------+ >> > 6 rows in set (0.00 sec) >> > >> > Any other ideas? >> > >> > Thanks, >> > Tim >> > >> > On Sat, Aug 15, 2015 at 3:07 PM, Richard wrote: >> > >> >> >>...

...u:object_r:mysqld_db_t:s0 ib_logfile0 -rw-rw----. mysql mysql system_u:object_r:mysqld_db_t:s0 ib_logfile1 drwx------. mysql mysql system_u:object_r:mysqld_db_t:s0 mysql srwxrwxrwx. mysql mysql system_u:object_r:mysqld_var_run_t:s0 mysql.sock drwx------. mysql mysql system_u:object_r:mysqld_db_t:s0 performance_schema drwx------. mysql mysql system_u:object_r:mysqld_db_t:s0 postfix drwx------. mysql mysql system_u:object_r:mysqld_db_t:s0 roundcubemail What does the 3rd comment mean? thanks

...y* thread_cache_size = 4 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock symbolic-links=0 ;plugin-load=rpl_semi_sync_master=semisync_master.so ;plugin-load=rpl_semi_sync_slave=semisync_slave.so ;rpl_semi_sync_master_enabled=1 ;rpl_semi_sync_master_timeout=10 ;rpl_semi_sync_slave_enabled=1 ;performance_schema query_cache_size = 8MB innodb_buffer_pool_size = 199M general_log_file=/var/log/mysql/mysql.log general_log=1 log-error=/var/log/mysql/mysql_error_log log-slow-queries=/var/log/mysql/mysql_slow_log wait_timeout = 86400 [mysqld_safe] general_log_file=/var/log/mysql/mysql.log general_log=1 log-error...

...| >> >> > +--------------------+ >> >> >| bacula | >> >> >| information_schema | >> >> >| jfwiki | >> >> >| jokefire | >> >> >| mysql | >> >> >| performance_schema | >> >> > +--------------------+ >> >> > 6 rows in set (0.00 sec) >> >> > >> >> > Any other ideas? >> >> > >> >> > Thanks, >> >> > Tim >> >> > >> >> > On Sat, Aug 1...

Hey guys, I'm running both a wordpress site as well as a mediawiki off of the same web servers. The mediawiki site works great! The wordpress site, meh. Not so much. I keep getting the common database connection error: Error establishing a database connection And as far as I can tell the settings between the mediawiki site and the wordpress site are nearly identical. Here's the media

Le mardi 25 avril 2017 ? 10:39 +0200, Robert Moskowitz a ?crit : > Thanks Laurent. You obviously know a LOT more about SELinux than I. I > pretty much just use commands and not build policies. So I need some > more information here. > > From what you provided below, how do I determine what is currently in > place and how do I add your stuff (changing postgresql with

...ib/mysql > socket=/var/lib/mysql/mysql.sock > symbolic-links=0 > ;plugin-load=rpl_semi_sync_master=semisync_master.so > ;plugin-load=rpl_semi_sync_slave=semisync_slave.so > ;rpl_semi_sync_master_enabled=1 > ;rpl_semi_sync_master_timeout=10 > ;rpl_semi_sync_slave_enabled=1 > ;performance_schema > query_cache_size = 8MB > innodb_buffer_pool_size = 199M > general_log_file=/var/log/mysql/mysql.log > general_log=1 > log-error=/var/log/mysql/mysql_error_log > log-slow-queries=/var/log/mysql/mysql_slow_log > wait_timeout = 86400 > > [mysqld_safe] > general_log_file...

.../mysql.sock > > symbolic-links=0 > > ;plugin-load=rpl_semi_sync_master=semisync_master.so > > ;plugin-load=rpl_semi_sync_slave=semisync_slave.so > > ;rpl_semi_sync_master_enabled=1 > > ;rpl_semi_sync_master_timeout=10 > > ;rpl_semi_sync_slave_enabled=1 > > ;performance_schema > > query_cache_size = 8MB > > innodb_buffer_pool_size = 199M > > general_log_file=/var/log/mysql/mysql.log > > general_log=1 > > log-error=/var/log/mysql/mysql_error_log > > log-slow-queries=/var/log/mysql/mysql_slow_log > > wait_timeout = 86400 > >...