mySQL and primary key

Ralph DiMola rdimola at evergreeninfo.net
Sun Apr 30 17:26:22 EDT 2023


JBV,

This looks like a server timeout. There is a mySQL server ini file parameter
"ExecTimeLimit" There is also a phpMyAdmin ini file "LoginCookieValidity"
timeout parameter. If you can't get those changed(especially "ExecTimeLimit"
so you can do it by script) you will be forced to create a new table with a
primary key and copy the data over in chunks small enough to avoid a
timeout.

Ralph DiMola
IT Director
Evergreen Information Services
rdimola at evergreeninfo.net

-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
Of jbv via use-livecode
Sent: Saturday, April 29, 2023 7:40 AM
To: How to use LiveCode
Cc: jbv at souslelogo.com
Subject: mySQL and primary key

Hi list,

I have a mySQL table with 13500000 entries that weights almost 20 Gb.
I need to create a primary key on the "id" column.
I have tried in phpMyAdmin as well as in a script with "ALTER TABLE myTable
ADD PRIMARY KEY(id)", but each time I get a "504 Gateway Timeout" error, and
no index is created.

What else can I try ?

Thank you in advance.
jbv

_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode




More information about the use-livecode mailing list