… 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test was allowed…-based flushing”, and “vCache with time-based flushing.” As the images demonstrate, the no-cache system is being crushed by IO…_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… you need two things: media with records(ibdata1, *.ibd, disk image, etc.) and a table structure. Indeed, there is no information…> 4. Load dumps of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA…
Comment: Percona Server for MySQL 5.5.30-30.2 now available
April 15, 2013 By 10 Comments
… installed? Please check at http://www.percona.com/doc/percona-server/5.5/installation/yum_repo.html that this is the… it is, then yum clean metadata could help for local image problems. Thanks!
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… especially for “aggregate” pages which may require images to be pulled from 10 different image servers. Keep Alive In my previous post I… objects which only change with their urls. Server side caching The benefit of server side caching is not so obvious for serving… of course depends on the server which you’re using – apache in prefork mode (ie same server used for static and dynamic…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
Infobright and InnoDB AMI images are now available There are now demonstration AMI images for Shard-Query. Each image comes pre-loaded with… ami-8eb648e7 shard-query-innodb-demo-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1.large or larger… a text file on shard1 called “/tmp/servers.txt” and run the following commands: $ cat servers.txt | grep “10.”| grep -v internal…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… (available for Linux and Windows). Download the Arch Linux ARM image from the Raspberry Pi website and unzip. Start Fedora ARM… Percona Server to startup at boot time (step 12), give your little server a reboot (type “reboot”) now and check that Percona Server works fine afterwards. Make sure to secure your server properly…
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 29 Comments
…’s default as well as RHEL 6.2 stock AMI images (I had to modify the script slightly for the Amazon image) but it didn’t work on either. Should I install Percona server: http://www.percona.com/doc/percona-server/5.5/installation.html on these images before running this intercontinental…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…@yves-laptop:~$ ec2-describe-images ami-1cdf3775 IMAGE ami-1cdf3775 099720109477/ubuntu-images-testing/ubuntu-lucid-daily-i386-server-20100618 099720109477 available public i386… Ubuntu repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL has an automatic startup…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… 3 more seconds to load all style sheets images and render the page server side optimization is more important. If you have… performance optimization potential. But let us get back to the Server Side Optimization. Lets assume our performance goal applies to the… for less complicated single MySQL server application there is often the question if it is MySQL server causing the problem or if…
Comment: Using LVM for MySQL Backup and Replication Setup
March 21, 2008 By 53 Comments
… Windows servers. We use a external NAS that Snapshots an immage of the Volume on other windows servers. We mount that image on a VMware like (vurtualbox) enviromemmt as a live enviroment if the server were to crash. If we are running My SQL on a Windows server Can we use the…
