HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Normal amount of concurrent MySQL connections?

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#80813 (In Topic #16378)
Avatar

Fan in training

Hi everyone, I had a question for you all.

I installed ocPortal because I thought it was pretty light weight, and I'm using shared hosting. One of the MySQL limitations is that there is a 50 concurrent connection limit and I'm reaching that with only me logged in and having a number of guests. I'm guessing there must be something I set up wrong, because on inactive logged in member/admin and a couple of guests should not result in 50+ connections. The lowest its ever dropped is 30. I'm using MySQL workbench to query the server, that accounts for one connection.

I'm also seeing constant traffic in the server status screen, always over 1mb/s peaking at 5mb/s every x minutes.

I'm not using anything which polls outside data ( like an rss reader ).

Should I look for another cms or can I fix this?

Secondly, but maybe beter reserved for a possible next topic, I need to incorperate some aspx pages as modules and have no idea where to start. I would have chosen an .net based cms if I could install one on my hosting plan but failed to do so with every one I tried even Joomla would not install and only gave an option to configure an MSSQL connnection ( which my hosting doesn't include ).

Thanks in advance for any advice/help you're able to provide.

ps, if you're a trusted member here I have no problems making you a temp admin so you can look at how I configured the portal to now ( I actually think I might have done some things wrong even if I got the things working I needed, but I don't expect those to cause the things I'm seeing ).
Back to the top
 
Posted
Rating:
#80814
Avatar

You mentioned shared hosting, but querying the server directly. That makes me wonder if you're looking at other people's accounts too.

If you're truly on shared hosting, unless there's something weird I don't know about that somehow runs multiple MySQL instances per server, you wouldn't be looking at any figure specific to your own account. If you're actually on VPS hosting, that would be a different story though.

Same goes with traffic.

I'm not very familiar with the current state of IIS monitoring tools and it's process model though. I know it can be a bit sophisticated, but usually that is just for the .net stuff, not for things like MySQL.

First obvious thing would be to check your logs to see what actual traffic there is to specific URLs, rather than an aggregate. If you don't see much, chances are your aggregate tool is not reporting what you think. If there is much, it'll probably give a hint to the problem.

Regarding .net… Joomla is not a .net based CMS either. I could try and answer your question, but honestly you're on complex ground and you need to hire a very good professional developer for at least a few days for that kind of work (assuming you're not a developer yourself).


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#80816
Avatar

Fan in training

Not Joomla, mojoPortal, sorry I mixed them up.

Good question, I tried to get some more info from the master logs but I don't have permissions to access those. And yes I'm on shared hosting, not vps, so it's easier to believe I'm indeed looking at an aggegrate number.

I'm not a professional developer but I plan on writing the aspx pages myself ( as I can write my own web service's and database bindings and functions as well as the interface related things, but only in .net ). I know didly about php, I even treid to use the dreaded iframe to show an aspx page hosted on the same server but running seperated from the portal… it would work but it would be really limited in interaction since I can't pass along data from the portal to the aspx page and back again ( or at least I don't know how ).

Hosting helpdesk has just send me a how-to for setting up mojoPortal. I spend more then a day on getting this portal up with the modules I wanted, but in the long run I think it would cost me more time to adapt it to work with the custom aspx pages. I wouldn't have considered switching if you had a ready made module for importing aspx pages inside ocPortal, and being able to give a list of variables/state objects to pass along. If it's possible to do this without to much php work I will stick with ocPortal, but if not I have no choice but to switch.

Edit: my hosting company on it's site says it's fully supports webmatrix, but that's only with mssql instances. If they hadn't claimed that I would have done a manual install with mojo the first time.
Back to the top
 
Posted
Rating:
#80824
Avatar

This is how you integrate PHP and .net:
PHP: COM - Manual

Your hosting would need to have this extension, and you'd need to create an ocPortal minimodule page which itself would use this functionality to call your .net page.

Alternatively you would have to use iframes as you suggest, and probably access ocPortal's database directly from within .net code.

Lastly you could use OcCLE as a web service, as it is possible to call the OcCLE script using HTTP authentication and use it for API requests.

All of these would be really hard though. Learning PHP would probably be easier.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#80825
Avatar

Fan in training

My hosting won't allow that extension in a shared environment. ( edit: nope they keep saying things which are not true.. I use the example code you linked to ).

I am so used to .net it would be quicker to stick with a native .net cms, even if just accessing the same db as ocportal is a breeze. Does that allow tracking the current user? That's the most important issue I have/had ( I'm halfway through installing/configuring mojo but I made a full backup of the ocPortal install so I can restore it when I want ).

I don't think the problem would be with calling the right .net functions but rather in needing to learn to 'read' php so I can pass along the right information from ocPortal to .net.

If there is any documentation on how some common things like user session ect can be tracked it would make things much easier, though I'm not convinced that it will save me time to stick with ocPortal. I do know I liked most parts of the cms though so thumbs up from me.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: