….11 sec) mysql> insert into article_comment values(4300000000,1); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> insert into article_comment values(4300000001,1….00 sec) mysql> insert into article_comment values(4300000002,1); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> select * from article_comment; +————+————+ | article_id | comment_id…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…MySQL up and running: Insert…mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES; +——————–+———+—————————————————————————-+————–+——+————+ | Engine | Support | Comment…article. …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…” which is quite helpful for MySQL Performance optimization tasks but there… retrieve data from table. Avoid comment (and space) in the start of…inserts so you can see how much of inserted queries are used: Qcache_hits/Qcache_inserts… great. I should write an article comparing performance of various …
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… that many other blogs and articles have about this security risk. …/sql-antipatterns Jonathan C. also commented: Q: My preferred variable parameter format: bug_… onto their database server. Their MySQL server became CPU-bound, while… or parameterize to ensure you insert data values safely, and then …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… of this article I have showed how I align IO,…IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings….s a lot of data being modified, inserts are done to random positions (not … some numbers to share, please leave a comment. Next, I plan to look at IO…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…not have full schema specified in the article itself so it results are …problem which can be fixed in MySQL 5.1 Data Clustering This …scattered all across. Lookups Later in comments Brian mentions the point of benchmarks…assumptions. I promised to publish some insert benchmark for this case with larger…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… explain. Before I get to main topic of the article lets comment on IO vs Disk question. If you look … IO bound or CPU bound, while to understand if MySQL goes through more rows than it needs to requires … you’re to modify) – even if you’re doing INSERT you will need to fetch clustered index page at …
