June 19, 2013

Post: Should MySQL and Web Server share the same box ?

October 16, 2006 By 9 Comments

… you need to have multiple servers you may decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server…. Easier to maintain – Same thing if box happens to run multiple things it is harder to maintain. I would not call… corruption, use RAID to avoid loosing database with any hard drive loss etc. Database boxes also generally require more monitoring and…

Filed Under: Insight for DBAs Tagged With: , ,

Post: How would you compress your MySQL Backup

June 5, 2008 By 29 Comments

…may not be available, especially for CPU bound MySQL Load. The benefit in this case is …of CPU itself, if it is target for multiple backups, plus there are higher network bandwidth requirements…decompression – this is again much less than hard drive sequential read performance, though the fact this …

Filed Under: Insight for DBAs Tagged With:

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

… others due to statement level MySQL Replication which among other requirements, needs all auto-increment values in multiple value insert to be… 1-2 SATA drives so they are far from optimal for server grade IO subsystems. These are for MySQL 4.0 at… them to MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge threads…

Filed Under: Events and Announcements Tagged With:

Post: Concatenating MyISAM files

November 19, 2012 By 5 Comments

… (read almost impossible) to locate on a drive with tools like ext3grep. No headers… that …records: 6 And then, back in mysql: mysql> use test Database changed mysql> flush tables; Query OK, 0 rows…, yes, you can concatenate MyISAM files, even when multiple keys are defined. Not for everyday use …

Filed Under: MySQL

Post: MySQL Server Memory Usage

May 17, 2006 By 21 Comments

… – it really depends on application and configuration. Some applications will drive server to 10% of theoretical memory consumptions others only to… amount of memory MySQL will allocate for this operation. Note it is more complicated than once may think – multiple buffers of the… to run some queries. There can be mutiple key caches. Multiple key caches can be created to accomodate query executions Query…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Cache Miss Storm

September 10, 2010 By 30 Comments

… is just one execution unit). Because we normally have multiple cores and multiple drives it can be less than that but it is… have instrumentation in your applications or take a look at MySQL Slow queries – which is good enough if you populate each… you’re better wait rather than starting populating it. For MySQL Query Cache the solution should have been to make queries…

Filed Under: Insight for Developers, MySQL Tagged With:

Post: Distributed Set Processing with Shard-Query

May 14, 2011 By 27 Comments

… expressions always produce sets as output. Just to drive it home, SQL is relational algebra, and this… 99.9% of the work, due to the multiple levels of result set reduction. Finally, Shard-Query…resource which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies…

Filed Under: MySQL

Post: The perils of uniform hardware and RAID auto-learn cycles

November 16, 2010 By 16 Comments

… short time span (a couple of hours). Queries were taking multiple seconds to execute instead of being practically instantaneous. But nothing… the same shipment from the manufacturer? Did they have hard drives from a single manufacturing batch? It turned out that the… cluster of problems, such as a bad batch of hard drives all failing close together, but this is the first time…

Filed Under: Hardware and Storage, MySQL Tagged With: , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no… 27.557558059692383 | | 408 | Free Colorado DMV Resources and Driving Records | 24.933029174804688 | | 48 | California Free Public … arizona” then we might expect to get back multiple matches containing the words “James” and “Peterson”,…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Side load may massively impact your MySQL Performance

November 13, 2011 By 7 Comments

…=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql… competing for what is single hard drive on this test system. It is worth to note MySQL actually uses midpoint insertion for… complex batch job query) you are likely going to have multiple accesses to the data on the same page before being…

Filed Under: Benchmarks, Insight for DBAs, MySQL
« Older Posts
Newer Posts »