MySQL Getting Started And Stopped All The Time (by Innodb )

Jan 6, 2007

MySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:

070106 14:40:25 InnoDB: Started; log sequence number 5 959534492
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$
A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown
070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted
070106 14:40:40 InnoDB: Starting shutdown...
070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492
070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete
070106 14:40:42 mysqld ended
070106 14:40:42 mysqld started
070106 14:40:42 InnoDB: Started; log sequence number 5 959534492

View 4 Replies



Feb 25, 2008

It was recommended by my software vendor that I use MyISAM and stay away from InnoDB.

InnoDB is the default storage engine on my box, but I have no InnoDB's at this time.

Everything says MyISAM (in phpMyAdmin). Could I just reinstall SQL (with MyISAM) from scratch? Or will I need to backup and reload from dump?

View 6 Replies View Related

Mysql Replication Stopped

Jul 23, 2008

I had configured mysql replication for one of my client. Now the replication is stopped and slave server is not updating the data. How can I resolve this and start the replication again?

View 7 Replies View Related

Plesk 12.x / Linux :: Batch MySql Script Stopped

Oct 2, 2014

I've this terrible problem: on my site I start a script that executes a batch process that imports into the Mysql database a lot of products (texts and images). I'm monitoring the query process from Phpmyadmin>Status and I notice that after some minutes the number of queries decreases from ~900 to ~30, that means that the script is stopped! Then I check the error_log and infact there's this error:

[Thu Oct 02 17:09:34 2014] [warn] [client] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server
[Thu Oct 02 17:09:34 2014] [error] [client] Premature end of script headers: insert_products.php

Some informations:
VPS server: 1 CPU; 40gb; RAM 1GB
OS: CentOS 6.5 (Final)
Plesk version: 12.0.18

What I tried via SSH console:

# /usr/local/psa/admin/bin/php_handlers_control --list
id: display name: version: type: cgi-bin: cli-bin: php.ini:

module 5.3.3 5.3.3 module /usr/bin/php-cgi /etc/php.ini
fastcgi 5.3.3 5.3.3 fastcgi /usr/bin/php-cgi /etc/php.ini
cgi 5.3.3 5.3.3 cgi /usr/bin/php-cgi /etc/php.ini
# /usr/bin/php-cgi -v


View 2 Replies View Related

Mysql Is Restaring All The Time

Jun 5, 2008

Mysql is restarting all the time, but when I look at the log file, I got the following error message. Anyone has any idea about this issue?

080604 22:48:45 InnoDB: Started; log sequence number 0 1304279005
080604 22:48:45 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
080604 22:48:45 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.45-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
080604 22:48:46 [Note] /usr/sbin/mysqld: Normal shutdown

080604 22:48:46 InnoDB: Starting shutdown...
080604 22:48:49 InnoDB: Shutdown completed; log sequence number 0 1304279005
080604 22:48:49 [Note] /usr/sbin/mysqld: Shutdown complete

View 11 Replies View Related

MySQL Take Too Much Time To Start

May 7, 2008

My MySQL server take too much time to start. I moved the data folder to its own hard disk, but still no improvement.

# uptime;date;service mysqld start;date;uptime;service httpd start
05:46:15 up 5 days, 1:24, 2 users, load average: 0.24, 1.07, 1.23
Wed May 7 05:46:15 CDT 2008
Starting MySQL: [ OK ]
Wed May 7 06:04:21 CDT 2008
06:04:21 up 5 days, 1:42, 1 user, load average: 1.77, 1.65, 1.50
Starting httpd: [ OK ]

You see MySQL take 18 minutes to start.

This happens whenever i restart the server or restart mysql.

Here is the process while MySQL starts

# ps aux|grep mysql
root 23549 0.0 0.0 4448 1168 pts/0 S+ 05:24 0:00 /bin/sh /sbin/service mysqld start
root 23556 0.0 0.0 4628 1272 pts/0 S+ 05:24 0:00 /bin/bash /etc/init.d/mysqld start
root 23613 1.5 7.5 157668 154580 pts/0 D+ 05:24 0:01 chown -R mysql:mysql /backup/mysql
root 23780 0.0 0.0 3896 664 pts/1 S+ 05:26 0:00 grep mysql

It is chown that make the MySQL startup slow.

MySQL data size is about 11 GB.

View 2 Replies View Related

MySQL Long Procees Time

Jul 11, 2007

