Stack Overflow
Stack Overflow

Questions tagged [tokudb]

TokuDB is a storage engine for MySQL that is designed for high performance on write-intensive workloads while providing high compression and schema flexibility.

TokuDB is a storage engine for MySQL that is designed for high performance on write-intensive workloads. It uses Fractal Tree indexing, which is based on cache-oblivious algorithms (algorithms designed to take advantage of a CPU cache without having the size of the cache as an explicit parameter). TokuDB also enables high compression and schema flexibility, as indexes can be added and columns add/dropped/expanded without downtime.

51 questions
0
votes
1 answer

starting mysql without procedures

I am getting the following error and tokudb does not start. I restored the data from some other server / version and now the proc table column count is different. 131119 16:53:44 [ERROR] Incorrect definition of table mysql.proc: expected column…
shantanuo
  • 31,689
  • 78
  • 245
  • 403
0
votes
0 answers

TokuDB Status & reliability

I have been looking at ways to keep a lid on the potential size of a mySQL DB in the webapp that I plan to get into beta soon. The DB has the potential to become very big. Having examined what I am doing I found that using the file system to store…
DroidOS
  • 8,530
  • 16
  • 99
  • 171
0
votes
2 answers

improve mysql load data

Is there any mysql parameter to improve the speed of "LOAD DATA INFILE " ? I am using 1 MyISAM and 1 TokuDB table. The data is saved as Tab separated text file.
shantanuo
  • 31,689
  • 78
  • 245
  • 403
0
votes
2 answers

Questions about improving the performance of Mysql concurrent insert and read data

Basic info: My Mysql database is using TokuDB, InnoDB, MyIsam tables. Server info: 16 core, 64GB RAM, CentOS 6.2, MySQL v 5.5 Process: 1. Import large amount data from one text file to one TokuDB table. 2. Select data by joining different…
Nick Ren
  • 65
  • 3
  • 10
0
votes
1 answer

Does "Concurrent Insert" improve Database INSERTION speed?

I need to insert very large amount of data(over 1 billion rows) to one table. I used TokuDB as my Database Engine. And I know it supports "Concurrent Insert". I'm just wondering if I have a very powerful server to host my DB. Does the "Concurrent…
Nick Ren
  • 65
  • 3
  • 10
-1
votes
1 answer

TokuDB: insert into select... cases table lock

I'm running 2 concurrent statements: Insert into tab2 select * from tab1 where ....; -- tab1 is a partitioned tokudb table Insert into tab1 values (...); tab1 acquires a table lock, and the 2nd insert is waiting for "Waiting for table level…
Younes
  • 375
  • 4
  • 16
1 2 3
4