Stack Overflow
Stack Overflow

Questions tagged [memory-table]

25 questions
17
votes
4 answers

Indexing every column in a table

I have a couple of questions regarding MySQL indexing: 1) Is there any speed increase when indexing a table stored in memory? 2) When searching my table I match on column field, would indexing every column defeat the purpose of an index? Many…
Linus Norton
  • 557
  • 1
  • 4
  • 15
15
votes
2 answers

Change max_heap_table_size value?

There's a max_heap_table_size limit to 16 mb so how can i change this value and where?
Krueger
  • 1,178
  • 3
  • 11
  • 26
4
votes
3 answers

Why not use MySQL like memcached?

For the same reason it makes sense to use both NoSQL and RDBMSs in one application, It makes sense to me to have an RDBMS cache besides NoSQL cache. I was thinking about using a MySQL server with all tables using the memory engine. Is there any…
Itay Moav -Malimovka
  • 52,579
  • 61
  • 190
  • 278
4
votes
2 answers

How to run a MySQL query on every service start?

I need to run a query to populate a memory table on every MySQL start. Is there any way to do this?
stramin
  • 2,183
  • 3
  • 29
  • 58
4
votes
2 answers

How long will a temporary MEMORY table persist if I don't drop it (MySQL)

I'm using a recursive stored procedure in MySQL to generate a temporary table called id_list, but I must use the results of that procedure in a follow up select query, so I can't DROP the temporary table within the procedure... BEGIN; /* generates…
oucil
  • 4,211
  • 2
  • 37
  • 53
2
votes
1 answer

How to change Delphi FireDAC tFDMemTable field name in design-time

I try to change the field name of FDMemTable1field1 which is 'field1' to 'field3'. There is no code and all is done in design-time. TForm1 = class(TForm) DBGrid1: TDBGrid; DataSource1: TDataSource; FDMemTable1: TFDMemTable; …
SHIN JaeGuk
  • 494
  • 1
  • 5
  • 14
2
votes
1 answer

Memory table's primary key must be HASH, why?

I want to use a memory table as a set of queues. So, there'll be a memory table with int column a and b. with queries like: SELECT b FROM table WHERE a=? ORDER BY b DESC LIMIT 1000 I tried this: create table `test_table` ( `a` int(11) not null, …
bellscape
  • 43
  • 6
1
vote
1 answer

Proper use of MySQL Memory Tables for performance

I have a table that has 60 columns (and thousands of rows) and it references to 15 catalog tables and 3 of those reference to another 3 catalog tables (the whole database is less than 1 GB). These tables are used to perform some "onchange" search…
prueba prueba
  • 652
  • 1
  • 8
  • 26
1
vote
1 answer

Delphi 10.2: Using Local SQL with Firedac Memory Tables

How can I use Firedac LocalSQL with FDMemtable? Is there any working example available? According to the Embarcadero DocWiki I set up a local connection (using SQLite driver), a LocalSQL component and connected some Firedac memory tables to it. Then…
MichaSchumann
  • 1,361
  • 1
  • 17
  • 36
1
vote
2 answers

mysql, force limited entries in a table

I keep some temporary data in a memory table. I only need the 20 most recent entries and would prefer the data is always be on the heap. How should i accomplish this? i am sure theres nothing i can do about the memory table but how should i handle…
user34537
1
vote
0 answers

MySQL Out of memory when copy Innodb Table to memory table

I am getting this error when copying table to table, even there is plenty of space ( 36 GB) and memory ( 09 GB). insert into time_series_funds_mem select * from time_series_funds; MySQL said: Documentation #5 - Out of memory (Needed 260748 bytes)…
H Aßdøµ
  • 2,925
  • 4
  • 26
  • 37
1
vote
0 answers

TFDMemtable FieldDefs does not consider lookup fields?

Using Delphi 10.2.3, I dropped in a form a Firedac TFDMemTable component which was I used Field Editor to define 5 fields, one of those fields is a Lookup Field (FieldKind = fkLookup) . I created a code to scan all fields of the MemSource…
JRG
  • 513
  • 9
  • 23
1
vote
2 answers

Mysql: what to do when memory tables reach max_heap_table_size?

I'm using a mysql memory table as a way to cache data rows which are read several times. I chose this alternative because I'm not able to use xcache or memcache in my solution. After reading the mysql manual and forum about this topic I have…
Lucia
  • 4,657
  • 6
  • 43
  • 57
1
vote
2 answers

Trying to create a memory table in mysql through php

I am trying to create a memory table in mysql through php but i keep getting an error: Error creating database: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near…
Brad Hazelnut
  • 1,603
  • 5
  • 21
  • 33
1
vote
1 answer

Inserting data into memory table

I have created a MEMORY table. I want to load the data from my MyIsam table (say PIN_DETAILS) into MEMORY table (say PIN_DETAILS_MEMORY). When I try to dump the data of MyISAM table into MEMORY table (using INSERT INTO...SELECT), only 8190 rows get…
Saurabh
  • 1,405
  • 1
  • 21
  • 42
1
2