I've got a 2.8 Dual Xenon with 2GB of ram. Taking a look at my "top" output I see the following:

18119 nobody 15 0 20812 20M 9764 S 0.8 0.9 0:05 0 httpd
3388 mysql 16 0 105M 97M 1908 S 0.7 4.8 95:08 1 mysqld
22225 nobody 15 0 18920 18M 9060 S 0.7 0.9 0:02 2 httpd
3391 mysql 16 0 105M 97M 1908 S 0.5 4.8 95:33 1 mysqld
13612 nobody 15 0 16872 16M 7192 S 0.4 0.8 0:05 3 httpd
21871 nobody 15 0 20712 19M 7768 S 0.4 0.9 0:02 2 httpd

I've got MySQL process running 95+ minutes. This isn't the first time it's happened.

I've seen it go as high as 120 minutes. The load average is 1.2. All my sites that use MySQL i.e. Wordpress blogs all run fine.

Looking at "MyTop" output everything looks normal:

MySQL on localhost (4.0.27-standard) up 37+01:40:24 [20:42:31]
Queries: 39.9M qps: 13 Slow: 211.0 Se/In/Up/De(%): 87/01/04/01
qps now: 9 Slow qps: 0.0 Threads: 20 ( 1/ 49) 64/04/09/09
Cache Hits: 27.5M Hits/s: 9.0 Hits now: 4.4 Ratio: 79.3% Ratio now: 73.3%
Key Efficiency: 100.0% Bps in/out: 571.7/961.9 Now in/out: 941.1/385.6k

Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
1263533 root localhost mysql 0 Query show full processlist
1263663 gwz3phj_v localhost gwz3phj_va 8 Sleep
1262512 DELAYED gwz3phj_va 9 Delaye Waiting for INSERT
1263618 gwz3phj_v localhost gwz3phj_va 9 Sleep
1263658 gwz3phj_v localhost gwz3phj_va 15 Sleep
1263659 gwz3phj_v localhost gwz3phj_va 15 Sleep
1263617 gwz3phj_v localhost gwz3phj_va 22 Sleep
1263651 gwz3phj_v localhost gwz3phj_va 22 Sleep
1263642 gwz3phj_v localhost gwz3phj_va 37 Sleep
1263640 gwz3phj_v localhost gwz3phj_va 43 Sleep
1263636 gwz3phj_v localhost gwz3phj_va 52 Sleep
1263633 gwz3phj_v localhost gwz3phj_va 53 Sleep
1263630 gwz3phj_v localhost gwz3phj_va 55 Sleep
1263631 gwz3phj_v localhost gwz3phj_va 55 Sleep
1263624 gwz3phj_v localhost gwz3phj_va 74 Sleep
1263625 gwz3phj_v localhost gwz3phj_va 75 Sleep
1263623 gwz3phj_v localhost gwz3phj_va 78 Sleep
1263615 gwz3phj_v localhost gwz3phj_va 79 Sleep
1263621 gwz3phj_v localhost gwz3phj_va 85 Sleep
1263616 gwz3phj_v localhost gwz3phj_va 88 Sleep

Overall my server is running just fine but these odd long running MySQL process have me worried.

View 3 Replies View Related

How To Setting Mysql Date/time

Mar 5, 2007

how to setting mysql data / time?

server have -9 H from our

We have setting under WHM for time server but we also need to setting mysql

View 1 Replies View Related

Very Slow Query Time After Upgrade To Mysql 5

Apr 8, 2009

We have a dedicated server and we host 4 news portals based on e107 and joomla.

My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.

We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !

Does anybody know if this is makes sense ?

Below is the server Status from WHM :

cpdavd up
cpsrvd up
exim (exim-4.69-15.1_cpanel_maildir) up
ftpd up
httpd (2.2.11 (Unix)) up
imap up
interval up
mysql (5.0.67-community-log) up
named (9.3.4) up
pop up
rsyslogd up
spamd up
syslogd up
Server Load 6.97 (1 cpu)
Memory Used 49.4 %
Swap Used 0.23 %
Disk /dev/hda3 (/tmp) DMA+ 70 %
Disk /dev/hda5 (/) DMA+ 22 %
Disk /dev/hda1 (/boot) DMA+ 14 %

Below is the Server Information from WHM :
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Processor #1 speed: 2394.068 MHz
Processor #1 cache size: 2048 KB

Memory Information

Memory: 2064420k/2087424k available (2091k kernel code, 21752k reserved, 846k data, 236k init, 1169920k highmem)

