Wishlist 0 ¥0.00

IBM收购红帽的启示:开源时代已经来临

企业能否通过免费的开源软件盈利——混合云端基建巩固了开源软件在科技领域的地位。

免费开放软件确实可以真正的创收,而证明这一点的开源运动已经持续长达20年之久;迄今为止最有力的证据便是先进的技术,IBM以高达340亿美元的价格收购了红帽公司(Red Hat Inc.)。

作为早期参与并支持开源运动的IBM,其期望借助收购红帽的为公司带来2.6亿美元的利润,并解决公司目前销量持续下滑的危机。在这个收购协议达成之前,开源世界已经达成了三项收购案:分别是Cloudera公司和Horton Works公司完成了5.2亿美元的全股并购;Salesforce.com以6.5亿美元买下了Mulesoft公司;以及微软公司以7.5亿美元收购GitHub。

这波收购浪潮证明了两点:其一,开源软件绝不仅仅是全球各地的开发人员在业余时间贡献代码。 从“开源”一词创建后的20年来看,很多公司正在通过为开源项目增加价值来赚取收入。 例如,Cloudera发布安全版本的Apache Hadoop和其他开源软件。;Red Hat以其企业版Linux,Red Hat Linux而闻名。

BTIG的分析师Edward Parker在本月早些时候的“解锁开源难题”报导中称:“十年来,经过试验和失败得出的经验已经产生了更加精细的策略和商业模式,其中大多人或公司使用不同的方法来利用开源代码,同时捕捉其专有模型的经济规律,”

另一点是云计算的下一阶段,即混合云,它将由越来越多的开放源软件组成。混合云是指在私有云端和公共云端中拥有自己内部混合云端 - 例如亚马逊的Amazon Web Services或微软的Azure。

IBM首席执行官银尼·罗睿兰在周一早上的电话会议上告诉分析师,目前客户希望IBM能够做到“跨越多个云端并且无锁定地转移他们的企业数据”。

“这就是我们两家正在一起做的事情,”其中罗睿兰说的两家是指IBM和红帽。

IBM需要将自己的营收重回增长模式。 经过两个季度短暂的收入增长,IBM的进步极大程度上来源于新的大型机系统带来的收入激增。尽管IBM将云计算和人工智能作为未来的增长模式,然而IBM上一个季度的收入缺出现下滑,但公共云业务现在由AWS和Azure主导,因此IBM需要考虑超越公共云端以实现新的增长。

罗睿兰在电话会议中指出,IBM的调查报告显示其客户只将工作内容的10%-20%转移到云端,所以混合云可能更成功,这对客户来讲是个好的选择,因为客户不想转移其拥有的所有数据。

福雷斯特研究公司的分析师克里斯·加德纳表示,“IBM一直试图解决这个问题。他们的云端产品选择非常有限。 他们试图将混合云端定位为解决方案以此去深入研究。 这有助于混合云的下一步进展。“分析师表示,对于试图将数据从一个云端安全地移动到另一个云端的公司而言,开源软件更具模块化和灵活性。

就在Linus Torvalds公开发布Linux操作系统内核两年后,在1993 Red Hat创立。这是一款免费版本的软件,就像Unix一样(是AT&T实验室开发的安全且昂贵的操作系统,用于工作站和企业巨头终端服务器,并由惠普和IBM共同开发)。 Red Hat Linux于1994年万圣节发布,几年后,Red Hat成为开源领域首批上市的公司之一,同时也是为数不多几个经历20多年后幸存下来的开源公司。

451研究公司的分析师杰伊莱曼说:“即使他们已经被收购了,Red Hat总会代表一个答案,‘如果你放弃使用代码,你将会怎么赚钱?’对于开发者来说,Red Hat是开源世界的典范。在他们开始的时候,开源是一种爱好以及极客的代表。”

IBM也是Linux早期的支持者。早期,曾有数百名IBM软件开发人员将自己的业余时间投入到Linux;并且于2000年,公司表示将采用Linux系统且投入10亿美元用于支持IBM的服务器,软件和服务。

红帽公司的产品和技术总裁保罗·科米尔在周日宣布IBM交易后的一篇博客中重新回顾了公司历史。

“开源爱好者之间的激情永远不会让红帽(或Linux)成为企业级软件中的一员。”罗睿兰写到关于公司在2002年“农场赌注”的决定。“我们放弃了免费下载源,将其包装为红帽Linux(Red Hat Linux),用企业订阅模式取代它,与此同时,保留了开源自由的原则,创建一个长期可持续的商业模式。“

