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
0 answers

INSERT ... ON DUPLICATE KEY UPDATE Database / Engine

I'm currently writing a PHP application that processes large amounts of data and writes them to MySQL. I use Percona MySQL with TokuDB engine but it is difficult to handle. The application currently makes about 400 - 800 inserts / updates per second…
the_root
  • 329
  • 3
  • 9
0
votes
0 answers

MariaDb Slow Query log - only query time is high

I have the following entry in my slow query log: Query_time: 4.000347 Lock_time: 0.000095 Rows_sent: 0 Rows_examined: 0 update `my_table` set `a` = null, `b` = 'x', c= ... (updating around 20 fields) where `id` = 1234; id is the primary key in…
brent
  • 1,095
  • 1
  • 11
  • 27
0
votes
0 answers

TokuDB select distinct awfully slow

I have a table using the TokuDB engine in MariaDB 10.2 The table has a currently about ~700 Million measurements for ~2500 sensors. I want to get all the distinct sensor names in the table. There is a index of this names. Still, MariaDB seems to do…
Josef
  • 1,467
  • 2
  • 24
  • 40
0
votes
1 answer

tokuDb setting for time to timesout a statement

In a mariadb table with tokuDb engine; I am ecountering the below error - either on a delete statement; whilst there is a background insert load, and vice versa. Lock wait timeout exceeded; try restarting transaction Does tokuDb user a setting that…
brent
  • 1,095
  • 1
  • 11
  • 27
0
votes
0 answers

tokudb insert speed with binlog on way slower than innodb?

TokuDB alone beat InnoDB in our benchmarks by about 25% but when I turn master-slave on InnoDB now beats TokuDB by about 20% Any idea what's going on here's the conf that's running on a r4.8xlarge aws…
Jason
  • 3
  • 5
0
votes
1 answer

MariaBD + Fedora 24 + TokuDB

It seems that TokuDB is not available in Fedora 24 + MariaDB 10.1.17. 2016-09-23 18:17:56 140514451392704 [ERROR] TokuDB is not initialized because jemalloc is not loaded I have jemalloc and jemalloc-devel installed My…
gdm
  • 7,647
  • 3
  • 41
  • 71
0
votes
0 answers

TokuDB Concurrent Inserts cause lock timeouts

I have concurrent batch inserts with around 1000 records per batch, on a TokuDB 7.5. Each batch update is done within a single transaction. The table contains around 100 million records too. The issue is that it throws the following exception time…
psaw.mora
  • 868
  • 1
  • 7
  • 18
0
votes
0 answers

An erroneous subquery working in few conditions & fails in others?

Following two queries are exactly same, except the country name. In Query 1 its 'Malaysia' & in Query 2 its 'India'. The query itself is erroneous; Since I am using "ac.country" in first subquery whereas i actually needed to use "ass.country", but…
Vaibhav Sawant
  • 1
  • 1
0
votes
1 answer

MySQL TokuDB engine using too much CPU

I have converted tables of a database from InnoDB to TokuDB and i noticed that with TokuDB, reads are using way too much CPU. Why is this? To be more specific, the server with TokuDB tables is a slave of a server with InnoDB which is part of the…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
0
votes
1 answer

TokuDB size_allocated vs size_in_use

Alhough TokuDB offers great compression, from what i see it wastes a lot of space by allocating a lot more than it actually needs. I'm using the information_schema to get the size, as follows: SELECT table_name, table_dictionary_name, …
changepicture
  • 466
  • 1
  • 4
  • 10
0
votes
1 answer

processing abort of transaction mariadb

Im using mariadb 10.0.20 created two tables with tokudb engine . table1 structure : CREATE TABLE `table1` ( `id` varchar(28) NOT NULL, `tin` varchar(50) DEFAULT NULL, `uid` varchar(12) NOT NULL , `process_flag` char(2)…
maverick
  • 171
  • 1
  • 9
0
votes
1 answer

mysql replication (TokuDB replica): Column X of table 'database.table' cannot be converted from type 'varchar(Y)' to type 'varchar(Y)'

Experienced this error when reviewing the output of SHOW SLAVE STATUS\; this is the excerpt from the status output: Last_SQL_Errno: 1677 Last_SQL_Error: Column 1 of table 'database.table' cannot be converted from type…
Drew
  • 6,311
  • 4
  • 44
  • 44
0
votes
1 answer

Mysql Not Returns Data But Data Are There

Very strange problem today. Query as simple as basic math: MariaDB [betradar]> select id,id_event,id_bookmaker from event_outcome where id like '%16069689%'; +----------+----------+--------------+ | id | id_event | id_bookmaker…
gdm
  • 7,647
  • 3
  • 41
  • 71
0
votes
1 answer

Duplicate Entry Mysql TokuDB Wiht Many Clients

I have a strange situation. Suppose I have a very simple function in php (I used Yii but the problem is general) which is called inside a transaction statement: public function checkAndInsert($someKey) { $data =…
gdm
  • 7,647
  • 3
  • 41
  • 71
0
votes
3 answers

SQL statement Join three tables

i have the following statement SELECT di_id, di_name, di_location, ig_name, in_latitude, in_longitude FROM dam_info LEFT JOIN instrument_group ON ig_diid = di_id LEFT JOIN instruments ON…
Muhaimin
  • 1,643
  • 2
  • 24
  • 48
1 2
3
4