System Information

Linux 2.6.20-1.2319.fc5 #1 Mon May 21 19:52:13 EDT 2007 i686 i686 i386 GNU/Linux

Physical Disks

hda: WDC WD3200AAJB-00TYA0, ATA DISK drive
hda: hw_config=600d
hda: hw_config=600d
hda: max request size: 512KiB
hda: 625142448 sectors (320072 MB) w/8192KiB Cache, CHS=38913/255/63<6>hda: hw_config=600d
hda: cache flushes supported

Current Memory Usage

total used free shared buffers cached
Mem: 2066428 1756324 310104 0 339576 486636
-/+ buffers/cache: 930112 1136316
Swap: 1052248 2428 1049820
Total: 3118676 1758752 1359924

Current Disk Usage

Filesystem Size Used Avail Use% Mounted on
/dev/hda5 288G 60G 213G 22% /
/dev/hda1 99M 13M 82M 14% /boot
tmpfs 1009M 0 1009M 0% /dev/shm
/dev/hda3 494M 215M 254M 46% /tmp

Below is the CPU/Memmory/Mysql Usage from WHM :
Top Process%CPU 42.7/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/ --skip-external-locking
Top Process%CPU 42.6/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/ --skip-external-locking
Top Process%CPU 1.3httpd [urll] [/e107_plugins/pm/pm.php?inbox]
Top Process%CPU 1.1httpd [url] [/e107_plugins/forum/forum_viewforum.php?87]
Top Process%CPU 1.0httpd [url] [/e107_plugins/chatbox_menu/chatbox_iframe.php]
Top Process%CPU 0.5httpd [] [/www/delivery/lg.php?bannerid16&campaignid4&zoneid5&chan]
Top Process%CPU 0.4httpd [] [/www/delivery/lg.php?bannerid50&campaignid6&zoneid15&cha]
Top Process%CPU 0.3httpd [] [/www/delivery/lg.php?bannerid183&campaignid77&zoneid1&ch]
Top Process%CPU 1.1httpd [] [/index.php?optioncom_fireboard&Itemid188&funcshowcat&cat]
Top Process%CPU 0.5httpd [] [/images/fbfiles/avatars/s_64.png]
Top Process%CPU 0.3httpd [] [/index2.php?optioncom_jim&taskxml&no_html1]
Top Process%CPU 0.2[kjournald]
Top Process%CPU 0.1httpd [] [/e107_images/banners/banner468x60-alexandroupolinet.gif]
Top Process%CPU 0.1httpd [] [/racing/images/galfas_R40_banner.jpg]

View 8 Replies View Related

Mysql Overloaded - Time To Move To A Real Server / VPS

Mar 21, 2008

After 2 years of application hosting on i have overloaded their mysql servers for the forth time and now if i overload them again i'll get banned.

Each time i got overloaded My database was taken away for a almost a week and i had to beg everyone / write a letter to the CEO so they'll return the database.

I now need to sireously move to a VPS / Dedicated server
or my database will be deleted permenantly including all my 10 gigabytes of usergenerated data and content heh.

The wrost thing is i can't even monitor these overloads and ixwebhosting just take away your databases and say "STOP, you overloaded!" that's it - you're screwed.

I really modified my scripts these 2 days so i won't overload them again and get the final booting (that's after i paid 2 years upfront - 260$), but guess what, they can't even tell me if i'm now overloading the servers after i done all the tweaking.

Guess it's time to get all the data to my comuter before they say i have overloaded again and all my 12 my sites get blown away.

I need to switch fast i don't have much time as it seems and my most important site has 8k unique visitors per day - that's why the over loading occurs, heh, because im just too big - UNLIMITED MY ARSE.

I've been looking for a host and the best i found (after 2 days of forum readings and google searching ) where:

1. inmotionhosting VPS.
2. DDS.

Please any suggestion / comments to where should i go to host will save my buissness, my main concern is my 8k per day site with 2.5 page views per user and 2 mysql queries per page.

