… MySQL. I actually had more material than I covered (by design), but one thing I regret we didn’t cover was Flow… as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs… and therefore time-consuming to the application. How to tell if flow control is happening and where it is coming from There…
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
… flow in. In fact we have submitted our slow query log with microseconds patch so we’ll see how quickly and if…. This is of course if MySQL applies reasonable quality assurance to accepted code. What is about binaries ? MySQL 5.0.37 was rare… suspect regarding this issue again will a lot depend on MySQL – if new version will be easy to upgrade to, the amount…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… your creative juices flowing, and submit those session and tutorial proposals on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial…, SSD storage, data warehousing, and all those other great topics. If you need inspiration, look at the schedule for previous years…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… my previous post I got number number of comments saying if MySQL would not have multiple storage engine interface it would not… distinct groups of MySQL Users Users what want cool database This is where a lot of energy is flowing (and Drizzle is… this – you might think most relevant players in MySQL community participated in MySQL Users Conference over the years. This is about 2000…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… which node was the originator of the transaction. Flow Flow gives some information about Flow Control events. Galera has some sophisticated ways of… (and hence overall cluster writes) down. snt wsrep_flow_control_sent — how many flow control events were SENT from this node. Handy… watching flow control events and queue sizes is a better way to detect replication lag, and this really just tells you if…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…’ s have a look first at the normal flow: Replication flow: [1] When you setup MySQL replication, you define the global variable server… events : Closer look: Infinite Replication Loop flow: If you have master-master with slaves or if you want to backup one master, you… process because high availability tools like mmm can cause failover if you stop replication # mmm_control @production set_passive (to avoid…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… | And if you test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection… to avoid potential data loss. Remove ‘/var/lib/mysql//grastate.dat’ file and restart if you wish to continue. (FATAL) at galera…-d509-11e1-0800-013f68429ec1 120724 10:58:09 [Note] WSREP: Flow-control interval: [8, 16] 120724 10:58:09 [Note] WSREP…
Post: Using flow control functions for performance monitoring queries
May 24, 2008 By 12 Comments
I’m not big fan on flow control functions like IF or CASE used in MySQL Queries as they are often abused used… performance profile. mysql> select count(*) cnt, avg(wtime) avw, sum(if(wtime>0.3,1,0))/count(*) soso, sum(if(wtime>1,1… another example: mysql> select count(*) cnt, avg(wtime) avw, sum(if(wtime>0.3,1,0))/count(*) soso, sum(if(wtime>1,1…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
… warehouse, or at least the first dw “evangelist” if you will. This approach focuses on the normalization… data transformations is usually called a “flow“. An example ETL flow might combine data from item and category… than it may be on MySQL, but it is definitely possibly to use MySQL as long as the …
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…version as run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word)), count…. Notice that there is only one query. If your database system can not provide native parallelism… parallel_work; This allows you to use data flow semantics on any cluster with respect to …