现在一个很大的问题仍然是IBM能否做到像其承诺的那样,让Red Hat自由发展,从而它的产品可以独立于任何竞争对手,例如IBM的AIX(Unix版本)。在历史悠久的IBM和程序开发员建立的Red Hat中,有许多程序员习惯在家工作,也导致了IBM和红帽公司之间引发企业文化、风格的冲突。

“文化的磨合肯定会是一个挑战,”莱曼说。 但他与华尔街的许多人一致认为,从收购和企业角度来看的话,这笔交易则是为开源软件公司开辟了一个新纪元。

莱曼说:“由于这是对开放源软件的认可,任何以开源为基础的公司,或者主要基于开源建立的公司都将变得更加炙手可热,或者说,至少减轻了那些为开源而付费企业的威胁。”

投资者们暂时对IBM收购红帽公司后的影响还不得而知。但很明显,开源软件公司将在混合云端的开发中发挥重要作用,这可能是云计算技术大幅增长的下一阶段。

Windows Server 2008 显示隐藏文件 扩展名

1、开始==程序==设置==控制面板==文件夹选项 ;

 

2、双击打开,文件夹选项;

 

搞定!

 

Your Site is slow? - Read this for performance increase!!

Hi,
you think your server is performing poorly and you want to improve the output speed of Joomla. This article should give you some things to check and solve to sometimes drastically enhance your servers performance. Lets make a list:

General Optimizations:

  • Hosting package
  • HTML code
  • Images
  • PHP accelerators

Joomla specific Optimizations

  • Used extensions
  • Database
  • Debugging your site
  • SEF/SEO


General Optimizations:
Hosting package
A lot of people out there buy a shared hosting package and expect to be able to run a site with hundreds of hits per second on that one. We have to make it clear here, that Joomla is not static HTML. You may be able to service hundreds, if not thousands of users per second with static HTML pages, but Joomla needs quite some CPU power and if you plan a site with more than about 5 hits per second, you should directly look for a dedicated server, even more hits, and you should think about a load balancing system, several servers and a MySQL cluster. There is an interesting thread on this one here. For a normal set up, look around in this forum, there are several threads with the experience of the users. Especially the experiences with different providers are very interesting.

HTML code
When you create your page, you should pay attention to two things. First, use valid code. The more bugs your code consists of, the longer a browser needs to render it. Second, use less objects. A lot of people are using to many images, flash and javascript on their site. There have been great improvements in the connection speed of a lot of users and broadband connections exceeding 1 MBit are not as uncommon as just a few years ago, but the vast majority of all users are still dial-ups with a modem or ISDN connection. If you don't want to exclude 90% of the web community, you should keep your site small. There are several services out there that can analyze your site, I will only mention the Web Page Analyzer from Websiteoptimization. For the validation of your HTML code and Javascript, I can only recommend the Web Developer Extension for Firefox. You can get it here.
These things can improve your sites speed drastically and you should really look into this!

Images
As I wrote in the previous paragraph, small is beautifull. ;) This also applies to images. Take a look at your images and see if you really need them in a resolution of this size. Wouldn't a picture with half the dpi look as good? Often people don't notice that they are using images the size of lower Manhattan because they set the size in the HTML code to something way smaller and their browser has the images in his cache, but others first have to load a huge image and then it gets reduced to the size of a stamp. This takes a lot of time for them and they don't want to wait that long. So see to a reasonable size of your images both in pixel and in bytes.
Another thing that's often slowing down the performance are missing images. If you have a reference to a non-existent file, the server will need a lot of time to notice that and answer with a 404. In some cases your server is configured that way that you are redirected to the frontpage when the server can't find the file and in that case the browser receives a complete new page each time he requests a missing file. Imagine just one page with an image that is used at a dozen places in the layout and is not present. This can slow down the delivery to up to half a minute!

PHP accelerators
If you can't afford a new server and you are on your performance limit, think about buying a PHP accelerator. There are again numerous available, like Zend or APC. Just look in this forum for further information. They can do little wonders about your performance.

