What are size limits for mysql on Ubuntu 18.04 and how can I increase them?Was there some kind of Ubuntu...
What is the philosophical significance of speech acts/implicature?
Could the terminal length of components like resistors be reduced?
Is there a way to generate a list of distinct numbers such that no two subsets ever have an equal sum?
Map of water taps to fill bottles
How can I practically buy stocks?
On The Origin of Dissonant Chords
Why was the Spitfire's elliptical wing almost uncopied by other aircraft of World War 2?
Dynamic SOQL query relationship with field visibility for Users
Initiative: Do I lose my attack/action if my target moves or dies before my turn in combat?
Critique of timeline aesthetic
Rivers without rain
Minor Revision with suggestion of an alternative proof by reviewer
How did Captain America manage to do this?
How do I check if a string is entirely made of the same substring?
Is it idiomatic to construct against `this`
Can we say “you can pay when the order gets ready”?
can anyone help me with this awful query plan?
bldc motor, esc and battery draw, nominal vs peak
Was there a Viking Exchange as well as a Columbian one?
Why does nature favour the Laplacian?
Implications of cigar-shaped bodies having rings?
How much cash can I safely carry into the USA and avoid civil forfeiture?
Like totally amazing interchangeable sister outfits II: The Revenge
Function pointer with named arguments?
What are size limits for mysql on Ubuntu 18.04 and how can I increase them?
Was there some kind of Ubuntu upgrade that can cause this kind of behaviour?Apache Timeout (Problem loading page) on localhostError establishing a database connection several times a weekMySQL Job cannot start - Can't find error, need databaseUnable to access remotely (LAMP issue)Cannot enter phpmyadmin as root (MySQL 5.7)Mariadb not working just after install on Ubuntu 16.04mysql and memory problems in ubuntu 16.04 serverHow to increase open files limit mysql in linuxMy server index.php is showing a blank pageUpgrading to PHP 7.2 (from 7.0) broke MySQLi functions on NGINX server
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
Background: I am running a cqpweb, a corpus query interface written in PHP and connected to a mysql database, on an Apache2 webserver under Ubuntu 18.04 LTS. The Ubuntu server was set up from scratch and there are currently no manual configurations to mysql or php.
cqpweb ran happily unless it started throwing out error messages like this one:
A MySQL query did not run successfully!
Original query: LOAD DATA LOCAL INFILE '/data2/cqpweb/cach/tab_dist_fycel9oplk' INTO TABLE `db_dist_g2f3ndxf40` FIELDS ESCAPED BY '' /* from User: knappen |
Function: create_db() | 2019-Apr-25 11:23:01 */
Error # 0:
This happened overnight, no updates or other changes to the system occurred. Therefore I suspect that some size limit of the database was reached and that I will have to increase it.
Question: What are some size limits for mysql databases and how can I increase them?
Additional information:
php --version
PHP 7.2.17-0ubuntu0.18.04.1 (cli) (built: Apr 18 2019 14:12:38) ( NTS )
mysql --version
mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper
Size of mysql:
root@corpora:/var/lib/mysql# du -h ./
23M ./mysql
676K ./sys
16G ./cqpweb
1.1M ./performance_schema
16G ./
Error log: There are no related messages in /var/log/mysql/error.log
.
Running the database query manually from the mysql prompt (under the same database user as cqpweb) succeeds (to my big surprise).
EDIT: Raw disk space is not an issue—there is enough space left on the device.
EDIT2: I tried a brute force approach to the basic problem, did a backup of the data in the database using mysqldump
, destroying the database, reinstalling mysql-server, restoring the database from the dump; reducing the size from 16G to 11G, but the original problem persists.
server 18.04 apache2 mysql php
add a comment |
Background: I am running a cqpweb, a corpus query interface written in PHP and connected to a mysql database, on an Apache2 webserver under Ubuntu 18.04 LTS. The Ubuntu server was set up from scratch and there are currently no manual configurations to mysql or php.
cqpweb ran happily unless it started throwing out error messages like this one:
A MySQL query did not run successfully!
Original query: LOAD DATA LOCAL INFILE '/data2/cqpweb/cach/tab_dist_fycel9oplk' INTO TABLE `db_dist_g2f3ndxf40` FIELDS ESCAPED BY '' /* from User: knappen |
Function: create_db() | 2019-Apr-25 11:23:01 */
Error # 0:
This happened overnight, no updates or other changes to the system occurred. Therefore I suspect that some size limit of the database was reached and that I will have to increase it.
Question: What are some size limits for mysql databases and how can I increase them?
Additional information:
php --version
PHP 7.2.17-0ubuntu0.18.04.1 (cli) (built: Apr 18 2019 14:12:38) ( NTS )
mysql --version
mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper
Size of mysql:
root@corpora:/var/lib/mysql# du -h ./
23M ./mysql
676K ./sys
16G ./cqpweb
1.1M ./performance_schema
16G ./
Error log: There are no related messages in /var/log/mysql/error.log
.
Running the database query manually from the mysql prompt (under the same database user as cqpweb) succeeds (to my big surprise).
EDIT: Raw disk space is not an issue—there is enough space left on the device.
EDIT2: I tried a brute force approach to the basic problem, did a backup of the data in the database using mysqldump
, destroying the database, reinstalling mysql-server, restoring the database from the dump; reducing the size from 16G to 11G, but the original problem persists.
server 18.04 apache2 mysql php
add a comment |
Background: I am running a cqpweb, a corpus query interface written in PHP and connected to a mysql database, on an Apache2 webserver under Ubuntu 18.04 LTS. The Ubuntu server was set up from scratch and there are currently no manual configurations to mysql or php.
cqpweb ran happily unless it started throwing out error messages like this one:
A MySQL query did not run successfully!
Original query: LOAD DATA LOCAL INFILE '/data2/cqpweb/cach/tab_dist_fycel9oplk' INTO TABLE `db_dist_g2f3ndxf40` FIELDS ESCAPED BY '' /* from User: knappen |
Function: create_db() | 2019-Apr-25 11:23:01 */
Error # 0:
This happened overnight, no updates or other changes to the system occurred. Therefore I suspect that some size limit of the database was reached and that I will have to increase it.
Question: What are some size limits for mysql databases and how can I increase them?
Additional information:
php --version
PHP 7.2.17-0ubuntu0.18.04.1 (cli) (built: Apr 18 2019 14:12:38) ( NTS )
mysql --version
mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper
Size of mysql:
root@corpora:/var/lib/mysql# du -h ./
23M ./mysql
676K ./sys
16G ./cqpweb
1.1M ./performance_schema
16G ./
Error log: There are no related messages in /var/log/mysql/error.log
.
Running the database query manually from the mysql prompt (under the same database user as cqpweb) succeeds (to my big surprise).
EDIT: Raw disk space is not an issue—there is enough space left on the device.
EDIT2: I tried a brute force approach to the basic problem, did a backup of the data in the database using mysqldump
, destroying the database, reinstalling mysql-server, restoring the database from the dump; reducing the size from 16G to 11G, but the original problem persists.
server 18.04 apache2 mysql php
Background: I am running a cqpweb, a corpus query interface written in PHP and connected to a mysql database, on an Apache2 webserver under Ubuntu 18.04 LTS. The Ubuntu server was set up from scratch and there are currently no manual configurations to mysql or php.
cqpweb ran happily unless it started throwing out error messages like this one:
A MySQL query did not run successfully!
Original query: LOAD DATA LOCAL INFILE '/data2/cqpweb/cach/tab_dist_fycel9oplk' INTO TABLE `db_dist_g2f3ndxf40` FIELDS ESCAPED BY '' /* from User: knappen |
Function: create_db() | 2019-Apr-25 11:23:01 */
Error # 0:
This happened overnight, no updates or other changes to the system occurred. Therefore I suspect that some size limit of the database was reached and that I will have to increase it.
Question: What are some size limits for mysql databases and how can I increase them?
Additional information:
php --version
PHP 7.2.17-0ubuntu0.18.04.1 (cli) (built: Apr 18 2019 14:12:38) ( NTS )
mysql --version
mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper
Size of mysql:
root@corpora:/var/lib/mysql# du -h ./
23M ./mysql
676K ./sys
16G ./cqpweb
1.1M ./performance_schema
16G ./
Error log: There are no related messages in /var/log/mysql/error.log
.
Running the database query manually from the mysql prompt (under the same database user as cqpweb) succeeds (to my big surprise).
EDIT: Raw disk space is not an issue—there is enough space left on the device.
EDIT2: I tried a brute force approach to the basic problem, did a backup of the data in the database using mysqldump
, destroying the database, reinstalling mysql-server, restoring the database from the dump; reducing the size from 16G to 11G, but the original problem persists.
server 18.04 apache2 mysql php
server 18.04 apache2 mysql php
edited 11 hours ago
jknappen
asked 15 hours ago
jknappenjknappen
105118
105118
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Therefore I suspect that some size limit of the database was reached and that I will have to increase it.
I doubt it. If you reach a limit those get reported (probably /var/log/mysql/error.log
, and/or /var/log/mysql.log
).
What are some size limits for mysql databases and how can I increase them
These limitation are NOT editable:
InnoDB permits up to 4 billion tables.
MySQL has hard limit of 4096 columns per table
The maximum tablespace size is four billion pages (64TB), which is also the maximum size for a table.
MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).
But you are no where near those.
Other limitation can be enforced by editing /etc/my.cnf
but if there are you added them.
A MySQL query did not run successfully!
This notice says nothing uselful.
Your problem is with the function create_db
and MySQL is throwing an error. In theory it could indeed be a limitation of MySQL but the odds on the query being wrong are a lot higher. Maybe there is a (double)quote or some other character in the data that is not processed correctly. Or there is a JOIN not correct and due to the amount of data MySQL now believes it needs to use another INDEX (a SELECT with an ORDER BY that has a lot of the same values or has NULL values in a field tends to switch INDEX a lot in my experience).
You probably need to find out what the SQL command actually is and examine it or the results of the execution.
Without the actual content of the function and an example of your database there is not a lot to go on.
It is really spooky: Just cutting and pasting the SQL query from the error message into mysql works for the query.
– jknappen
10 hours ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1138303%2fwhat-are-size-limits-for-mysql-on-ubuntu-18-04-and-how-can-i-increase-them%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Therefore I suspect that some size limit of the database was reached and that I will have to increase it.
I doubt it. If you reach a limit those get reported (probably /var/log/mysql/error.log
, and/or /var/log/mysql.log
).
What are some size limits for mysql databases and how can I increase them
These limitation are NOT editable:
InnoDB permits up to 4 billion tables.
MySQL has hard limit of 4096 columns per table
The maximum tablespace size is four billion pages (64TB), which is also the maximum size for a table.
MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).
But you are no where near those.
Other limitation can be enforced by editing /etc/my.cnf
but if there are you added them.
A MySQL query did not run successfully!
This notice says nothing uselful.
Your problem is with the function create_db
and MySQL is throwing an error. In theory it could indeed be a limitation of MySQL but the odds on the query being wrong are a lot higher. Maybe there is a (double)quote or some other character in the data that is not processed correctly. Or there is a JOIN not correct and due to the amount of data MySQL now believes it needs to use another INDEX (a SELECT with an ORDER BY that has a lot of the same values or has NULL values in a field tends to switch INDEX a lot in my experience).
You probably need to find out what the SQL command actually is and examine it or the results of the execution.
Without the actual content of the function and an example of your database there is not a lot to go on.
It is really spooky: Just cutting and pasting the SQL query from the error message into mysql works for the query.
– jknappen
10 hours ago
add a comment |
Therefore I suspect that some size limit of the database was reached and that I will have to increase it.
I doubt it. If you reach a limit those get reported (probably /var/log/mysql/error.log
, and/or /var/log/mysql.log
).
What are some size limits for mysql databases and how can I increase them
These limitation are NOT editable:
InnoDB permits up to 4 billion tables.
MySQL has hard limit of 4096 columns per table
The maximum tablespace size is four billion pages (64TB), which is also the maximum size for a table.
MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).
But you are no where near those.
Other limitation can be enforced by editing /etc/my.cnf
but if there are you added them.
A MySQL query did not run successfully!
This notice says nothing uselful.
Your problem is with the function create_db
and MySQL is throwing an error. In theory it could indeed be a limitation of MySQL but the odds on the query being wrong are a lot higher. Maybe there is a (double)quote or some other character in the data that is not processed correctly. Or there is a JOIN not correct and due to the amount of data MySQL now believes it needs to use another INDEX (a SELECT with an ORDER BY that has a lot of the same values or has NULL values in a field tends to switch INDEX a lot in my experience).
You probably need to find out what the SQL command actually is and examine it or the results of the execution.
Without the actual content of the function and an example of your database there is not a lot to go on.
It is really spooky: Just cutting and pasting the SQL query from the error message into mysql works for the query.
– jknappen
10 hours ago
add a comment |
Therefore I suspect that some size limit of the database was reached and that I will have to increase it.
I doubt it. If you reach a limit those get reported (probably /var/log/mysql/error.log
, and/or /var/log/mysql.log
).
What are some size limits for mysql databases and how can I increase them
These limitation are NOT editable:
InnoDB permits up to 4 billion tables.
MySQL has hard limit of 4096 columns per table
The maximum tablespace size is four billion pages (64TB), which is also the maximum size for a table.
MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).
But you are no where near those.
Other limitation can be enforced by editing /etc/my.cnf
but if there are you added them.
A MySQL query did not run successfully!
This notice says nothing uselful.
Your problem is with the function create_db
and MySQL is throwing an error. In theory it could indeed be a limitation of MySQL but the odds on the query being wrong are a lot higher. Maybe there is a (double)quote or some other character in the data that is not processed correctly. Or there is a JOIN not correct and due to the amount of data MySQL now believes it needs to use another INDEX (a SELECT with an ORDER BY that has a lot of the same values or has NULL values in a field tends to switch INDEX a lot in my experience).
You probably need to find out what the SQL command actually is and examine it or the results of the execution.
Without the actual content of the function and an example of your database there is not a lot to go on.
Therefore I suspect that some size limit of the database was reached and that I will have to increase it.
I doubt it. If you reach a limit those get reported (probably /var/log/mysql/error.log
, and/or /var/log/mysql.log
).
What are some size limits for mysql databases and how can I increase them
These limitation are NOT editable:
InnoDB permits up to 4 billion tables.
MySQL has hard limit of 4096 columns per table
The maximum tablespace size is four billion pages (64TB), which is also the maximum size for a table.
MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).
But you are no where near those.
Other limitation can be enforced by editing /etc/my.cnf
but if there are you added them.
A MySQL query did not run successfully!
This notice says nothing uselful.
Your problem is with the function create_db
and MySQL is throwing an error. In theory it could indeed be a limitation of MySQL but the odds on the query being wrong are a lot higher. Maybe there is a (double)quote or some other character in the data that is not processed correctly. Or there is a JOIN not correct and due to the amount of data MySQL now believes it needs to use another INDEX (a SELECT with an ORDER BY that has a lot of the same values or has NULL values in a field tends to switch INDEX a lot in my experience).
You probably need to find out what the SQL command actually is and examine it or the results of the execution.
Without the actual content of the function and an example of your database there is not a lot to go on.
edited 10 hours ago
answered 10 hours ago
RinzwindRinzwind
211k28406541
211k28406541
It is really spooky: Just cutting and pasting the SQL query from the error message into mysql works for the query.
– jknappen
10 hours ago
add a comment |
It is really spooky: Just cutting and pasting the SQL query from the error message into mysql works for the query.
– jknappen
10 hours ago
It is really spooky: Just cutting and pasting the SQL query from the error message into mysql works for the query.
– jknappen
10 hours ago
It is really spooky: Just cutting and pasting the SQL query from the error message into mysql works for the query.
– jknappen
10 hours ago
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1138303%2fwhat-are-size-limits-for-mysql-on-ubuntu-18-04-and-how-can-i-increase-them%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown