I have a website that runs off a mysql database.
The first month it hit in excess of 400 threads.
Would anyone know whats the cheapest alternative to run a a site this size. Would a VPS account handle it?
if there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.
View 8 Replies View RelatedI just installed Windows 2K3 web on a dual xeon (hyperthreading).
When I check out the cpu threads in the "task manager", it only shows 2 cpu threads.
I have always installed win 2K3 std and it shows the 4 cpu threads. So my question is weather the web edition will only show the 2 cpu threads or am I missing something.
In the last day or two I've been having issues with memory on one of by boxes.
Something eats it all up, so the OS starts swapping, the I/O wait shoots up, and soon the load is up in the hundreds and the thing is totally useless.
During the day today I've tracked the something to occational apache processes. It seems that occationally a thread is started which uses upwards of 150M of memory. These threads are obvioudly doing something heavyweight and take a while to complete. When I get a few of them running together it soons finishes off all my available memory. Below is an extract from top when a couple of these threads are running.
Code:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
10230 nobody 25 0 197m 27m 9392 R 45.5 2.9 0:03.27 /usr/local/apache/bin/httpd -DSSL
10231 nobody 25 0 197m 25m 8376 R 52.8 2.7 0:01.60 /usr/local/apache/bin/httpd -DSSL
I was wondering if anyone could help out by suggesting some ways of tracking down what page/script it which uses so much memory. It's a cPanel server so it's not really practical to tail -f the apache logs (not knowing which account it is means I don't know which file to watch).
I have formated my linux Centos 4 server with PHP 4.4 and install Centos 5 with PHP 5.1 ( will upgrade to 5.2 soon ).
I succeed to restore all of my web sites and forums except one which has 110MB sql file, VBulletin 3.6.8.
I think the problem is related on my hack's and modifications I have done before...
Now I decided to install a new and fresh forum with version of 3.6.8 to be the same with ex one ( I will upgrade it after transferring ( migrating ) every threads, posts and members to new forum to 3.8.4)
But the problem is: when I restore the whole sql to new forum I had come across many problems.
THE QUESTION IS:
how can I transfer just "threads", "posts" and "members" to a new and fresh vBulletin forum ?
please note that my forum is not working now and I just have a "whole-website-backup.SQL" file and also back up of whole database folder in the linux ( it contains .frm , .MYD , .MYI files like: mst_post.frm , mst_post.MYD , mst_post.MYI and others...)
I have tried to copy these .frm .MYD and .MYI files on the new database folder but it was not worked!
I think I must restore by the help of .SQL file but I dont know how! when I recover whole the .SQL file forum does not work good and had some problem ( I can't log in to admin panel for example, and my VBSeo configurations gone and can't be repaire...
Please show me how can I transfer just my Posts and members to a NEW installed VBulletin forum with same or different "database name" and "database username".
I have Apache 2.4.6 x64 installation. With the lapse of time, more and more threads appear that are stuck in "L" state.
They are all gone after httpd restart, leaving 408 errors in access logs. What can be the reason?
Can mod_log_rotate be involved? Currently it's set to rotate every 2 days.
I'm trying to redirect some threads in vbulletin from full version to archive version, I just have some problems and I have not been able to resolve it.
I have the [URL] ...
and I want redirect to: [URL] ....
I have:
Options + FollowSymLinksRewriteEngine onRewriteRule ^showthread.php?([0-9]+)$ archive/index.php/t-$1 [R = 301, L]
Before i use: CubePanel and all my site run file. Scine i change to HostingController with PHP5.2.3 and mysql-essential-5.0.45 my site error:
[url]
Quote:
get_box('user_online'); $c_user_online = $tpl->get_block_from_str($html,'user_online'); $c = $tpl->auto_get_block($c_user_online); /* $c_mem = $tpl->get_block_from_str($c_user_online,'member',1); $c_mod = $tpl->get_block_from_str($c_user_online,'mod',1); $c_admin = $tpl->get_block_from_str($c_user_online,'admin',1); $c_this = $tpl->get_block_from_str($c_user_online,'this',1); */ $timeout = 60*30; $total = 0; $member = 0; $guest = 0; $current_time = NOW; $time_exit = $current_time - $timeout; $mysql->query("DELETE FROM ".$tb_prefix."online WHERE timestamp < ".$time_exit); $guests = $mysql->num_rows($mysql->query("SELECT DISTINCT sid FROM ".$tb_prefix."online WHERE sid != ''")); $member_sql = $mysql->query("SELECT user_id, user_name, user_level FROM ".$tb_prefix."user WHERE user_online = 1 AND user_timeout > ".$time_exit." ORDER BY user_timeout DESC"); $members = $mysql->num_rows($member_sql); $total = $guests + $members; while($r = $mysql->fetch_array($member_sql)){ $id = $r['user_id']; $level = $r['user_level']; $name = $r['user_name']; if ($id == $_SESSION['user_id']) $s = $c['this']; elseif ($level == 1) $s = $c['member']; elseif ($level == 2) $s = $c['mod']; elseif ($level == 3) $s = $c['admin']; $online_list .= $tpl->assign_vars($s, array( 'user.ID' => $id, 'user.NAME' => $name, 'user.URL' => '#User,'.$id, ) ); } $html = $tpl->assign_vars($html, array( 'TOTAL' => $total, 'GUESTS' => $guests, 'MEMBERS' => $members, ) ); $html = $tpl->assign_blocks_content($html, array( 'user_online' => $online_list, ) ); return $html; } ?>PHP Fatal error: Call to undefined function box_user_online() in D:WebspaceAKIT2ITonline.2it.inwwwincludesclass_template.php(86) : eval()'d code on line 1 Error in my_thread_global_end(): 3 threads didn't exit
I'm running Apache 2.4.4 on Windows Server 2008 R2. It's already happened many times that Apache stopped responding to requests. The last entry in the error.log:
[Wed Mar 27 06:22:07.043600 2013] [mpm_winnt:notice] [pid 1736:tid 256] AH00354: Child: Starting 64 worker threads.
[Wed Mar 27 06:52:34.521200 2013] [mpm_winnt:error] [pid 1736:tid 1656] AH00326: Server ran out of threads to serve requests. Consider raising the ThreadsPerChild setting
we recently switched from Microsoft ISA to Apache as a proxy to redirect customers to computers in DMZ. However, since the switch, our system always down due to the threading issue below
##################################################
[Wed Apr 03 08:15:56 2013] [notice] Child 131648: Child process is running
[Wed Apr 03 08:15:56 2013] [notice] Child 131648: Acquired the start mutex.
[Wed Apr 03 08:15:56 2013] [notice] Child 131648: Starting 1000 worker threads.
[Code].....
i been trying to move my server.. But mysql database is quite big and restoring takes ages 10 12 hours.. is there anyway i can make it quick because database dump takes 10 15mins but restore takes 12hours and it should be a way to make that quick
View 14 Replies View Relatedhow can i setup rsync to backup just mysql database (if possible) every 6 hours or so.
View 14 Replies View RelatedI have are the .frm, .MYD, .MYI how do I restore/rebuild the database?
View 3 Replies View RelatedMy server admin linked me to this:
[url]
I'm using a cpanel based server, but I can't get this to work.
It requires I be in a directory I figure (this step isnt included)
so I type cd /home/username/public_html/
And then i follow the commands. but it doesnt work.
Basically i need to take a mysql database that I uploaded to my directory, and load it back into a database. :@
I have a problem getting mysql to start, so I am planning to setup a new server and move all the mysql databases to a new server.
The problem is I normally get mysql databases when mysql is running by using mysql command lines. Now that I cannot start mysql, I cannot use that method.
Is there a mysql directory that contains all the mysql databases for me to tar it up and untar it on a different? If there is a directory that contains all the mysql databases, do I need to exclude some files/folders so it doesnt conflict with the files/folders on my new mysql server?
we have whm in my server
in whm is one part to name
Repair Mysql Database
this is only for one database
how may i repaired all database in my server?
what steps procedures need to be done to keep your database as safe as possible from the hackers. Anyway to be alert when someone got into your db and try to dump, alter your database?
View 4 Replies View RelatedI got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database.
It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs.
I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS.
I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem.
All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts.
I just added an hourly crontab so as to restart the MySQL server as a stop gap.
What is the recommended method of backing up big MySQL database of size 2 GB ?
Quote:
# mysqldump gallery > gallery.sql
mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES
#
I checked the table, it is fine, but can't do the backup.
Quote:
mysql> check table 10tir_user_group;
+-------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| gallery.10tir_user_group | check | status | OK |
+-------------------------+-------+----------+----------+
1 row in set (0.07 sec)
mysql>
ways to improve the database performance in the situation when I have to modify a large table (several million rows), by e.g. adding a column. Currently this would take several hours which is too slow. The bottleneck is disk I/O. I am considering either partitioning the table over several innodb files on several disks, or going to a RAID-5 or RAID-10, it this will give me better write performance.
The database is 130GB large, and the problem table (which I make period changes to) is the largest table on the server. I cannot have downtime of 3 hours each time I make a change and adding blank fields (to be used later, when a new field is needed) is not an option.
Each time I add a column, the cpu goes into high (80%) io wait state for about 3 hours.
I have a hack which would allow me to split the large table into multiple smaller tables based on some criteria (for example, forumID or such). Here are a couple of things but would like to know which is best, and am open to new ideas. The ideas so far:
1. Split the table into 3 or 5 smaller tables each on it's own disk. The disk IO would then not be so bad, and it might only take 1 hour to perform the table change. But this might not work because the changes to the database (as in adding a column) might be serial, meaning only 1 disk is being written to at a time. (Then again, maybe it will work if I launch 3 different scripts, one to update each table at once).
2. Do RAID 5 or 10, and have 3 or 5 disks. This again might not help at all because of the above issue with MySQL writing serially.
I am using latest MySQL 5.0.45 with InnoDB engine on Debian etch Linux
