Limiting The Number Of Spawned MySQL Child Processes
Need to know if there is any way to limit the number of spawned MySQL child processes in linux ?
I have done my research at http://www.mysql.com and have not been able to find my answer. Have also looked at the source code (what i can understand of it).
Using MySQL v.4.0.25-max. Using an older system and the 14 childern are just bogging the system down. I am the only one with access to the server so 14 childern is overkill.
View Complete Forum Thread with Replies
Related Forum Messages:
Max_execution_time Ignored, Multiple Apache Processes Spawned
I have an app that is going berzerk on its own; without any code or environmental changes of any kind, for some bizarre reason it will randomly just hang, spawn multiple Apache processes and completely ignore max_execution_time, literally running infinitely. Using PHP 5.2.0, Apache 1.3 and Win XP Is this normal "bizarre" behavior that can occur within this setup; if so, what workarounds have you found to combat this, other than the obvious (try to debug and fix code)?
View Replies !
Max Number Of Processes
how can i determine what the maximum number of processes i should open with popen (or proc_open) is? i assume it'd depend on the hardware of the computer in question, but if that were teh case, then is there a way to get info. about it, and some general method to determine a good number of processes to open from that info?
View Replies !
Limiting Number
i'm working on an event listing site. when someone lists an event, they can upload 3 images. Rather than uploading every single image to a single directory, i'd like to break the uploaded images out into a bunch of different directories. otherwise, any attempts to view the contents of the user image folder could result in a really LONG wait as we list a billion images. I'd like to limit the contents of any given directory to a thousand items. I'd also like to support a very large number of events and images (1 billion? 10 billion?). I realize that many images might overload a single drive on any server, but am still determined to do it. Seems to me that some sort of recursive function might be necessary? It's easy enough to turn an event id into a folder. it's also not so hard to make a new subdirectory so there are no more than 1,000 events in a irectory. what's more difficult is when we exceed 1 million images. then my top level directory would have more than a thousand images in it.
View Replies !
Limiting Number Of Entries
I am using a mysql database and using a simple form to input data into the table, but i want it to refuse the data if there is say 30 entries in the database already.
View Replies !
Limiting A Query By Number And Date
I run a hockey league and want to post my schedule for the upcoming season. The problem is that I have 100 games in the season and I want to limit the query to 30 games on the schedule that is posted on my website. That part was no problem for me but I also would like to have those 30 games be determined by date. So I would like the script to acquire the current date and post the next 30 games that are upcoming. I have a date field in the daatbase that is in the form YYYY-MM-DD.
View Replies !
Limiting Number Of Characters In A String...
If I have a long string of text in a variable, how can I "trim" the text down to a specific number of characters? So for example, if I have: $string = "This is a string"; and I just want the first four characters of the string, so just "This", how would I do that?
View Replies !
Limiting Number Of Database Queries...
I'm a web developer/webmaster and do some limited database/ASP (VBscript) stuff and some SEO. One of my clients has a new competitor. Their store locator stops you after 5 zip code queries ("..only 4 queries per week or 8 queries per month allowed.."). They are obviously using PHP. My client wants me to do the same for our MS-Access/ASP (Dreamweaver MX 2004) store locator database, which now has no limitations on number of ZIP, City name or Phone Area searches. Code:
View Replies !
Limiting Number Of Pages Displayed
I am querying my db, I have 300 items as my result, I am displaying 10 on a page, I only want 10 links to other pages displayed at one time instead of all 30, here is the code I am working with. Code:
View Replies !
PHP, MySQL & Limiting Access
I have a project for work, and I'm not sure how to efficiently do what I need to do. I'm hoping someone out there can help. Project is this: I'm creating a web-based interface where people at my company (operators) can enter data for service calls. All data entered is run thru one or more PHP scripts for error checking and then stored in a MySQL database on a server here in the office. What I'm looking to do is to limit access to certain operators so they can only do certain functions (ex: add a service call, but not delete one), whereas admins such as myself would have full access to everything. Ideally, at some point in the future, we plan to roll this interface out to our clients so they may do the same features within their company. Obviously, they would only gain access to data related to their company, as to protect the privacy of others. Hierarchy would be something like this: 1. UberAdmins (such as myself) -Have access to everything and to all commands. 2. Operators -Have access to everything, but not all commands. 3. Our clients -Have access to their data only, and to all commands. 4. Our clients' operators -Have access to their data only, but not all commands. The difficult thing is that our clients may run several businesses, so they would have to have access to several groups. In essence, they'd have multiple groups (their businesses) within a group (their group) within a group (everything). What is the easiest and most secure way to do something like this? I'm not looking for actual code but merely suggestions. Please reply if there is something I wasn't clear on.
View Replies !
Limiting User Mysql Entries
I have a script i'm making which is going to be used to search for reciprocal links on different sites and I have user levels such as free, paid, ect... I want to make it so that if the person signs up as a free user they can only add like 2-3 domains to be searched for their links. How would I limit the number of domains allowed to be searched? Would I limit the number of mysql entries allowed in the table for the domains?
View Replies !
MySQL Limiting/Results On Page
I would basicly like to know how to limit mysql results to 20 results , then have a ?page=2 system wich will show another 20 , then ?page=3 will show another 20 and so on... how would I go about doing that? This is the code I am using now to limit the results to 20 (but there is only 1 page of 20 results): Code:
View Replies !
Limiting Duplicate MySQL Results
I'm having a bit of trouble trying to get the DISTINCT statement to work with mySQL. What I'm trying to do is return a list of 'books by the same author' on a php page that displays a single book. Current statement looks something like this: SELECT book_id, title FROM titles WHERE author LIKE '%$author%' AND title != '$this_title' My problem is, there are duplicates in the database. So, for instance, I might have 'Farewell to Arms' by Ernest Hemingway in the DB three times, one for paperback, one for hardcover, and one for large print. When I'm looking at 'The Old Man and the Sea', I want it to show only one copy of 'Farewell to Arms,' under 'Other books by Ernest Hemingway' not all three. I don't care which version is shown. I thought I could use DISTINCT to do this, but I can't get it to work how I would like it to.
View Replies !
Select Character Limiting (MySQL)
Say you have a field in a database named MyString. It has a value of 25082006121228. How do you write a select statement that queries that field on only the first 8 characters. SELECT * FROM `MyTable` WHERE MyString = 25082006
View Replies !
Limiting The Amount Of Text From A MySQL Call
I have the following code that pulls some information from a database and presents it (obviously), it also has a link to find out more about the presented information. One of the feilds is called a biography, I want to limit the amount of the field "biography" that is displayed, like the first 200 characters (maybe even ending in a ...) and have the rest of the biography dislay when the person clicks on the corresponding link. Is this possible? Code:
View Replies !
Limiting The Amount Of Text Displayed From A Mysql Query
I have a query that will output over 100 words on average I would like to limit the text displayed to 30 words is this possible with either php or mysql? <? $qr1 = mysql_query("SELECT * FROM MYTABLE WHERE id=$id AND status=1 ORDER BY sum DESC LIMIT 50"); while( $row = mysql_fetch_object($qr1) ){ ?>
View Replies !
PHP Processes
I have a cronjob triggering a php script that takes several minutes to accomplish. I need to prevent multiple triggering by the cronjob mulfunctioning. So I would like a clean way to know how many instances of a certain php are currently working on the server. is there a server variable for that? if not, how do I know (via php) how many concurrent accesses are there to a certain php page? for example in mysql (the "SHOW PROCESSLIST" command), but I need a similar function for the php page iself.
View Replies !
Background Processes
I'd like to know how to send an external process to the background, so that I can run multiple instances of the same process at one time. Any tips, links.. etc?
View Replies !
Listing Processes In PHP
Using PHP, is it possible to return and display a list of currently running processes on the client's machine? In fact, is it possible to run a system command on a client's machine?
View Replies !
Automated Processes
Customers post 'projects' to my site. These 'projects' are closed after 10 days. I could run a script on the default.php page that detects this, but it seems a waste of resources to run it everytime someone visits the site. Is there a way around this, for example the first visitor to the site in any, say, 3 hour period, runs the script & switches the most recently outdated projects from open to closed?
View Replies !
Stranded PHP Processes And ProcessExplorer
Does anyone know what it means if I see PHP processes in the process tree at the base level, instead of under the IIS worker process? I do nothing but web serving off of the box. These processes that are not under the IIS worker process seem to be stranded/hung. They are never cleaned up by any garbage collection and I have to kill them manually. They also always have a fairly low memory usage, potentially indicating that they fail before loading completely. Could it be that the execution of the process fails early enough that ProcessExplorer doesn't see them as being executed by IIS?
View Replies !
Handling Long Processes
I am building web app, that will run a long processs (image processing) that can porbably take 15-30 minutes to complete) in respond to a user request (the user clicks a "process" button on a php web form). The ideal situation that I see is once the user's request was recevied, a reply that says "you request is being processed. we will send you email once finished", will be sent to the user, while the other process will take place. When it's finished, a callback function will be called that sends email to the user notifying him the process outcome. What are the options to implement that? multithreading?
View Replies !
Shared Memory Between 2 Processes?
I have two running php processes (they have infinite loops) and I need them to pass some data to eachother. Writing and reading shared memory in one process works just fine but when I try to save var in process1 and read in process2 I get error: "Variable key 555 doesn't exist". What I'm doing wrong? //PROCESS 1 (saving var) $key = 'My Key' $value = 'My Value' $app = 'lovelyapp' $key = $key . 'a' $segment_key = abs(crc32($app . $key)); $segment_size = 1024; $segment_perms = 0600; $shm_id = shm_attach($segment_key, $segment_size, $segment_perms); shm_put_var($shm_id, 555, $value); shm_detach($shm_id); // PROCESS 2 (reading var) $key = 'My Key' $app = 'lovelyapp' $key = $key . 'a' $segment_key = abs(crc32($app . $key)); $segment_size = 1024; $segment_perms = 0600; $shm_id = shm_attach($segment_key, $segment_size, $segment_perms); $value = shm_get_var($shm_id, 555); shm_detach($shm_id);
View Replies !
Insert Processes Before Form Is Submitted
I am trying to stop using Macromedia as my crutch and you guys have been a big help. I need some assistance with submitting a form. I have a form on my page and need to do an insert. I have the action posting it back to the same page I am on versus sending it to an insert page. The problem I am having is it trys to do the insert as soon as I pull up the page instead of waiting till the form is submitted. I believe I need to do something with isset, but can't really find a tutorial that goes over it really well. Code:
View Replies !
Forking Multiple Processes At A Time
i have a php script that needs to execute an external php script (call this script 2) when the user clicks a link, however I don't want the user to have to wait until script 2 finishes executing before he sees the output of script one... i know I can use the exec() command to do this, and use the & to run the command in the background.... but say i want to run 100 instances of script 2 when the user clicks the link (with different arguments)... i dont want to have all 100 processes running at the same time... what I would like to do is run 10 or so at once, and once those 10 are completed, run another 10...
View Replies !
Large Data Transfer Between 2 Processes
fist the context: I have a web server which query a mySql database. but as the number of parralel queries increase, the server slows down too much. I got 2 ideas, one of which is to run N deamons which effectively execute requests. the PHP uses message queuing(1) to queue queries request to the daemons. but the answer may be quite large, larger than messages the message queueing service can handle. I thought to open back a communication link between the current daemon and the waiting PHP to tranfer/process the result, using the message queueing service to send back info regarding the opened link. I thought to open a pipe between the current daemon and the PHP. is this possible? and if so, how? if not, is an IP link to localhost be as fast as a pipe?
View Replies !
Keeping Users Informed In Lengthy PHP Processes
Often PHP processes take a long time, such as wildcard searching a PostgreSQL database, or generating thumbnails. The PHP host page does not display until the script is complete, so you can not effectively use code such as echo "Converting file ".$Infile; exec(convert $Infile $O8utfile); for realtime feedback to the user. How have others implemented a "progress meter" in PHP processes , one thought I had was to use Javascript redirection to call a PHP page with differing parameters each time .
View Replies !
Sending Signals To Processes As A Different User Than Owner Using Php
i know, it seems more to be a problem according to unix but i got it while developing software with php: i have 2 different users on a hp-ux machine that execute php scripts. they are both in the same group. these php scripts start background processes, i can communicate with using signals (sending with posix_kill, starting background processes via pcntl_fork). so i got severel background processes owned by my 2 users. the problem is i want to send signals as one of my 2 users to all my php background processes no matter who of my 2 users is the owner. is it possible other than using external tools like sudo? i'm using: PHP 4.3.4 (cgi) (built: Aug 18 2004 15:37:46) Copyright (c) 1997-2003 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies compiled with: ../configure' '--prefix=/usr/local/php-cgi-saprfc' '--enable-calendar' '--enable-filepro' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-zlib-dir=/usr/local' '--without-mysql' '--enable-sysvsem' '--enable-sysvshm' '--with-pgsql=/usr/local/pgsql' '--enable-trans-sid' '--with-cpdflib=/usr/local' '--enable-sockets' '--with-ncurses=/usr/local' '--disable-shared' '--with-tsrm-pthreads' '--with-saprfc=/usr/local/rfcsdk' '--enable-pcntl
View Replies !
Checkboxes - Loop That Takes The Values And Processes And Writes The Changes To The Database.
I generate a form page from my MySQL database. let's say the table structure is: Table A > ID, title, active the number of rows generated by the query is dynamic. If a field's value is 1, then the form output appears as <input type=checkbox name=$ID checked> $title and if not <input type=checkbox name=$ID> $title At the bottom of the form there is a submit button. The visitor can check/uncheck rows and then submit the form. I need to write a loop (possibly foreach) that takes the values and processes them and writes the changes to the database.
View Replies !
DOM Child Finding
Is there any faster/easier way of finding a child node of a certain DOMNode object than doing something like function getChildByTagname($curnode, $name) { foreach($curnode->childNodes as $node) { if($node->nodeName==$name) { return $node; } } } ? it seems fairly slow and cumbersome. i was thinking xpath, but i can hardly imagine that to be a lot faster, with all the DOMXpath object creation and all, though I didn't benchmark.
View Replies !
Check For XML Child
I need some help for checking for the following: <?xml version="1.0" encoding="ISO-8859-1"?> <error> <err type="2">Invalid location provided.</err> </error> Heres my PHP code: $hold = array(); $v_URL = "http://xoap.weather.com/weather/local/{$loc}?cc=*&prod=xoap&par={$par}&key={$key}"; $o_XML = new SimpleXMLElement(file_get_contents($v_URL)); $err = $o_XML->error; if($err){ $fcity[0] = 'Check Your ZipCode' $deg[0] = 'n/a' $icon[0] = 'error' } else{ $hrm ="<FONT FACE="Symbol">°</FONT>F"; $city = $o_XML->loc->dnam; $fcity = explode(',',$city); $deg = $o_XML->cc->tmp; // Temperture $icon = $o_XML->cc->icon; // Weather Icon $lat = $o_XML->loc->lat; // Latitude of City $lon = $o_XML->loc->lon; // Lonatitude of City $vis = $o_XML->cc->vis; // The Visibilty } $hold[0] = $fcity; $hold[1] = $deg; $hold[2] = $icon; // Output the Weather Array of $hold return $hold; Any ideas for checking for that? also heres a working zipcode xml output <?xml version="1.0" encoding="ISO-8859-1"?> <!--This document is intended only for use by authorized licensees of The Weather Channel. Unauthorized use is prohibited. Copyright 1995-2005, The Weather Channel Interactive, Inc. All Rights Reserved.--> <weather ver="2.0"> <head> <locale>en_US</locale> <form>MEDIUM</form> <ut>F</ut> <ud>mi</ud> <us>mph</us> <up>in</up> <ur>in</ur> </head> <loc id="04537"> <dnam>Boothbay, ME (04537)</dnam> <tm>10:10 AM</tm> <lat>43.88</lat> <lon>-69.63</lon> <sunr>6:07 AM</sunr> <suns>7:06 PM</suns> <zone>-4</zone> </loc> <cc> <lsup>9/6/07 9:45 AM EDT</lsup> <obst>Boothbay Harbor, ME</obst> <tmp>62</tmp> <flik>62</flik> <t>Mostly Cloudy</t> <icon>28</icon> <bar> <r>30.34</r> <d>steady</d> </bar> <wind> <s>9</s> <gust>N/A</gust> <d>160</d> <t>SSE</t> </wind> <hmid>95</hmid> <vis>10.0</vis> <uv> <i>2</i> <t>Low</t> </uv> <dewp>61</dewp> <moon> <icon>24</icon> <t>Waning Crescent</t> </moon> </cc> </weather> I was trying to figure out how to check for <error></error>. but can't quite figure it out.
View Replies !
Parent To Child, Child To Parent
I have a parent script that has a link that will open a drop-down menu on a pop-up window, the reason I choose not to include the drop-down on the same page (parent) is because the drop menu will list over 8500 queries, which slows the script drastically. So this is what I did. Code:
View Replies !
Children Of Child Node??
Is there any function or way to access the children of a child node using DOM??? I mean if i have the xml structure as: <app> <app_data> <data name='method'><value>sum_dif</value></data> <data name='val1'><value>123</value></data> <data name='val2'><value>456</value></data> <app_data> // child of child node <data name='coool'><value>divo9</value></data> <data name='sands'><value>007</value></data> <data name='make'><value>bond</value></data> </app_data> </app_data> </app> How can I access the data in the child node <app_data>?
View Replies !
Child Construct Parent
I'm building out a OO based app in PHP 5 but I'm getting a little confused on children contructing parents. I have a parent that looks like this: abstract Class State { protected $database; protected $user; protected $output; public function __construct($database,$user,$output) { $this->database = $database; $this->user = $user; $this->output = $output; } } And a child that looks like this: Class Status extends State { public function __construct($database,$user,$output) { parent::__construct($database,$user,$output); } } This seems to work OK. But I'm getting confused when thinking about adding a new child who then has to contruct the parent again. Isn't this getting away from the whole purpose of inheritence? It seems like this is recreating the parent with every new child that come along. Would it be possible to just have a single instance of the parent that all children extended or am I missing the point here?
View Replies !
How To Append A Child Dynamically
i m new in both things php and in this group. but i have some basic knowledge of php and DOM in php. here is my problem, i have one textfield for add a new main node (not main like: <root><this_one></this_one></root>) in my php page and i m able to save the xml file correct with this, and in the bottom of that i have one new textfield for add new child in dynamically create node (which i descibe above),and one combo box for show the all dynamically create nodes.now i want that when user give the value in child textfield and then select a root node for that child from combo box.i want to append a child dynamically to root node. but i m not able to do this. plz try to solve my prob...
View Replies !
Child Object On Demand?
I have an application that suffers from my amateur coding inefficiencies, and I am trying to clean a few things up. I have an extremely database intensive object, which I have tried breaking into smaller child objects to reduce database queries when they aren't needed. I currently have something that looks a bit like this: class Object { function Object() { $this->attribute1 = dbQuery("foo"); $this->attribute2 = "bar"; $this->child = new SomeOtherObject($attribute1); } } $foo = new Object(); if ($foo->attribute1 == "X") echo $foo->child->attributeA; Because every page load does not require $foo->child to be populated, is there a way to only establish the child object if it is referenced? Where is a good place to read about dealing with child objects?
View Replies !
Turning Parent Into Child
say I have the following code: PHP Code: class Parent { Â Â Â Â Â private $name; Â Â Â Â Â private $email; Â Â Â Â Â public function Parent() Â Â Â Â Â { Â Â Â Â Â Â Â Â Â Â $this->name = "Bob"; Â Â Â Â Â Â Â Â Â Â $this->email = "Bob@internet.com"; Â Â Â Â Â } } class Child extends Parent... Now, if I have a Parent object already created, what is the best way to turn that object into a Child object, so that it would have the same name and email, but have the Child functions?
View Replies !
Parent Child Presentation
I have been following the php, apache, mysql web development closely and am building a skeleton page (ch 4-7 ?) and doing a complete javascript validation before moving to the first switch/$_POST['step'] that branches to one of three states. the first state is selecting a resource (child) to add to the order(parent). when the drop down list box is populated and the submit button is pressed i want to end up at the same screen with a child record being present. being an absolute newbie to web programming i am unsure how to develop code where I can incrementally add child details and remain at (what appears to be) the same parent screen. I hope I have been clear in expressing my developmental needs.
View Replies !
Accessing Child Objects
I have an XML document which I am reading in via simplexml_load_file Here is a sample of the output: SimpleXMLElement Object ( [id] => 7870 [title] => Apocalypse Now [format] => SimpleXMLElement Object ( [displayname] => DVD [sortname] => DVD ) ) I can reference the title using $objectVariable->title. But, I cannot reference the format displayname in this manner: $objectVariable->format->displayname The only way I have been able to access that value is using a two-step process such as: $tmpVar = $objectVariable->format; echo $tmpVar->displayname;
View Replies !
DOM XML - How To Append A Link Element As A Child
I'm trying to generate a RSS newsfeed using the DOM XML functions, but you already know that if you read my previous post . I'm able to create rss, channel and title elements but not a link element. The following code sample doesn't generated <link>http://www.websitetitle.com</link> but <link> like if the DOM XML forgot to close the element : <?php $link_el = $dom_doc->create_element ('link'); $link_el = $channel_el->append_child ($link_el); $link_el->set_content ('http://www.websitetitle.com'); ?> Then I got some crazy idea. I thought that maybe DOM XML was thinking the link element I created was a specially element, not an enclosed one, like in XHTML for example : <link rel="stylesheet" type="text/css" href="styles.css" /> Crazy crazy because I don't see why DOM XML would handle my elements as HTML elements... But then I tried with a meta tag, and guess what... It also doesn't work ! It works with enclosed elements, tags, like title, head, html, body or unknown ones like channel or item. But it doesn't work with link, meta and input elements ! And I have no clue why it handles these elements as special elements... Here is the full script :
View Replies !
Display Child Records Only When Checkbox Is On
I have a list of nested arrays, that displays the parent, and then has the child records indented underneath. I want to be able to make a collapsible list, which I know how to do with regular data, but I'm having troubles getting the child records to display. I can get regular text to show up when I click but not the child records. What I am currently doing is calling a javascript onClick that changes the span textContent property. What would be the best way to handle the child records? Putting them in a function and calling it from the javascript by way of AJAX or something? Code:
View Replies !
|
TRACKER