looking for a good company with managed everything (I know nothing about hardware managment - i'm a php / mysql geek at the most) and technical support with great uptime and a good ping / connection to israel's area is a big plus.

View 16 Replies View Related

Just Getting Started With Colo

Aug 23, 2007

I have a friend running a Sun v40z server with VMWare, and I am currently renting a virtual "box" from him. I'm just getting my feet wet with this, so I told him to start me out really low and let me work up as I see the need.

He has started me with a 512kbps 95th percentile plan. I am planning on hosting a few smaller sites in my area that would probably at most use a gig of bandwidth or so per month. I've tried doing the math etc, but I am finding it hard to find a general number of sites like this that I could run without overages. I realize I can spike over my 512 for 36 hours or less per month without overages, I would just like an idea of how many sites like I described it would take to do so. ^_^;

So I figured I would ask the folks with experience in this area, before I go out and sell a bunch of accounts I can't handle without some intense overages.

I am using DirectAdmin on this server also, if that's of any relevance.

View 2 Replies View Related

Plesk 11.x / Linux :: Importing To MySQL Database - Maximum Execution Time

Nov 5, 2014

I have this error when i put import to mysql database

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<script></script><p>ERROR: Maximum execution time of 300 seconds exceeded (Util.' at line 244

I have in domain > doemainname >
Geef een aangepaste waarde op 0

and insert in
usr/local/psa/admin/htdocs/domains/databases/phpmyadmin in the file following command
$cfg['ExecTimeLimit'] = 70000;

but it will not work...

View 2 Replies View Related

Started A Vbulletin Forum And Site

Apr 16, 2008

I am about to purchase a vbulletin license in a few days and start a site. I will start the forums first and get the talking going and build the main site afterwards. Of course the site will suck at first as far as visitors. But what is a good hosting plan to support me for a good little while? I project we'll get up to 150 active users at a time within the first 6 or 7 months with about 50 browsing the main site....(nothing wrong with wishful thinking )

So, what hosting plan is best to hold me for a while? Not which company, but what specs of the plan are best to hold 100 active users at a time? I dont want to continue to upgrade my hosting plan alot. I'd rather just buy a nice shared hosting plan now to hold me for at least a year or so....until I have to upgrade.

For those who have dedicated servers, at one point is it time to upgrade to a dedicated server?

View 13 Replies View Related

Apache HTTP Started But Not Accessible

Aug 30, 2013

I was trying to set up a JBoss cluster with apache httpd mod cluster in windows.I was able to start the apache using the command 'httpd. exe'. But when I tried to access it using localhost:6666/mod_cluster_manager , the page was not accessible.I have the entry localhost in my hosts file.

The http.conf contains lines as given below:

# Adjust to you hostname and subnet.
<IfModule manager_module>
ManagerBalancerName mycluster


View 2 Replies View Related

Very High Load When Daily Backup Started

Jul 9, 2008

to decrease the load in server when daily backup start ,, the load in server before backup start from 0.80 to 1.20 after daily backup started i see very high load from 16.00 to 32 and 40

any solve for decrease load when backup start from 3 to 7 alot

View 7 Replies View Related

VMWare ESXi 4.0 Network Started Consuming Up To 100 Mbps

Oct 20, 2009

I have 4 VMs running on a VMWare ESXi 4.0 server and it was running fine until yesterday when suddenly the network started consuming up to 100 mbps and making everything slow.

I have checked through vSphere and I dont see any VM consuming that much, it only show that the host is using that much.

I am attaching the picture from vSphere.

View 9 Replies View Related

From JaguarPC (1+ Year) To GlowHost (just Started) - My Experience And Reviews So Far

Jun 12, 2009

I've been with JaguarPC for over a year. I hosted two sites, one on VPS, another on semi-dedicated. I had to give up VPS after a couple of months when it turned out it was impossible to upgrade my operation system despite several attempts.

Today I'm canceling the second site on semi-dedicated server even though at first it was good (and cheap compared others). Unfortunately, over time the server was getting less and less reliable, there were frequent outages and connection problems. It seemed I was usually the first one to spot the problem and I opened a ticket; one of them had a dozen or so replies as I would post almost every day that the site was down or slow. So I had to leave this semi-dedicated too.

JaguarPC positives:

despite server performance issues, they have fast and friendly support; I liked to work with these guys and they showed patience. They even offered me free upgrade on VPS to a better operational system, but I chose to move on to try other waters

they were flexible enough to install software I needed without problems

JaguarPC negatives:

server problems, probably some overselling and/or not enough attention to the bad guys with buggy or heavy websites

Now I moved to and pay over two times as much for a semi-dedicated server. Here are my first impressions:

server seems OK so far,

support - they are also fast (probably even faster than JPC), even though they seem not to be as flexible as JaguarPC regarding installation of common software. For example, I asked them to install zlib to use gzip compression, but they said they know better and gzip compression is not something that would benefit my site and I would have to move to a dedicated server to have it installed (?). I was a little surprised since even some regular shared hosts have zlib library installed and I would think a semi-dedicated server (with no more than 30 domains on the server as it's possible to host only one domain and considering the price) should be treated as something more than just a shared server and users who choose semi-dedicated server actually do it to improve performance over shared server.

Either way, I'll see how it goes later; as long as the server is stable and fast I guess I shouldn't complain.

View 13 Replies View Related

Apache :: All Of Sudden Server Error Log Started Outputting A Very Strange Message

Apr 4, 2015

I've had a server running for a year or so and all of the sudden the server error log started outputting a very strange message that i've never seen before:

'groups' is not recognized as an internal or external command, operable program or batch file.

From what I understand this means apache is trying to run a program that doesn't exist, what could be triggering this?

Running Apache/2.4.9 on win2008.

View 1 Replies View Related

Enable InnoDB

Jun 29, 2009

how to enable innodb

use this command in mysql ....

View 4 Replies View Related

Hostgator And InnoDB

Sep 27, 2008

I finally found a shopping cart that I think will fit my needs. I registered a hosting account with Hostgator a couple months ago so that I'm now out of the refund period. It's great for my Wordpress site, but I got an error when I tried to install LiveCart. It said that I need InnoDB. I contacted Hostgator's support, and they said that they don't support InnoDB. Is that true? I don't want to have to move hosts and be out my year of hosting fees.

View 6 Replies View Related


Feb 11, 2008

What is more suitable for shared web hosting?

View 8 Replies View Related

Anyone Moved To InnoDB

Jun 5, 2007

Question for people who have moved to InnoDB: I wonder if it is worthwhile?

I don't care about ACID compliance, my only interest is in the row level locking which I do not get with large MYISAM tables which do table locking and clog up everything. I have a huge database that needs frequent updates, like 50,000 per hour. I also don't care about InnoDB's large size of indexes and such, I have lots of hard disk to throw at it.

My fear is with the backup of InnoDB tables, and the fact that it is not as simple to "fire up" the tables when I restart the database. MySQL manual suggests something like a query to "Warm up" the tables.

Any thoughts would be great, and if possible, any help with what settings you use. FYI, I am on a 4GB RAM machine with dual Core2Duo procs. When I tried the following in my.cnf for the InnoDB stuff ---

# Set the log file size to about 25% of the buffer pool size
innodb_log_group_home_dir = /iblogs
innodb_log_files_in_group = 2
--- the MySQLD wouldn't start! Question about the stuff in red: what're those paths for?

Do I need to create those paths?

View 6 Replies View Related

Plesk 12.x / Linux :: Postfix Smtp Suddenly Started Issuing Relay Access Denied On All Recipients

Jul 10, 2015

After setting up a new server on Plesk12, I successfully ran some test mail outs using phpmailer using the SMTP server on this machine

However, there was an issue in creating new local mail accounts in plesk with an error message each time.

Investigating this issue led me to a solution that I should run mail_restore from the Plesk scripts

This cured the problem of setting up new local accounts but outgoing SMTP mail is always failing with 'relay access denied'.

View 1 Replies View Related

Squirrelmail: Email Arrives With Different Time Than Server Time

Nov 11, 2008

This is a rare issue i have on a RHEL 5.2 + cPanel server.

Server time is:

Tue Nov 11 17:02:51 CST 2008
Squirrelmail time show:
Last Refresh:
Tue, 5:02 pm

So, that is correct too..

But email arrives with -4 hours time, example: 1:03 pm testing email

I already rebooted httpd, exim, and imap server, and the server itself too.. and problem stills.

View 11 Replies View Related

Innodb Database Server Setup (for Dummies)

Jun 12, 2008

I'm getting ready to setup a dedicated server for a site that is database intensive that mostly uses mysql innodb databases.

What is the best setup for me that would allow regular database backups of my innodb databases the easiest way possible. I basically want to be able to backup my database at a regular interval (probably weekly) without having to think too much (and without having to shut down my server each time or stop my database).

I'm not too tech savvy with database management so am after tips on:

- Best server setup (second drive just for bakups?)

- I Don't fully understand RAID 1 setups and how they would benefit me

- Explain to me the backup process for any solution you suggest

View 9 Replies View Related

Copyrights 2005-15, All rights reserved