… name a few: the big LOAD DATA INFILE clogs the binary log and slows replication down. If the load takes 4 hours on the… sql_log_bin=0; set unique_checks=0; load data local infile ‘infile.txt’ into table load_test fields terminated by ‘\t’ lines terminated…_log_bin=0; set unique_checks=0; load data local infile ‘/tmp/my-fifo’ into table load_test fields terminated by ‘\t’ lines terminated…
Post: Announcing Percona Server 5.5.25a-27.1
July 21, 2012 By Leave a Comment
…. When used with no argument, the LOAD_FILE() function will always return NULL. The LOAD DATA INFILE and SELECT INTO OUTFILE statements will… –secure-file-priv option so it cannot execute this statement”. LOAD DATA LOCAL INFILE is not affected by the –secure-file-priv option…_STATS. Bug fixed #896439 (Stewart Smith). Fixed typo for log_slow_verbosity in the code. Bug fixed #987737 (Stewart Smith). Removed…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/data/d1/AirData…load text data ( I really wish developers improve documentation), but finally I ended up with next load statement: /usr/local…like scanning wide range of rows, the slowness here is similar to Q0. -Q8: As…
Comment: To UUID or not to UUID ?
March 15, 2007 By 28 Comments
… slow. Regarding data load – at BoardReader.COM we have about 1 bil of forum posts right now and more than that of links loaded, with some 5 millions of new posts per day coming in. I’m not sure how it compares to your data… data locality such as it is easy to retrieve all links for given domain and it is fast because they are physically local…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
…) fits in memory. What is fast when data is in memory can be extremely slow if it does not. For example if… not want to piss of your most loyal users with slow page load times. So for IO bound applications you will need… index for ORDER BY .. LIMIT. For IO bound applications Clustering (data locality) also becomes very important – if Innodb tables are used having…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data…local_infileblogpercona.commanual local…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… 100 children to keep with the load. This Formula looks right from glance … your operations are local – meaning you only deal with your local network – Database Server, File…slow at getting the data back. There were page downloads taking 10 minutes+ in the apache status. As it was accepting the data…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… table. Among other things compression for data pages and uncompressed index pages can … removed most of the 768 byte local storage in the record. In that …kernel’s buffer pool. In high load situations where INNODB is using most… having to seek on disk which slows down throughput. If we could control…
Post: Caching techinques
August 8, 2006 By 11 Comments
…data long term – ie if you got it from some Web Service. For smaller short lived objects things like memcached (or local… Search requests – they just were way to slow, while some of them was very frequent…. most frequent and complicated queries as new data is loaded and index is rebuilt. Version based…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…The recent versions of Connector/J include load-balancing and failover features, but …storing the position in $_SESSION lead to local storage and limit scalabilty? A: … you speedy access to recently-changed data on a given database instance, …. Q: If a slave is slow because of bandwidth issues, the …
