59 messages in com.mysql.lists.clusterError when insert into tabele, Help!| From | Sent On | Attachments |
|---|---|---|
| Gurgen Petrosyan | 24 Aug 2004 06:32 | |
| Crouch, Luke H. | 24 Aug 2004 06:56 | |
| Crouch, Luke H. | 24 Aug 2004 21:49 | |
| Magnus Svensson | 25 Aug 2004 01:58 | |
| Lars Thalmann | 25 Aug 2004 04:21 | |
| Gurgen Petrosyan | 25 Aug 2004 06:02 | |
| Lars Thalmann | 25 Aug 2004 07:39 | |
| Gurgen Petrosyan | 25 Aug 2004 13:29 | |
| Tomas Ulin | 14 Sep 2004 02:37 | |
| Tomas Ulin | 14 Sep 2004 05:20 | |
| Gurgen Petrosyan | 14 Sep 2004 08:34 | |
| Gurgen Petrosyan | 14 Sep 2004 10:32 | |
| Gurgen Petrosyan | 14 Sep 2004 11:02 | |
| Tomas Ulin | 16 Sep 2004 06:35 | |
| Gurgen Petrosyan | 16 Sep 2004 12:38 | |
| Gurgen Petrosyan | 16 Sep 2004 13:10 | |
| Gurgen Petrosyan | 17 Sep 2004 12:56 | |
| Gurgen Petrosyan | 17 Sep 2004 14:41 | |
| Sharad Maloo | 20 Sep 2004 07:12 | |
| Gurgen Petrosyan | 20 Sep 2004 13:39 | |
| Magnus Svensson | 22 Sep 2004 05:28 | |
| Bruce Robertson | 22 Sep 2004 10:00 | |
| Gurgen Petrosyan | 22 Sep 2004 13:59 | |
| Gurgen Petrosyan | 22 Sep 2004 14:21 | |
| Gurgen Petrosyan | 22 Sep 2004 14:35 | |
| Gurgen Petrosyan | 22 Sep 2004 14:39 | |
| Gurgen Petrosyan | 22 Sep 2004 15:49 | |
| Mikael Ronström | 23 Sep 2004 00:20 | |
| Mikael Ronström | 23 Sep 2004 00:29 | |
| Gurgen Petrosyan | 03 Oct 2004 11:32 | |
| Crouch, Luke H. | 04 Oct 2004 06:12 | |
| Gurgen Petrosyan | 04 Oct 2004 13:58 | |
| pek...@mysql.com | 08 Nov 2004 05:16 | |
| Gurgen Petrosyan | 08 Nov 2004 12:51 | |
| Joseph E. Sacco, Ph.D. | 11 Nov 2004 05:18 | |
| Gurgen Petrosyan | 11 Nov 2004 05:25 | |
| Gurgen Petrosyan | 28 Nov 2004 08:47 | |
| Jonas Oreland | 29 Nov 2004 00:15 | |
| Klaus Byskov Pedersen | 18 Jan 2005 00:27 | |
| Mikael Ronström | 18 Jan 2005 02:14 | |
| Gurgen Petrosyan | 18 Jan 2005 07:21 | |
| Gurgen Petrosyan | 18 Jan 2005 08:47 | |
| Gurgen Petrosyan | 18 Jan 2005 09:00 | |
| Gurgen Petrosyan | 18 Jan 2005 09:17 | |
| Jon Stephens | 02 Feb 2005 09:03 | |
| Mikael Ronström | 02 Feb 2005 11:21 | |
| Gurgen Petrosyan | 02 Feb 2005 16:28 | |
| Jon Stephens | 02 Feb 2005 18:16 | |
| Jon Stephens | 07 Feb 2005 09:16 | |
| Gurgen Petrosyan | 07 Feb 2005 10:18 | |
| Gurgen Petrosyan | 09 Feb 2005 11:51 | |
| Stefan Hinz | 23 Feb 2005 06:12 | |
| Eric Bergen | 05 Mar 2005 11:36 | |
| Gurgen Petrosyan | 05 Mar 2005 12:56 | |
| Gurgen Petrosyan | 05 Mar 2005 14:00 | |
| Gurgen Petrosyan | 05 Mar 2005 14:15 | |
| Jon Stephens | 05 Mar 2005 18:20 | |
| Jon Stephens | 07 Mar 2005 07:35 | |
| Gurgen Petrosyan | 07 Mar 2005 11:39 |
| Subject: | Error when insert into tabele, Help!![]() |
|---|---|
| From: | Gurgen Petrosyan (gur...@ipia.sci.am) |
| Date: | 01/18/2005 07:21:18 AM |
| List: | com.mysql.lists.cluster |
Hello! We had a problem!
At us is 1 MGM node and 4 DB nodes! Each of 5 computers have 1Gb operative memory! We have created 3 SQL a file (everyone on 900Mb) each of which has consisted of 10 000 000 lines
insert into big_table_a set a1='213123', a2='123123', a3='213124', a4='234234'; insert into big_table_a set a1='213123', a2='978433', a3='234234', a4='2535623'; ............................
Through API node we have started this SQL a script with the help of a command
source data1.sql; source data2.sql; source data3.sql;
When in a database already has entered the name more than 14 000 000 lines MySQL Cluster has given out the following mistake:
ERROR 1114: The table 'big_table_a' is full
Please help to solve this problem!
Here we config.ini maybe a mistake in it?
###################### [COMPUTER DEFAULT]
[DB DEFAULT] NoOfReplicas: 1
[MGM DEFAULT] ArbitrationRank: 1
[TCP DEFAULT] PortNumber: 28002
[COMPUTER] Id: 1 HostName: 192.168.1.21
[COMPUTER] Id: 2 HostName: 192.168.1.22
[COMPUTER] Id: 3 HostName: 192.168.1.23
[COMPUTER] Id: 4 HostName: 192.168.1.24
[COMPUTER] Id: 5 HostName: 192.168.1.25
[MGM] Id: 1 ExecuteOnComputer: 1 PortNumber: 29000
[DB] Id: 2 ExecuteOnComputer: 2 IndexMemory: 100M DataMemory: 700M
[DB] Id: 3 ExecuteOnComputer: 3 IndexMemory: 100M DataMemory: 700M
[DB] Id: 4 ExecuteOnComputer: 4 IndexMemory: 100M DataMemory: 700M
[DB] Id: 5 ExecuteOnComputer: 5 IndexMemory: 100M DataMemory: 700M
[API] Id: 6 ExecuteOnComputer: 1 ########################




