Performance Of Win2K Server After Starting The Apache 1.3 Services
After starting the Apache 1.3 serivce the Win2k server performance is slow , as equal to hang position.
we are having 4 GB RAM .
what could be the possbile reason for this cause.
View Complete Forum Thread with Replies
Related Forum Messages:
Ugrading Win2k Server To Win2k3 Server
I would like to know if there is anything I should watch out for or do before I upgrade my Win2k server to Win2k3 server. I am running MYSQL version 5.0.27 and PHP 4. Which I must admit was a bit of a challenge finding the right combinations of the 2 that work together very well for my setup.
View Replies !
Trouble Starting Server
I have no experience with mySQL whatsoever and I just installed it on my linux box using the documentation on the mySQL site. When I used the command: bin/mysqld_safe --user=mysql & to start the server it gives me the following message before stopping the server: [2] 4105 [1] Done bin/mysqld_safe --user=mysql [root@weston mysql]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070205 18:38:15 mysqld ended
View Replies !
Mysql Server Is Not Starting
I have finished installing a copy of mysql from source on mandrake 10 (from source, not an rpm source) and everything went smoothly except starting mysql. I run "root@myBox> mysqld_safe --user=mysql &" and I get this message: Starting mysqld daemon with databases from /usr/local/mysql/var STOPPING server from pid file /usr/local/mysql/var/*my-ip-address*.pid 041219 12:06:03 mysqld ended so the server isn't starting, which is a problem. What have I done wrong?. These are the instructions I followed (with a slightly different ./configure line), which are from the mysql reference manual: 2.3.1 Source Installation Overview The basic commands you must execute to install a MySQL source distribution are:
View Replies !
Mysql Not Starting After VPS Server Reboot
I have a mysql db (Version: '4.0.22' FreeBSD port: mysql-server-4.0.22) running on an Verio VPS, and I am having an issue: After a power failure on Verio that meant restarted servers, etc, I saw that Mysql was not coming up. I checked the logs / etc and I got this message on /var/db/mysql/<hostname>.err: 060925 00:15:53 mysqld started 060925 0:15:53 bdb: Recovery function for LSN 1 29049 failed 060925 0:15:53 bdb: warning: ./testperl/testab.db: No such file or directory mysqld in free(): warning: chunk is already free 060925 0:15:53 Can't init databases 060925 0:15:53 Aborting There is no ./testperl/testab.db anywhere I can see, but OTOH, there should only be a few dbs and none of them is called testperl... Honestly, I have no idea of what might be hapening, but having the db is quite a PITA.
View Replies !
Starting MySQL 5.0.1 Server Up Problem...
I shutdown my MySQL server using MySQL Administrator 1.0. My problem is that i dont know how to start up the MySQL Server again. I tried to run mysqld-nt.exe by double clicking it but my server will not be up. If i restart my computer then thats the time my MySQL server will be up. Unlike MySQL 4.0.22 if i double click on winmysqladmin.exe my server will be up. Is there a way to put the server up without restarting my computer?
View Replies !
Starting MySQL Database Server Mysqld [FAIL]
Right now, I am using Ubuntu 8.04 and using mysql 5.0.51a. I am receiving the following error: * Starting MySQL database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.0; however: Package mysql-server-5.0 is not configured yet. dpkg: error processing mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-server-5.0 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1)
View Replies !
Mysql 5.1 Windows Realease Server Starting Problem
I am a new user to MySQL, and I have run into difficulties starting it. I have successfully done this once a while back, and than had to go away for a while. I am now trying to start the server again via the windows command line. I type: "C:Program FilesMySQLMySQL Server 5.1inmysqld" as directed from section 2.3.10 of the user guide and nothing happens. It just returns C prompt. I then use "C:Program FilesMySQLMySQL Server 5.1inmysqld" --console; this gives screen output as I do not get a data directory with an error file without '--console' The output is: 090419 17:30:38 InnoDB: Operating system error number 5 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. It may also be you have reated a subdiretory InnoDB: of the same name as a data file. InnoDB: File name .ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. And then goes back to C prompt on the command line. Can anyone help me? If memory serves, I followed the user guide to the letter when I started (save for the post-startup material). As well (and possibly related), I have the mysql command line client in windows on the desktop (c:program filesmysqlmysql server 5.1inmysql.exe). I click this and it prompts me for 'enter password'. I don't ever remember entering a password the last time which may be related to the first problem staring mysql server from the command line.
View Replies !
Starting MySQL Server With Federated Engine Support
I have MySQL service installed on my machine. I want to start the MySQL server with FEDERATED engine support. According to MySQL Federated Engine, I should start the server with --federated option. Where do I need to change this? I tried adding federated to the my.cnf file. Then Federated engine started working and InnoDB stopped working. After adding this line, I executed MySQL Code: SHOW ENGINES; There, I couldn't find InnoDB in list.
View Replies !
Server Performance Slow
I have designed a service on my site which requires about 30 -40 SQL queries per page to run. Everything works without problems apart from the slowness. The page will load very quickly until it gets to the first query, then it pauses..... and carries on slowly producing the results. (When I say slowly, I mean relative slow compared to the speed this forum loads for instance)All the other web apps with mySQL work without slowing down, but they don't take up as much resources. Even the VB board is very fast. I'm running a 2.8Ghz 1GB Win2003 server, so I doubt that is a problem. Is there a guide to optimizing mySQL server or a key "setting" I should be changing?
View Replies !
Server Reboot Causes Performance Improvement
I run MySQL 4.0.21 on Linux. I insert about 30,000 rows into a MyISAM table every hour. Once a day all rows with a timestamp older than 2 months will be deleted. The table currently contains about 35 million rows. I experienced that the script that inserts new data hourly takes longer and longer. When I rebooted the complete machine the last time the script took about 1 minute to finish. Now a few weeks later it takes about 8 minutes. I tested this many times. Every time I reboot the whole machine, the script takes about 1 minute. The longer the machine runs the longer the script takes to finish. Restarting of the MySQL server doesn't have any effect. I also tried "myisamcheck -r" but it also has no effect to the time the script takes. It seems that all sort of queries get slower, not only inserts. Selects also slow down. The machine has enough memory, mysqld only takes about 25% of the memory. And there are no other processes that need much memory.
View Replies !
Mysql 4 For Win2k
i've just installed mysql but when i type mysqld --console it shows that: Can't start server: Bind on TCP/IP port: No error Do you already have another mysqld server running on port: 3306 Aborting mysqld: Shutdown Complete for my.ini setting in winnt folder i only have these two: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data directory datadir=C:/mysql/data [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe is it i missed something ?
View Replies !
MySQL Fails To Start After Reboot In Win2K
I get this error (code 87). I install MySQL 5.0, everything is fine. I can work with it all day, no problem, all month, no problem. I reboot ONCE, it fails to start automatically. I manually start it... FAIL AGAIN. I reinstall, all ok. I catch too much info on google and I've read like 20 pages without any solution... just the same problem.....
View Replies !
Data Transfer Services
Does anyone did DTS using MYSQL before? thinking to migrate from MSSQL to MYSQL.. If MYSQL can do DTS, then I don't need to do scripting to transfer data.
View Replies !
Large Table Performance Problem With MYSQL Performance
I am doing some benchmarking of an application using MYSQL under Windows and I confused about the results. Environment Emachine 6417 with amd3200+ 64 bit processor 3.3GB ram mysql 4.1 with odbc 3.51 MYISAM windows 2003 server std edition date, account and invoice number are indexed Database size 18 million rows I am querying (selecting) columns of a date and an account our tester program that opens a socket to the Mysql database and does a select for the above n times each time the date and the account is randomized to minimize hits on records closeby. This program will perform over 1000 queries per second. At the end, the Mysql socket will be closed Even when the socket is closed each time, I still get 400 queries per second. When I enter a similar query manually a web interface, I get about 3-9 second response time. This program opens/closes a socket for each query when using EMS I get similar 9 second results. Does anyone have any suggestions Also in production, this table will be accesse for both read and write will I have problems. My testing showed that Innodb is much slower.
View Replies !
Mysql Services Windows 2003
------=_NextPart_000_0001_01C34BC2.26B3C4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Why can't I start the service in windows 2003 server have any one a solution?
View Replies !
Windows SQL Services And Removing MySQL
I had installed mySQL when a programmer wanted to use it for a project. Then i uninstalled it. Now the MS SQL services (SQLserver, sql server activation directory helper, sql server browser, and sql server vss writer), cannot be started. The error messages seem to indicate that there are some files missing in order to run the services. I tried to re-install MySQL, but not it is giving me error zero when i run the configurator.
View Replies !
Remote Conn Via ODBC Or Web Services?
I need your help, I've developed an application succesfully using PHP and MySQL But in order to mantain the MySQL database I need to make constant connections from either Progress or Delphi It's been working just fine using the MySQL ODBC 3.51 connector, but only in the SAME machine (localhost) any other machine atmysqlting to connect remotely gets an error This implementation works if my customer has a dedicated server posted on the web, but other customers need to hire external hostings In that case, how can I connect progress or delphi to a REMOTE MySQL DB on a external SERVER?
View Replies !
Mysql Stock In Services Forgot To Remove
i have uninstalled mysql to put it on a different drive soon The old mysql stayd in Services and I dunno how to remove it from administrative services? Mysql is not installed atm i will install it soon in other words how do I remove from administartive services once i uninstall the whole thing.
View Replies !
Apache
I've installed PHP, MySQL, and Apache, and they were all successful. I can access my databases via the command prompt, and the server is reading PHP. However, when I try to execute queries through PHP on the server, it simply won't let me. There's one weird bug, too; after the line that I use mysql_connect() on, it won't let me perform the basic echo() function. I haven't tried to do anything else.
View Replies !
[MP2] Placing Apache
Will placing Apache::RequestRec & Apache::RequestIO & APR::Table in startup.pl to load them up for multiple handlers have any bad side effects? I noticed that when I load them via startup.pl the handlers that use them don't complain that they don't have the use statements within the module code and still work as normal.
View Replies !
Apache Configuration
I was just wondering if anyone could help me to configure my home machine to run as a test server for PHP using MySQL and Apache. I am running WinXP pro and I would really appreciate some help. (I'm trying to learn PHP before paying the moola for a host, only to make a fool of myself while trying to learn PHP. I don't see any logic in paying for time to learn, when I could do it for free at home and then pay for a host...) I would be very thankful if you would imagine that I had just downloaded the files from their appropriate sites, and haven't even opened them yet. A walkthrough of the installation etc... The main part I've been having trouble with is editing the httpd.conf file for Apache;)
View Replies !
Mysql Apache And Php
i have just setup apache and php after 2 days of stress i stumbled upon a page that made the setup very easy. is there anybody that can tell me how i should incorporate mysql into this package or do i not need this pakage as i need a database
View Replies !
MySQL And Apache
I have apache installed, and php5 installed, and they both work perfectly, i just downloaded the newest mysql with the installer (the 35mb version). Do i need to confiure apache to use mysql or what do i do after installation of mysql?
View Replies !
MySQL, Apache
I want to use php pages to connect to MySQL and I am using Apache. Now my question is is there any sequence in installation of these packages like 1> MySQL 2> Apache 3> PHP I installed apche,php and then mysql. I am getting problem so is it bcoz of the sequence which I have followed wrong..
View Replies !
Mysql Or Apache
When i upgrade my equipment it may turn out that I will have two server available: 1. p4 1.8 512 mb of ram 2. p4 3.0e 2gb of ram I am trying to determine which of apache or mysql is mroe resource intensive as with two servers I can split the load. Or would i just be better off running both on the better server (#2)?
View Replies !
Seperate Apache
I'm considering opening a stand-alone MySQL hosting account and keeping the Apache processing on my existing shared web hosting server. The reason for this is that my host is running an old version of MySQL and insists I open a new account to get an upgraded version of MySQL. Question: Are there any speed benefits/disadvantages on running on a stand-alone MySQL server? Should I just bite the bullet and pay for a new account?
View Replies !
APACHE MYSQL AND PHP
I got a problem in configuring the MySQL 5.0.18 with PHP5. I have tried to configure the php.ini by setting the extension_dir = "c:phpext" and extension_dir = "c:php" since i just moved all my files from the installation directory to c:php. I also moved the libmysql.dll and php_mysql.dll from the ext directory to c:php and set the path variable to the c:php. I uncommented the php_mysql.dll and php_mysqli.dll too. The php with the apache server works fine. But with the mysql , it doesnt show nothing even when i tried if it has the mysql library is present, nothing comes out.Empty browser, plz i need help.I appreciate for your precious time. Even it couldnt give me error or anything,i couldnt figure if the php has really connected to the mysql server.
View Replies !
W2k + Php + Mysql + Apache
I have php, mysql, and apache installed on my w2k server and they all are working fine. How do I go about the following: 1. accessing these services from one of my w2k pro or win xp client systems? Do I need to install php and mysql on each of these in order to do what I need to do, or should i just work from the server? 2. Is this forum setup for both UNIX/Linux & NT related questions? 3. don't know jack about mysql and the site appears to be catered to a unix environment, are there any other locations to obtain tutorials or docs on setting up and administering this tool strictly from an NT perspective. I have a linux box, I just want to learn it in nt first.
View Replies !
PHP, PhpMyadmin: Apache?
I have installed php and mysql and now I want to install phpmyadmin. Do I have to install apache to run this programms? For what reason do I need apache (I have windows xp home edition and so I don't have IIS)?
View Replies !
Adserver With Mysql+apache
redhat p4 2GB ram - during peak time the server crashes with hundreds of queued processes (load average 70.00!!!). It serves approx. 1.000.000 impressions per day (page views) - images on remote servers. The database simply select + update views#. I was considering an upgrade to a bigger server with 8-10G RAM (mayby a dual xeon) or a cluster load balanced solution. The traffic could grow in the future! Also, I'm not sure if having 2 dedicated boxes for mysq and apache would be positive. At the moment I have all on the same box.
View Replies !
Converting An .SQL File To CSV/TSV With Apache?
Apparently you can use Apache (or an Apache product?) to take .SQL database backup files and turn it into a CSV file. Would it be easier to install MySQL, then execute the SQL backup file, then export from the database? Or does apache have something neat that converts it directly?
View Replies !
MySQL + Apache + Licenses
I have been asked to create a portal system for our floor. The floor consists of roughly 25 people etc. Basically i want to use Apache + MySQL since i'm familiar with both. However since this is at work i don't want to be bogged down with license issues. I would like to know if i can download MySQL + Apache and use it for free at work. I have skimmed through the licenses but i'm not very good at interpreting them. Hope someone here can shred light on if i'm allowed to do this
View Replies !
Apache 2 Won't Connect To MySQL
We have Apache2 and MySQL 4 installed on a Unix box, along with other things like Perl and PHP. One of the things we have to set up is folder authentication for certain restricted access pages. The problem is that Apache won't authenticate against the MySQL database. PHP does, and our Perl scripts does (at least from the command line), but Apache doesn't. I've set up a couple of test folders and Apache is correctly asking for the username and password, and I've created the tables with the appropriate username and password. The trouble is that the Apache error_log shows something like this each time the username and password are entered through the site: ...[error][client ...] MySQL ERROR: Access denied for user: 'User@localhost' (Using password: YES) ...[error][client ...] MySQL user rseitz not found: /working/umweb/robstest That "rseitz" is the username I set up in the database, and that folder is the one that I'm trying to set up authentication for. Here is the httpd.conf code that I'm using to require the authentication: <Directory /usr/local/etc/httpd/htdocs/umhome/working/umweb/robstest> AuthName "MySQL Testing" AuthType Basic AuthMySQLEnable On AuthMySQLHost localhost AuthMySQLDB mysql AuthMySQLUserTable user AuthMySQLUser User AuthMySQLPassword Password AuthMySQLPwEncryption Crypt <Limit GET POST> require valid-user </Limit> </Directory>
View Replies !
Apache 2, Php 5, Mysql 5 ~~> Error???
This is some of the things I have done for integrate apache 2, php 5, mysql 5 alpha: 1. make sure that php could run fine without the mysql support on. 2. edit php.ini: extension_dir=C:phpext 3. In c:windowssystem32, I have php5ts.dll only, nothing else related to php5 4. in c:windows, I have php.ini, nothing else related to php5 5. in apache2/bin directory, I have libmysql.dll 6. in php directory, I have libmysql.dll 7. in php/ext, I have libmysql.dll As you can see, I have libmysql.dll in three different places. But i still have problem. The error message when i restart apache by Apache monitor Service : the procedure entry point mysql_drop_db could not be located in the dynamic link library LIBMYSQL.dll and then: PHP Startup: Unable to load dynamic library 'C:phpextphp_mysql.dll"-the specified module could not be found
View Replies !
|
TRACKER
