… support the functionality of the application as well as to provide reports to their clients. Clicks by…workloads out-of-the-box than MySQL is, especially for more complex queries. Percona is not tied to MySQL, …a long time and run on many fewer disk drives with much less memory, or even with …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…running Fedora 14. Each of the virtual machines was granted 4GB of memory. A SATA 7200rpm RAID10 battery backed RAID array was used as the underlying storage for the virtual machines. Baseline: The MySQL command line client was…“scale-out”, but once again, the “scale-out” …
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…/mysql/debian-start. When you run /etc/init.d/mysql start it runs this script, which runs … For example, I’m working with one client right now who has a hosted…they have a lot of tables, InnoDB uses over 3.5G of memory for its data …pool, some small part of it will move in and out of the buffer pool,…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… doing MySQL Performance evaluation on TPC-H queries for the client and they kindly allowed us to publish …look at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which “fits in memory“. …complete 10 out of 22 queries within 3hours run time allowed for each query and MySQL 6.0 has similar number of …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… node from here on out. Shard-Query is very …memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL…of nodes) php genconfig 20 > shards.ini Running the test For best performance, you should run…client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL… this would be one of the Items besides CPU… it back to the client. I tested MyISAM with…few percents. I also tried running with key buffer on …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server for a client…of memory used for applications (of which Mysql is the main one with “innodb_buffer_pool_size=20480Mâ€) while the bulk of… going out one at… the reorganization run in a…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…MySQL config file for very large systems. # # # This is for a large system with memory of 1G-2G where the system runs mainly # MySQL…run the program # with the “–help” option. # The following options will be passed to all MySQL clients [client… # Replication Slave (comment out master section to use …
Comment: Alternatives of PHP ?
September 10, 2006 By 28 Comments
…MySQL Client…client can be pretty slow. Now memory consumption – what Vadim is mentioning is memory leaks. I’ve run into this with number of…memory leaks. There is also does not seems to be whole a lot of memory…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…of 600 connections when every connection consumes X mb. If the answer to ‘b’ is 2mb then the total amount of memory…clients‘, ‘…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…of text. Could someone please help us out…