Joomla specific Optimizations
Used extensions
You have installed Joomla and you have found all those neat little extensions available on extensions.joomla.org. You have installed numerous of them and think your site looks really cool, but lately you have to wait several seconds till your site pops up.
Again, this is another example of small is beautifull. Joomla needs a lot of extra time for each module or plugin it has to load. I guess you can think where this is heading: Use less extensions and try to make the best out of the few you really need.
In this regard, you should take a look at your extensions and see if any of those uses an external datasource. If your server first has to load the data from another server, process it and then send it to you, this can take up several seconds. Try to find an extension that does the same but stores the data on your server. If the other server has a failure or is getting DoSed, your server will not be affected by this, too, since it is just reading from its local data source.

Database
Great potential lies within the database. In general we recommend you to allways use the latest version of Joomla, since for example there were big improvements from 1.0.7 to 1.0.8 and there are even bigger improvements coming in 1.5. (1.0.8 uses about half as much queries as 1.0.7 and 1.5 does the same trick with about a quarter of the amount of queries from 1.0.7)
If this is not enough for you, you can also enable query caching in MySQL. This will cache a lot of queries in the RAM of your server and make it fast as a bullet, but be carefull, you really need A LOT of RAM. 2 GByte is not uncommon and more like the lower starting point for this. This is nothing for shared hosting!

Debugging your site
I also recommend switching on error reporting in PHP and setting it to its highest setting. You will probably have to correct some errors in the code to get them all away, but they, too, are wasting precious CPU time and therefore performance.
If you switch on debugging in the Joomla backend, you get a list of all queries executed for this site in the frontend. If you see a number thats to high, you should hunt those down and see what can be done about reducing that number.

SEF/SEO
Last but not least we have SEF/SEO. This takes a lot of CPU power and if you have problems with your server, you should switch that off as the first emergency measure. Due to some errors in erlier Joomla versions, SEF sometimes produced dozens or even hundreds of useless queries.

With these things you should have your server going a lot faster than previously. If you still have problems, please post into this board and we will try to give you specific help on this one.

sql connection limit reached: 150-可以可尝试禁用SEF

i am running a small community site: http://www.schlachtumeuropa.de

when many ppl login to the same time the mysql connection limit, which is set to 150, is every time reached and the site goes "offline". are there any hints how i could set up the joomla 1.0.3 page so that this will not happen anymore ?

i have sitestats disabled, sitecache enabled

mysql> status
--------------
mysql  Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)
Server version:        4.1.11-Debian_4-log
Last edited by And_One on Fri Oct 14, 2005 6:52 pm, edited 1 time in total.
Top
 
User avatar
DeanMarshall
Joomla! Hero
Joomla! Hero
Posts: 2352
Joined: Fri Aug 19, 2005 2:26 am
Location: Lancaster, Lancashire, United Kingdom
Contact:

Re: sql connection limit reached: 150

Post by DeanMarshall » Fri Oct 14, 2005 7:05 pm

I am going to bet that you have SEF enabled.

If so you may want to check out this thread:
http://forum.joomla.org/index.php/topic,11139.0.html

Dean Marshall
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/

Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Fri Oct 14, 2005 7:45 pm

SEF ?

i have joomla 1.03 installed and the htaccess file from the post ^ is included in this release. that did not solve my problem.
Top
User avatar
DeanMarshall
Joomla! Hero
Joomla! Hero
Posts: 2352
Joined: Fri Aug 19, 2005 2:26 am
Location: Lancaster, Lancashire, United Kingdom
Contact:

Re: sql connection limit reached: 150

Post by DeanMarshall » Fri Oct 14, 2005 8:59 pm

Perhaps it is a search engine crawler then.
Is your robots.txt file up to scratch?
Do you have access to logfiles or a hosting control panel that will show you 'latest visitors'?
If so is there any discernable pattern in the usage.

If you do use the Search Engine Friendly (SEF) Urls option and the .htaccess file then I should also add that some servers don't use the specific environment variable used in the specimen .htaccess file, I am with 1and1.co.uk linux hosting and have to ammend the first line or it has no effect.
RewriteCond %{REQUEST_URI} !\.(jpg|jpeg|gif|png|css|js|pl|txt|ico)$

Try the Web page optimiser in the other thread and look for page elements very close in size to the page HTML.

Dean.
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/

Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Fri Oct 14, 2005 11:40 pm

i have root access

SEF is off, htaccess is correct
Top
User avatar
DeanMarshall
Joomla! Hero
Joomla! Hero
Posts: 2352
Joined: Fri Aug 19, 2005 2:26 am
Location: Lancaster, Lancashire, United Kingdom
Contact:

