Right guys, I have a MySQL database, using InnoDB on tables, every so often I have to perform a big cron job that does a large batch of queries and inserts. When I run this cron job, for the 5minutes or so that it is running, no other page is able to load. As soon as it is done, the queries are executed and the page loads. The table th...
Hey all, I am trying to install a python module on my VPS and am running into the following problem once I try to run the install: virtual memory exhausted: Cannot allocate memory error: command 'gcc' failed with exit status 1 I tried a few things that I read online to try to solve this but have yet to have any luck. I spoke with a ...
Hi, I would like to start my mysql server with the --external-locking option. As mysqld is run by the /etc/init.d/mysql script ubuntu (karmic), I guess that's where I should set this "--external-locking" thing, just can't figure out where to put it(am far from expertise in shell scripting:). Could anyone please help me with that? Sett...
I am trying to run MySql 5.1 on Windows 7 Home Premium 64 bit. I have downloaded the MSI installer from the MYSql website and installed it. The installation is successful, but the service does not start. If I try to run MySql manually using the mysqld executable, it crashes immediately on running (error: mysqld.exe has stopped working)....
Couple days ago I got following error from MySQL database: Thread stack overrun: 68744 bytes used of a 196608 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. All documentation that I found says, that: The default is 64KB before MySQL 4.0.10 and 192KB thereafter. If the thread stack size ...
I have a table with ~800k rows. I ran an update users set hash = SHA1(CONCAT({about eight fields})) where 1; Now I have a hung Sequel Pro process and I'm not sure about the mysqld process. This is two questions: What harm can possibly come from killing these programs? I'm working on a separate database, so no damage should come to o...
One of my servers' OS crashed yesterday. It was Win 2008.The server developed an HDD fault and did not boot. My host provider (Turnkey) has mounted the HDD on a Rescue system and given me access to the HDD through SSH. I have been able to download the Mysql data folder and all the MYD, MYI, FRM files. (MyIsam db?). I tried changing my ...