… byte) files mostly, it’s best to use 512-byte blocks, for bigger files 4k may make more sense (you can’t use blocks… you are using LVM, you want to make sure it does not introduce misalignment. On the other hand it can be used to… End Size Type File system Flags 1 2048s 19531775s 19529728s primary ext4 boot 2 19531776s 27920383s 8388608s primary linux-swap(v1) 3…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important part in your system performance or it may not…files (and whole datadir) and log files on the same partition as well because this makes it very easy to use… was trashed. Regarding SWAP – I tend to have it but not optimize for it, …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… memory. Do not do this. If using Linux setup LVM for database directory to get more efficient backup. EXT3 file system works OK… make sure you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb… may suffer. innodb_file_per_table – If you do not have too many tables use this option, so you will not have uncontrolled innodb…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…in the buffer pool and InnoDB essentially starts swapping between its buffer pool and the tablespace on … result of loading the entire 4GB file in one chunk: time mysql -e “set foreign_key_checks=0;…used ‘time’ to run the Perl fifo script, and it used a few minutes of CPU time during the loads. So not…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… use result overload to make MySQL to consume so much memory so it will swap…file descriptors. The same is true for Partitioned tables in MySQL 5.1 Disk Space For MyISAM tables hosting providers used to use…. This is not to mention many Virtual Hosting companies use old MySQL versions which typically …
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
…MySQL you might need to deal with RAID … I could not find a way to do it. It could be by design as using such commands…simply adding drive back or re-seating the hot swap hard drive solves the problem. If the …corrupted. This is why I prefer to know files affected by bad blocks on the first place….
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
….0% si Mem: 8165752k total, 8077196k used, 88556k free, 493192k buffers Swap: 4096532k total, 276k used, 4096256k free, 6326856k cached PID USER PR…_queries_not_using_indexes = On log_slow_queries=/var/lib/mysql/log-slow-queries.log innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…automated handling in mind as Google File System. In particular you want to…recovery much more complicated than simply swapping the server. This is exactly one… you use MySQL Replication for HA) the switch to the new server may not be …if Hot Spare should be used. I normally do not use it because it a …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be done by key_… MySQL could crash or go swapping. Second – table will be locked while repair is going. If this is frequently used… MyISAM tables are good to be used for. This list is not inclusive and every system has its …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…-in mysql replication (asynchronous) for a given node, it’s not possible. … is very large? Can you swap in Binaries ? A: Check out…file my.cnf ? A: Yes. Q: If the cluster blocks write while it commits to another host, does that not…, edge cases, I would not recommend using MyISAM. Q: How does write…