Re: sql connection limit reached: 150

Post by DeanMarshall » Sat Oct 15, 2005 12:08 am

So what about..
DeanMarshall wrote: Perhaps it is a search engine crawler then.
Is your robots.txt file up to scratch?
Do you have access to logfiles or a hosting control panel that will show you 'latest visitors'?
If so is there any discernable pattern in the usage.
Or perhaps you have got that many users? If you do have 150 concurrent users then you need to edit MySQL's ini file to increase the number of allowable connections. If your hosting package doesn't allow this then you may need to upgrade your hosting package or move to a larger host.

Dean
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/

Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Sat Oct 15, 2005 12:30 am

well, i don´t think that there are really 150 concurrent users ... but what i saw is that each connection (process) is open ~40000 ... i think that value is a bit to long. is this the session live time ?
Top
User avatar
DeanMarshall
Joomla! Hero
Joomla! Hero
Posts: 2352
Joined: Fri Aug 19, 2005 2:26 am
Location: Lancaster, Lancashire, United Kingdom
Contact:

Re: sql connection limit reached: 150

Post by DeanMarshall » Sat Oct 15, 2005 1:04 am

Okay, Me again,

Could this be anything to do with your frames based redirect?

Does the livesite variable in your site reflect the true url rather than the schlachtumeuropa.de address?
This may be an issue. I don't know if I just happened to try while you were making changes but I got a blank screen everytime.

Your host seems to be having DNS problems. I get long delays and a domain not found when trying the 'real' address - the one in the frameset src parameter.

Dean Marshall
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/

Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Sat Oct 15, 2005 1:10 am

i know that there are for the first time dns problems ... i will talk to my hoster if they persists.

i don´t think that the "frames" are causing much troubles with high amount of connections.

is there any way of building a connection pool with mysql and joomla ? or shared connections ? i think it is not really neccessary to have one connection per user or ?
Top
User avatar
DeanMarshall
Joomla! Hero
Joomla! Hero
Posts: 2352
Joined: Fri Aug 19, 2005 2:26 am
Location: Lancaster, Lancashire, United Kingdom
Contact:

Re: sql connection limit reached: 150

Post by DeanMarshall » Sat Oct 15, 2005 1:15 am

Beyond my level of 'inexpertise' I am afraid. You need a server guy.
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/

Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Sat Oct 15, 2005 1:17 am

a question: most users are using the log in with cookie feature, so every time when they come on the page a connection(process) is generated ?
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Thu Oct 27, 2005 10:06 am

i really need this solved because under heavy load / many requests my page is after a short time "offline" ... i would be really happy if anyone has some more suggestions for me


would be postgre or sqlrelay a solution ? anyone familiar with this ?
Top
User avatar
DeanMarshall
Joomla! Hero
Joomla! Hero
Posts: 2352
Joined: Fri Aug 19, 2005 2:26 am
Location: Lancaster, Lancashire, United Kingdom
Contact:

Re: sql connection limit reached: 150

Post by DeanMarshall » Thu Oct 27, 2005 10:29 am

Your site is *very* image heavy.

Could it be that impatience on the part of users leads them to 'reload' a partially loaded page forcing a scaling of server load.
You have nearly 200KB of images:

I used this service to analyse your site.
http://www.websiteoptimization.com/services/analyze/

Estimated Page load times:
14.4K  208.82 seconds
28.8K 104.61 seconds
33.6K 89.72 seconds
56K 53.99 seconds

1  50307  CSS IMG  http://v2.sue.vs7509.vserver4free.de/te ... header.jpg
1 32049 HTML http://v2.sue.vs7509.vserver4free.de/
1 Not found CSS IMG http://v2.sue.vs7509.vserver4free.de/te ... in/top.gif
1 Not found CSS IMG http://v2.sue.vs7509.vserver4free.de/te ... /right.gif
1 Not found CSS IMG http://v2.sue.vs7509.vserver4free.de/te ... n/left.gif
1 Not found CSS IMG http://v2.sue.vs7509.vserver4free.de/te ... bottom.gif
1 77744 IMG http://v2.sue.vs7509.vserver4free.de/im ... 0kopie.jpg
2 37153 SCRIPT http://v2.sue.vs7509.vserver4free.de/in ... ib_mini.js
1 29471 IMG http://v2.sue.vs7509.vserver4free.de/im ... rs/sue.jpg
1 16769 CSS http://v2.sue.vs7509.vserver4free.de/te ... te_css.css
2 13966 CSS http://v2.sue.vs7509.vserver4free.de/co ... ations.css

