Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,665 questions
Mysql in app table in use
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 19%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Regil Das
0
Reputation points
from morning our mysql in app table in windows webapp. is in use and can't access bcos it says no table space. this is an important table so our webapp is down. Pls help asap
{count} votes
-
Deleted
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
-
Regil Das 0 Reputation points
2025-03-18T03:37:25.27+00:00 pls call asap as I am in trouble
-
Regil Das 0 Reputation points
2025-03-18T04:39:46.14+00:00 can u tell me how to restart MySQL in app in windows web app?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 36%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Shree Hima Bindu Maganti 3,990 Reputation points Microsoft External Staff2025-03-18T11:11:50.1566667+00:00 Hi @Regil Das D
It seems you are encountering an issue with your MySQL in-app table being in use and displaying a "no table space" error. This problem might arise if the MySQL in-app feature isn't functioning correctly in your Azure App Service instance.Access your website to initiate the necessary processes, including the MySQL in-app process.
Check that MySQL in-app is running by using the Process Explorer to confirm that
mysqld.exeis listed among the processes.
Open-source technologies FAQs for Web Apps in AzureTutorial: Build a JBoss web app with Azure App Service on Linux and MySQL (azure-portal)
Let me know if you have any further assistances. -
Regil Das 0 Reputation points
2025-03-19T02:10:26.54+00:00 Sorry for the delay. I am travelling. Mysql server is already running as i can use php myadmin and see all the tables are ok. only one table which is large is in use. our web app is working based on this but for the sections which needs this table which confirms all is ok with Mysql
-
Regil Das 0 Reputation points
2025-03-19T11:09:52.99+00:00 I am forced to say it is very pathetic support from you. How can you be so lazy in responding to a critical issue? Horrible
-
Shree Hima Bindu Maganti 3,990 Reputation points Microsoft External Staff
2025-03-19T11:28:41.0433333+00:00 Hi @Regil Das
Apology for the Delay Response.
"If your MySQL table is inaccessible because it is 'in use,' it is likely locked due to an ongoing transaction or insufficient tablespace. First, check active queries usingSHOW PROCESSLIST;and identify if any long-running transactions are blocking access. You can manually kill problematic queries withKILL process_id;. If the table is locked, try unlocking it usingUNLOCK TABLES;. If the issue is due to insufficient tablespace, increase the InnoDB buffer pool size (innodb_buffer_pool_size=1G) in MySQL configuration and restart the database. Additionally, check free disk space on your server (df -hfor Linux or checking available storage on Windows). If the table remains inaccessible, restoring from a backup might be necessary. For further guidance, refer to MySQL Troubleshooting Docs."
Let me know if you have any further assistances. -
Regil Das 0 Reputation points
2025-03-19T11:37:19.5633333+00:00 Hello is there a chance we can talk over phone? This is very urgent. If u need to upgrade my support plan , that is ok if we can talk and settle it
-
Regil Das 0 Reputation points
2025-03-19T11:51:36.77+00:00 I have mant questions. Please respons asap at least.
- How do i restart the My SQL in app? just toggle the off and on in the MySQL in app section under the windows web app?
- I used SHOW PROCESSLIST. it is not giving any results other than the SHOW PROCESSLIST query itself
- Ran UNLOCK TABLES . it returned an empty result set
- How can I restore a single table in My sql In app from a back up?
- Not able to backup our databases as Mysql server dies during back up I think
There r many many questions. with your present pattern of answering it in a gap of 1 day, we are not going to solve this in a week . which means I will have to shut my shop
-
Regil Das 0 Reputation points
2025-03-19T11:52:48.3133333+00:00 question 6. How can I increase innodb_buffer_pool_size in mysql in app where we have limited control?
-
Regil Das 0 Reputation points
2025-03-19T12:14:40.4766667+00:00 If I restart the webapp ( which I have never done before) will it just restart with present data in web and Mysql in app or it will be starting with no data and mysql which means i am finished?
-
Regil Das 0 Reputation points
2025-03-19T12:48:13.81+00:00 I just stopped the webapp and started and the issue is fixed at least for now. But i am not happy with the resolution as this may repeat. I understand that azure cannot be used for mission critical purposes seeing your response. You are giving me no other option but to port to other services
Sign in to comment
Sign in to answer