MySQL Users Conference 2008 has number of Storage Engines presented which … also need to make sure they do not break or slow down other features your application use. For example you may… your application does a lot of primary key lookups and MySQL Cluster promises good performance and scalability. But if at the same…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…. Someone could be great MySQL Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster but have no idea how…”) but this is also why old products become feature overkill, slow and complicated. I’m not in positions to complain though… area MySQL Cluster, which was always best isolated of MySQL source leads the pack – there are bunch of interfaces to talk to MySQL cluster as…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… variables were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to control gathering of user statistics. With both slow… | 1.0 | Jeremy Cole | N/A | | | innodb_io_patches.patch | Cluster of past InnoDB IO patches | 1.0 | Percona | GPL | This…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… mysql_* functions directly This is probably bad but I do not like solutions proposed by original article ether. PEAR is slow as… be done pretty much online. You also get good data clustering so table becomes hot very quickly due to data locality… with loosing data etc. Read more in my Why MySQL Could be slow with Large Tables article. 5. The n+1 pattern…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… recruited the speakers, which is why it has been a slow process to finalize and get abstracts on the web. Sometimes…, think about using MySQL to find the top N most important rows per group of rows, distributed across a cluster of servers… things in MySQL — and that’s just for performing this task on a single server, not to mention a cluster of servers…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… and from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug fixes… on non-nullable columns was picked as the clustered index by InnoDB in the absence of a…error number correctly. #830199 (Oleg Tsarev). Variable log-slow-admin-statements was not listed with SHOW VARIABLES…
Post: The perils of uniform hardware and RAID auto-learn cycles
November 16, 2010 By 16 Comments
… selected machines on a large cluster of quite uniform database servers. Some of the servers were slowing down in a very puzzling…. I have heard stories before of uniform hardware causing a cluster of problems, such as a bad batch of hard drives…
Comment: Will Falcon fly?
June 24, 2008 By 11 Comments
… a pimped MyISAM so far no real competition to InnoDB. MySQL 5.1 still isn’t out, bugs don’t get… things I see involving so far is the business and MySQL cluster, the core Product itself is stalling at best. The Sun… problem is that it really slowed development down another bit (I don’t really have insight into MySQL, I read about some…
Comment: Why MySQL could be slow with large tables ?
April 3, 2007 By 141 Comments
… house 9-12 billion rows. I am trying to use Mysql Clustering, to the ndbcluster engine. Hardware is not an issue, that… times are reasonable, but insert times are very very very slow. As an example, in a basic config using MyISM tables…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… traditional MySQL asynchronous replication. edit: PXC is really a bit like semi-synchronous replication, in that changes are queued on all cluster… XtraDB Cluster reduces the hazards of multi-writing by keeping all the instances in sync continuously. Q: If a slave is slow… while, or if the network between master and slave is slow or unreliable. A solution to measure slave lag more accurately…