I still think it could be badly behaving robots or possible a badly coded module.

A CMS like Joomla makes multiple queries per page load. If each query was a concurrent connection then it wouldn't take too much to hit 150.
>> mysql connection limit, which is set to 150

Dean.
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/

Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Sat Oct 29, 2005 2:28 pm

thx for your tips. i had a closer look into css and the used modules. the page is now alot faster with a few users but still stuck with many users. my last idea is to use the unix odbc driver with connection pooling, any experience how to configure joomla to use this odbc thing ?

http://www.unixodbc.org/
Last edited by And_One on Sat Oct 29, 2005 3:52 pm, edited 1 time in total.
Top
User avatar
DeanMarshall
Joomla! Hero
Joomla! Hero
Posts: 2352
Joined: Fri Aug 19, 2005 2:26 am
Location: Lancaster, Lancashire, United Kingdom
Contact:

Re: sql connection limit reached: 150

Post by DeanMarshall » Sat Oct 29, 2005 4:28 pm

Hi,

1  77744  IMG  http://v2.sue.vs7509.vserver4free.de/im ... 0kopie.jpg
1 50307 CSS IMG http://v2.sue.vs7509.vserver4free.de/te ... header.jpg
1 31666 CSS http://v2.sue.vs7509.vserver4free.de/co ... ations.css
1 29471 IMG http://v2.sue.vs7509.vserver4free.de/im ... rs/sue.jpg
1 28904 HTML http://v2.sue.vs7509.vserver4free.de/
1 Not found CSS IMG http://localhost/ak/images/camping.jpg
2 Not found CSS IMG http://localhost/ak/images/bg-left.gif
2 37153 SCRIPT http://v2.sue.vs7509.vserver4free.de/in ... ib_mini.js

Page load times:
14.4K  220.87 seconds
28.8K 110.64 seconds
33.6K 94.89 seconds
56K 57.09 seconds

I don't really see much difference in your total page load - it is not the .css file itself, more the images it references, they are *very* large.
In particular the first two listed above could do with optimising. And the two that reference localhost??? what is that about?

On the issue of caching database queries - I have zero knowledge or experience of such things, but I don't think this is where your problems lie. You appear to be using a free hosting provider - perhaps this is an issue?  I don't know how many users your site has, or whether search engine bots or similar could be an issue.  Also have you tried turning on the caching option within Joomla?

I mean no disrespect but seriously I wouldn't like to be visiting your site on dial-up - 1 minute for the front page to load!

Here is my advice for what it is worth:
1. Optimise your images - get their file sizes down.

2. To optimise your .css files somewhat you could try this:

place the PHP snippet above into the top of your CSS document. Then, rename your CSS file with a 'php' extension, and then refer to that file in the section of your template when linking your css file, for example:



3. You might also turn on gzip compression in your site's global configuration screen if the option is available to you.
4. Turn on the caching options in Joomla.

Good luck.

Dean.
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/

Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Sat Oct 29, 2005 5:57 pm

i can do all the changes but this will not solve my main problem: sql connection limit reached 150 !!

it is my own linux root server (vserver) and i have full control over it. when alot of users connect to the site it will reach the connection limit in a short period of time. during the day the page loads "normal" but when we have an event the page reaches the connection limit to the mysql server. the only thing i can see with the myphpadmin is that every logged in user has its own process ... so the limit of 150 will be reached very soon if more users log into the page. my main question how can i build a connection pool with ~20-50 connections ?

odbc or sqlrelay would be an option or ?
Top
User avatar
DeanMarshall
Joomla! Hero
Joomla! Hero
Posts: 2352
Joined: Fri Aug 19, 2005 2:26 am
Location: Lancaster, Lancashire, United Kingdom
Contact:

Re: sql connection limit reached: 150

Post by DeanMarshall » Sat Oct 29, 2005 6:13 pm

In that case then you don't need any of this caching stuff - just remove the limits from the database user.

Find out which user your site is running as - you entered this when you set up Joomla.
Load up PHPMyAdmin and navigate to the users table

Server: localhost  Database: mysql  Table: user 

