[Maria-discuss] Innodb Page Compression

2015-05-13 Thread Rhys Campbell
Hello All, I have compiled mariadb 10.1.4 from source to have a play with innodb page compression. Not sure if these are bug or misunderstanding on my part, probably a combination of both... I am running in a CentOS 7 x64 VirtualBox VM 10.1.4-MariaDB-wsrep. The compile support for page compres

[Maria-discuss] doubt about best engine

2015-05-13 Thread Roberto Spadim
hi guys, i'm with doubt about the "best" engine (best = no INSERT lag ~0.100s or less, good SELECT speed ~ 1 to 10 seconds is ok) i have two tables, they only "receive" INSERT and SELECT queries (no DELETE/UPDATE/ALTER) they increase 200MB/day and 3.000.000 rows/day my doubt is, how to have small

Re: [Maria-discuss] doubt about best engine

2015-05-13 Thread Rhys Campbell
TokoDB is worth a shot certainly if your working set is disk bound. Partitioning might also be an option for you. From: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=tradingscreen@lists.launchpad.net] On Behalf Of Roberto Spadim Sent: 13 May 2015 17:39 To: Maria Discuss Subject:

Re: [Maria-discuss] doubt about best engine

2015-05-13 Thread Daniel Black
- On 14 May, 2015, at 2:39 AM, roberto robe...@spadim.com.br wrote: > i'm considering using spider engine or any other shard system with >100GB , or > maybe a big raid-6 system, > server is a xeon 8core with 16GB and 2hd 500GB RAID1 SAS (>180MB/s) raid6 sounds like a sure way to compromise I