varokism.blogspot.com
varokism: décembre 2011
http://varokism.blogspot.com/2011_12_01_archive.html
Mercredi 21 décembre 2011. Fine tuning read rnd buffer size and read buffer size. Those variables are easy to tune. The evidence popup here between 128 and 256K for in memory workload. In myisam.cc my default record cache size is set to global system variables.read buff size;. To show IO size :. Strace -p id mysqld -e read -e write. In InnoDB the difference come with prefetch trigger when no fragmentation. It is the case when rows are inserted in increasing primary key order. So conservative read...As we...
varokism.blogspot.com
varokism: Howto - Move a table to different schema with no outage
http://varokism.blogspot.com/2015/04/howto-move-table-to-different-schema.html
Jeudi 16 avril 2015. Howto - Move a table to different schema with no outage. I remember a time when it was debate if views can be useful for a web oriented workload? This post is about one good use case:. The story is that some tables have been creating into a schema and used by the application into same connection. Later on some more schema have been added to separate data for multiple application domain but still using original table, kind of cross domain universal table. CREATE DATABASE schema1;.
varokism.blogspot.com
varokism: MariaDB Storage Engine for CCM forum
http://varokism.blogspot.com/2013/07/mariadb-storage-engine-for-ccm-forum.html
Vendredi 5 juillet 2013. MariaDB Storage Engine for CCM forum. CCM Benchmark is one of the leading forum provider on the web, ROI is a major concern for them and historically MyISAM was used on the forum replication cluster. Reason is that MyISAM gave better ROI/performance on data that is hardly electable to cache mechanism. Like many other big web players at an other scale, Damien need to scale on disk not because it's good, but because you can catch more with less hardware. Doing this you need to ...
varokism.blogspot.com
varokism: janvier 2011
http://varokism.blogspot.com/2011_01_01_archive.html
Lundi 17 janvier 2011. Muzing on NoSQL, damned! Can't get rid of InifiniDB. NoSQL have been frequently used for building analytic solutions. The big picture is using some scalable client code with m. Ap reduce to distribute full data scan. This approach have nothing new to the RDBMS world and can be considered an extension of the. Kimball ROLAP normalization, just allowing more CPU power on a single query. NoSQL or sharding take advantages on. Per column data type. Optimization and deserialization cost.
ourdelta.org
MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS | OurDelta
http://ourdelta.org/mariadb-5139
Enhanced, packaged convenience for MySQL and MariaDB. MariaDB 5.2 repository for RHEL/CentOS. MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS. MySQL 5.0.87-d10 OurDelta packages. Do you want to be an OurDelta mirror? MariaDB 5.1 packages for Debian and Ubuntu. MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS. Yum (RPM) or apt-get (DEB). MariaDB 5.1.39, courtesy of OurDelta. And in close cooperation with Monty Program Ab. Simply follow the info on the CentOS. Note: give the mirrors some hours to sync up).
ourdelta.org
November, 2009 | OurDelta
http://ourdelta.org/2009/11
Enhanced, packaged convenience for MySQL and MariaDB. MariaDB 5.2 repository for RHEL/CentOS. MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS. MySQL 5.0.87-d10 OurDelta packages. Do you want to be an OurDelta mirror? MariaDB 5.1 packages for Debian and Ubuntu. Archive for November, 2009. MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS. Yum (RPM) or apt-get (DEB). MariaDB 5.1.39, courtesy of OurDelta. And in close cooperation with Monty Program Ab. Simply follow the info on the CentOS. See the Release Notes.
ourdelta.org
MariaDB 5.1 packages for Debian and Ubuntu | OurDelta
http://ourdelta.org/mariadb-51-packages-for-debian-and-ubuntu
Enhanced, packaged convenience for MySQL and MariaDB. MariaDB 5.2 repository for RHEL/CentOS. MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS. MySQL 5.0.87-d10 OurDelta packages. Do you want to be an OurDelta mirror? MariaDB 5.1 packages for Debian and Ubuntu. MariaDB 5.1 packages for Debian and Ubuntu. You can now apt-get your way to MariaDB 5.1, courtesy of OurDelta. And in close cooperation with Monty Program Ab. To get started, simple follow the info on the Debian. MariaDB includes these new/replaceme...
varokism.blogspot.com
varokism: MariaDB world record price per row 0.0000005$ on a single DELL R710
http://varokism.blogspot.com/2013/12/mariadb-world-record-price-per-row.html
Mercredi 11 décembre 2013. MariaDB world record price per row 0.0000005$ on a single DELL R710. Don't look at an industry benchmark here, it's a real client story. 200 Billion records in a month and it should be transactional but not durable. For regular workload we use LOAD DATA INFILE into partitioned InnoDB, but here we have estimated 15TB of RAID storage. This is a lot of disks and it can't no more stay inside a single server internal storage. First let's check the compression with the dataset. Affic...
ourdelta.org
October, 2009 | OurDelta
http://ourdelta.org/2009/10
Enhanced, packaged convenience for MySQL and MariaDB. MariaDB 5.2 repository for RHEL/CentOS. MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS. MySQL 5.0.87-d10 OurDelta packages. Do you want to be an OurDelta mirror? MariaDB 5.1 packages for Debian and Ubuntu. Archive for October, 2009. MariaDB 5.1 packages for Debian and Ubuntu. You can now apt-get your way to MariaDB 5.1, courtesy of OurDelta. And in close cooperation with Monty Program Ab. To get started, simple follow the info on the Debian. MariaDB i...
it.wikipedia.org
MariaDB - Wikipedia
https://it.wikipedia.org/wiki/MariaDB
Da Wikipedia, l'enciclopedia libera. 10114 (10 maggio 2016). Relational database management system. Versione 2, GNU LGPL. Per la libreria client. Modifica dati su Wikidata. Nato da un fork. Originale di tale programma. Aperto ai contributi della comunità, l'area di sviluppo principale è lo storage engine. Precedentemente chiamato Maria, da qui MariaDB); si tratta di un'evoluzione di MyISAM. Viene dedicata attenzione anche ai plugin. SE non presenti in MariaDB. Segmentazione della Cache degli Indici.
SOCIAL ENGAGEMENT