Click 'browser' in the top bar of the right hand frame.
Find your previously identified 'user' in the list - it should have max connections 150 in the rightermost column.
Put a tick / check mark in the left most column and click the edit icon.
Find the 'max_connection' row and put a zero in the value column - this will remove any limit.
Make sure the save radio button is selected and click go.
You may need to restart your MySQL server
For all I know you may need to restart Apache ??

That should - on a good day with a fair wind - solve your main issue.
Then you can look at the rest later.

Dean.
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/

Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Sat Oct 29, 2005 7:17 pm

thanx for that tip, but all my users have it set to 0.

my.cnf

set-variable=max_connections=200

^^this limit is the problem

but when i set it to e.g 2000 than the server is a bit overloaded and after 300 the loading times increase rapidly
Last edited by And_One on Sat Oct 29, 2005 8:07 pm, edited 1 time in total.
Top
User avatar
kenmcd
Joomla! Champion
Joomla! Champion
Posts: 5672
Joined: Thu Aug 18, 2005 2:09 am
Location: California
Contact:

Re: sql connection limit reached: 150

Post by kenmcd » Sat Oct 29, 2005 11:44 pm

I have tuned a number of MySQL servers for high volume ad servers.
(phpAdsNew and Max Media Manager)

There are a few settings which may eliminate the problem rather quickly.
The MySQL defaults are really bad for any volume.

Best way to see what is happening is to use the MySQL Administrator to watch the server for awhile, and then tweak the settings.

If you are interested - PM me a username and password.
If you are concerned about the security of web access, the best thing to do is to setup a new MySQL user and restrict access to only my IP address (which I will PM).

I can login and watch what is happening and then make the changes (they are only temporary until added to the config file), and then tell you what needs to be changed in the config file.

I have been wanting to tune a Joomla site.
██ LibreTraining
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Sat Oct 29, 2005 11:50 pm

i did some changes some hours ago after searching the web ....

i am not sure if this will help, i will know on wednesday afternoon when our next event is planned. you can contact me on icq: 72986499 if you wanna look at the mysql host if the problem still persists after wedneday, ok ? next scheduled event is after wednesday the next saturday, so we have 2 day per week to look on the page when the page is on heavy load. thx for your offer!


my.cnf looks now:


#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "/var/lib/mysql/my.cnf" to set server-specific options or
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/serve ... ables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client] port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe] socket = /var/run/mysqld/mysqld.sock
nice = 0
open-files-limit=8192


[mysqld] #
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
set-variable=max_connections=500

wait_timeout = 500
connect_timeout = 10

# For compatibility to other Debian packages that still use
# libmysqlclient10 and libmysqlclient12.
old_passwords = 1
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
#
# * Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size        = 16777216
query_cache_type        = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql.log
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
log-bin = /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size        = 104857600
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
#
# * BerkeleyDB
#
# According to an MySQL employee the use of BerkeleyDB is now discouraged
# and support for it will probably cease in the next versions.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump] quick
quote-names
max_allowed_packet = 16M

[mysql] #no-auto-rehash # faster start of mysql but no tab completition

[isamchk] key_buffer = 16M
Top
User avatar
kenmcd
Joomla! Champion
Joomla! Champion
Posts: 5672
Joined: Thu Aug 18, 2005 2:09 am
Location: California
Contact:

Re: sql connection limit reached: 150

Post by kenmcd » Sun Oct 30, 2005 12:46 am

Best time to watch the server is during the heavy load to see what is happening.

The MySQL config file is the bare minimum and has not been tuned.
██ LibreTraining
Top
 
And_One
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Tue Oct 04, 2005 7:56 pm

Re: sql connection limit reached: 150

Post by And_One » Sun Oct 30, 2005 12:55 am

maybe you can share a better my.cnf with us with the infos from my server?

well my root vserver is this: http://neu.star-hosting.de/c/cms/front_ ... 37&idcat=6

About Us

Since 1996, our company has been focusing on domain name registration, web hosting, server hosting, website construction, e-commerce and other Internet services, and constantly practicing the concept of "providing enterprise-level solutions and providing personalized service support". As a Dell Authorized Solution Provider, we also provide hardware product solutions associated with the company's services.
 

Contact Us

Address: No. 2, Jingwu Road, Zhengzhou City, Henan Province

Phone: 0086-371-63520088 

QQ:76257322

Website: 800188.com

E-mail: This email address is being protected from spambots. You need JavaScript enabled to view it.