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

Re: [Maria-discuss] doubt about best engine

2015-05-13 Thread Rhys Campbell
: [Maria-discuss] doubt about best engine 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) th

[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