… instance Let’s break it down a bit. Our unit of…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… online game and you keep track of global achievement statistics in… some metadata: BEGIN; INSERT INTO users_groups (user_id, group_id) VALUES (100…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…. Percona XtraBackup enables backups without blocking user queries, making it ideal for companies… solution, XtraBackup drives down backup costs while providing unique features for MySQL backup. The …Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, caching layers, etc. Wherever the problem is, we’ll track it down. I won’t talk about that. That’s not because…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852… things I’ll look at, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to find redundant…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… of users on single server with single MySQL server ? Well people just seems to be nice and not looking to crash MySQL/DOS… to crack down on users which cause a lot of load which causes a lot of unintentional abusers, but to get MySQL in… queries in the PROCESS LIST and you can’t really track how much memory was allocated for given session (or restrict…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… too-small Valgrind-internal memory tracking allocations hardcoded. In other words;…user:group /your_location/massif.out # Use the user mysqld will now run under (check ‘user…log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const…This example helped to pin down a memory leak bug on…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…site serving 8000 logged in users. However the service goes down too often to call it… really would like to know is howto track down where the bottleneck is… I’ve read…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…
Post: ClickAider - Track Adsense Clicks and much more
July 9, 2007 By 17 Comments
…, plus ClickAider also can track form submissions. The Click Tracking is done non-intrusive …and much more – you can drill down to all details available about … can view information about clicks for users which came to you from … We use Scale-Out MySQL architecture based on MySQL 5.1 with some …
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… with performance problems (part MySQL related and part related to LAMP in… need last access time tracked for them, especially as this tracking can be quite…for files or traffic limit per user needs to be enforced. Serving file… you can have performance to go down as request will be frequently made…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 13 Comments
…partitioning. In our case we wanted to track links between sites. It is easy …it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it…then news came out and quick calm down in about in week. You can …well as which pages and domains forum users tend to link to. So far …
