A Paris,
Le 13 Novembre de l'an MMVII,
My dear Sir and Madam,
Ever be in a position of too-much traffic ?
Point is, if the traffic increases, then the server is slow.
TOP command on a Linux/Unix/Fedora Apache/2.0.50 shows :
- 50% of the CPU : for HTTPD process
- 20% of the CPU : for Analog Process
- 20% of the CPU : for MYSQLD Process
The direct analysis would pretend that HTTPD is the problem. BUT may
be HTTPD is waiting for MYSQLD answer.
We have problem to analyse the sources of the lack of performance.
1) Idea ONE was to split sub.domains within other servers with
independant databases merged and consolidated into a single one using
exchange of tables.
2) Idea TWO was to have MYSQL hosted on one server and sub.domains
split over different servers.
SERVER1 : MYSQL
SERVER2 : oaks.bobby.com
SERVER3 : liveoaks.bobby. com
SERVER4 : bobby.com
We know ebay is ebay.com and these administrators might split over
servers depending on variables that our team does not manage.
3) We tried to go with Idea TWO and we are facing a problem.
Creating a user on SERVER1
Name : bobbob
Data Privilege : SELECT
INSERT
UPDATE
DELETE
FILE
Information related to connections
Server : % (all servers)
FLUSH PRIVILEGES ;
Then, on SERVER2 :
<?
$host = "207.36.16. 15";
$user = "bobbob";
$pass = "bobbob";
$bdd = "adv_databa se";
?>
It does not work : Cannot access the database on SERVER1 from
SERVER2.
Even, we tried to add specfic provileges to bobbob.
Many Thanks for any operational answer from your knowledge and
background experience.
Norman 1 1460
On 13 Nov, 16:44, Pseudonyme <norman_cougl.. .@2cuk.co.ukwro te:
A Paris,
Le 13 Novembre de l'an MMVII,
My dear Sir and Madam,
Ever be in a position of too-much traffic ?
Point is, if the traffic increases, then the server is slow.
TOP command on a Linux/Unix/Fedora Apache/2.0.50 shows :
- 50% of the CPU : for HTTPD process
- 20% of the CPU : for Analog Process
- 20% of the CPU : for MYSQLD Process
The direct analysis would pretend that HTTPD is the problem. BUT may
be HTTPD is waiting for MYSQLD answer.
We have problem to analyse the sources of the lack of performance.
1) Idea ONE was to split sub.domains within other servers with
independant databases merged and consolidated into a single one using
exchange of tables.
2) Idea TWO was to have MYSQL hosted on one server and sub.domains
split over different servers.
SERVER1 : MYSQL
SERVER2 : oaks.bobby.com
SERVER3 : liveoaks.bobby. com
SERVER4 : bobby.com
We know ebay is ebay.com and these administrators might split over
servers depending on variables that our team does not manage.
3) We tried to go with Idea TWO and we are facing a problem.
Creating a user on SERVER1
Name : bobbob
Data Privilege : SELECT
INSERT
UPDATE
DELETE
FILE
Information related to connections
Server : % (all servers)
FLUSH PRIVILEGES ;
Then, on SERVER2 :
<?
$host = "207.36.16. 15";
$user = "bobbob";
$pass = "bobbob";
$bdd = "adv_databa se";
?>
It does not work : Cannot access the database on SERVER1 from
SERVER2.
Even, we tried to add specfic provileges to bobbob.
Many Thanks for any operational answer from your knowledge and
background experience.
Norman
I thought you were bob earlier on? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Petre Agenbag |
last post by:
Hi List
Been trying to help out with this problem on a SunOS5.8 box running
3.23.56
It experiences periodic lockups of mysql. It does not seem that this
server has a my.cnf file for mysql, and I'm not sure if that matters
(what are the defaults mysql use when it cannot find the .cnf file?)
Anyway, I have asked for any help in making a my.cnf file in other
|
by: Chris Moy |
last post by:
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: moyc
To: mysql@lists.mysql.com
Subject: Installation challenges - mysqld
>Description:
|
by: Bruce W...1 |
last post by:
I've got MySQL running as a service on my Windows 2000 box. And I can
work with it using a command window (DOS box). I used the default
install of MySQL and here's what status says:
mysql> status
--------------
mysql Ver 12.21 Distrib 4.0.15, for Win95/Win98
Connection id: 5
Current database:
|
by: Solange Ezveff |
last post by:
Object : How to optimize mysql architecture for better web connection
?
Hello, I use phpMyAdmin 2.3.2 and MySQL 3.23.58 and I do not know how
to well-organize mysql architecture for the user convience and
speedness.
On my web site, I call all the stucture from one table (5 colums and
50 rows).
|
by: Mike Chirico |
last post by:
Interesting Things to Know about MySQL
Mike Chirico (mchirico@users.sourceforge.net)
Copyright (GPU Free Documentation License) 2004
Last Updated: Mon Jun 7 10:37:28 EDT 2004
The latest version of this document can be found at:
http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download
| |
by: Adam Smith |
last post by:
I have a dedicated server running 'FreeBSD 4.9 STABLE' at a hosting
site. They have done some default installations, presumably from the CVS
ports package ??. Herein lies the problem, "I do not know" what they
have done!
At first it was apparent that MySQL was installed
mysql_install_db ; GRANT TABLES etc. ???
so I ran "mysql_install_db --force"
|
by: jlee |
last post by:
I'm pretty much a newbie on mysql, and I need some help.
I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4
(i386) on a server hosting an active website.
The site's developer uses his own php shopping cart to receive customer
orders.
The configuration was done via cPanel with no external modifications -
which produced no protests when built, ran and connected with no
|
by: dmcquay |
last post by:
Hi,
I am setting up MySQL on a development box. I have set it up and can
connect from localhost, but I cannot connect from another computer on
the network. I have narrowed down the problem quite a bit, but can't
quite figure it out still.
I am getting MySQL Error Number 2003 "Can't connect to MySQL server on
'server'. I know that the server is there because I can ping it. I am
also running a webserver from that computer and I am...
|
by: 2401 members, members can post |
last post by:
Dear Madams and Sirs,
Ever had to split a website + SQL Tables ?
Have a UNIX pc-linux-gnu on i686 + FEDORA
1) We have to split a sub-domain for the main domain name.
2) We have to build a transfer and merge from Tables hosted on Server
1 TO Tables hosted on Server 2.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |