…project only on database Backend and full …which we love to use where large scale search …to search our MySQL Performance Forums Second – note the graph which shows how…to link to. So far reporting period is restricted by performance reasons – there is too much data to group and quite a hassle to build…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…to decide on couple few questions on how to… as building summary tables, …to spread Web and Database instances and establish may be establish replication mainly to be able to…MySQL and LAMP and MySQL is one of them. Plus for large companies it may make sense to hire great experts and have them to…
Post: Percona White Paper: Architecting SaaS Applications with XtraDB
October 11, 2010 By 3 Comments
… technical white paper. It shows how Percona Server with XtraDB can make large-scale multi-tenant databases easier to build with MySQL. Our experiences working with… levers are available and how to use them. Percona Server with XtraDB for Software-as-a-Service Application Databases is posted on the…
Comment: Interesting MySQL and PostgreSQL Benchmarks
December 1, 2006 By 20 Comments
…large databases (and small fit in memory anyway) – count for example with 16GB database and uniform access distribution how…going in parallel convert sequential reads to random reads and all can … explaining why people still build scalable applications with MySQL. Speaking about work serialization …
Post: Descending indexing and loose index scan
May 9, 2006 By 6 Comments
…MySQL does not have at this point, but it was not where for so long at large…to optimize this query well – external sort (“filesort”) will be needed. If you would be able to build…to remember when you designing your new applications or porting ones from other databases. Designing the indexes for MySQL…
Post: Percona Server scalability on multi-cores server
September 29, 2010 By 14 Comments
…, obviously I’m anxious to see how Percona Server with XtraDB … using from 1 to 32 threads. The database size was 100 …, we are going to provide regular builds dedicated to the Cisco UCS… of increase is not as large, and for 24 threads … be interesting to compare these results with the latest MySQL 5.5…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
…MySQL…to implement changes and millions of other things. Second – waiting on database (or other) operations to…large scale deployment, migrations and high available architectures implementation such a way often surprising customers (in a good way) of how…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… way to get extra performance from your IO subsystem. Spreading the database among …ask how large system is needs to growth and how much effort people would like to … can be used. You can build infrastructure which would use crappy … servers with RAID for their MySQL installations. I surely agree with …
Comment: Should MySQL update the default innodb_log_file_size?
November 24, 2011 By 37 Comments
… variables, how about size in innodb_data_file_path …build profile. Something like -DBUILD=large / -DBUILD=small to cmake. The reason why I am proposing this is because MySQL…MySQL, something like syslog-ng can log into a database and so on. This way distro builders/developers/DBAs can fit MySQL to…
