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
See Related Forum Messages: Follow the Links Below to View Complete Thread
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.
Starting The Server
I've had my Instance starting whenever I startup my computer, which was working fine, until now. Every time I try to start it from the MySQL Administrator. I've tried to start the sertvice and It just goes right back to stopped and gived the log message, "Trying to start the server ... Server could not be started." How can I start the instance or find out what's going wrong?
Mysql Server Not Starting
I installed mysql on a Mac OSX 1.3.9. It worked and ran with no problems. The machine was restarted and mysql will no longer start up. I have tried everything and nothing works. If I look at the logs it basically tells me that mysql starts and then shuts itself off.
Starting Mysql Server
I installed mysql with apache but after a while mysql stoped starting. I even reinstalled both mysql and apache but still i can not start mysql. could any one tell me how to fix this problem.
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
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?
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.
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?
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.
Win2k
is anyone using the latest MySQL on the Windows 2000 server. I am trying to figure out if it more of a UNIX toy or a real good substitute for MSSQL 7. I know that it seems all I find is info on how to use it with UNIX and how to script it with PHP. I do not see much of anything about scripting it with ASP is it possible. I also wondered if it supported the auto increment feature as well.
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 ?
Mysql Services
How do you install multiple mysql servers as windows services
Win2K-MySQL Cyrillic
Win2k-PHP4.3.3-Apache2.0.43-MySQL4.0.15 I collect data from MSSQLServer,Access and MySQL. When I use MySQL, fields with cyrillic symbols from MySQL are not displayed correctly in the web page. But this problem doesn't exist with MSSQLServer and Access. If I use MySQL-client cyrillic data is displayed fine... Web page encoding is set to CP-1251. Does anyone had such a problem? And where is the problem - in MySQL or in Apache?
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.
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.
Wrong Path In Component Services
I am running Win 2000. I need to change the MySql excutable path in Component Services. When Iright click on Properties the path is wrong but can't change it from there.
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.....
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.
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.
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.
Apache And MySQL
I run an Apache server on a windoze box and need to get into the dizzy world of MySQL. I understood that MySQL was only a database but having read endless docs. it appears to be a server too. I run PERL on the Apache server and I wonder if there are any compatibility issues. It may be I am barking up the wrong tree and I am anticipating problems which simply do not exist.
Installing Apache
"(OS 10048)Only one usage of each socket address (protocol/network address/port) is normally permitted. : make_sock: could not bind to address 0.0.0.0:8080 no listening sockets available, shutting down Unable to open logs Note the errors or messages above, and press the <ESC> key to exit. 12..." why do i get this msg when trying to start the apache server..and the apache webpage didn't appear.
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.
[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.
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?
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..
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)?
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
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.
Installing Apache
I've recently delved into the web development world on my home computer, and as such have installed Apache 2.2.3 and just yesterday installed and set up PHP 5.2.0 both are working perfectly and I'm having a blast working playing with them and I am wanting to take to the final frontier and add databases to my playground. I know the basics of MySQL language, however I know absolutly nothing about the installation and configuring of said product. Im looking for a fairly spoon feed guide on how to install (what product / version) and how to get it integrated with my current Apache / PHP setup. Any pointers or help in this area would be greatly appreciated. EDIT: Forgot to mention this is for Windows XP (SP2).
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?
Apache@localhost
I run this site and database fine on my workstation but when I put it on the server I get the following error: CODEAccess denied for user: 'apache@localhost' (Using password: NO)
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;)
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
Installing MySQL With Apache?
I have mySQL installed on my machine as well as Apache. However, i haven't done any configuration of the httpd.conf file to tell apache anything about mySQL like i did with PERL. do i need to do any configuration before i can interact with mySQL through apache? or can i just have at it?
MySQL And Apache Efficiency
Having some troubles with MySQL and efficiency using Apache. Here's the set up: We have about 12 MySQL DB's running on a Linux server. We have approx 100 users accessing the DB via PHP scripts. However, the server load is way up to like 20-30 and everything is running at a crawl. We did get a PHP expert to look over the scripts and we're assured there's nothing wrong with them. So our guess now is that it must be: a] the server needs upgrading to a higher spec or b] apaches max # of users figure needs adjusting (I think it's set to 100 right now)
Apache Torque Question?
I am using torque3.1 with a MySQL database, I have a date field in my database and was wondering is there any way I can search on dates only in my database. Right now if I set the Criteria object to search for a date and pass it a java.sql.Date object, it searches for date and time, not just the plain date (yyyy-mm-dd).
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.
PHP, Mysql, Apache And Dreamweaver
I have setup a linux box with suse 9.3, apache and php.It appears the server is up and running (i can pull up the php.info etc from a remote machine). Now I would like to have my dreamweaver connect to the linux box so i can continue with my coding. How can i setup my dreamweaver to connect to the mysql database on the linux box? I also downloaded mysql odbc and tried to install on my windows machine but keeps saying cann't find mysq server. I have checked mysql server is running through the phpMyAdmin tool.
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>
Program MySQL With Apache
I don't even know what this is called, but I'm looking for a free tool that allows me to code MySQL and will work with Apache and PHP.
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
How To Setup Mysql Zip Package (XP,Apache,PHP 5.2)
I downloaded mysql-noinstall-4.1.22-win32.zip, and mysql manual also. When i read the manual i found quite a few modifications that i have to do in order to run my database properly. I don't want to use installer, couse my apache, php setup is on partition that i never format, and i need to make just one modification when i reinstall windows. I would like to do the same thing with MySQL, i mean, i don't want to do install it wrong way, and just need couple of advices on how to properly make all modifications to *.ini files, so i can store them somewhere safe, so when i format my computer i can set them back to the folders, and just run mysql from Bin folder. my folder is on D partition in folder www. Here's the structure d:wwwApache2htdocs <- apache htdocs folder d:wwwphp <- php folder d:wwwmysql <- mysql folder My database can use as much processor and memory power it needs to run a heavy scripting tool.
Apache & MySQL In Differentes Servers.
I've been running a slow Debian machine, with Apache + PHP + MySQL. But, with the time and usage, it's getting to slow to use MySQL. So, now I have another machine (running Debian too), and i've installed MySQL there with all the databases and users moved on to, it works perfectly (with phpmyadmin). What I want is to have the first machine running apache + php, and in the other MySQL. How can i do that ? I've tested making a mysql_connect from a page hosted in the first machine to the other one running MySQL but i didn't work, couldn't connect. I've tried redirecting mysql port to the other machine (iptables) and that didn't work either... Resuming... I want all my users to work with the first machine, they have their accounts in there and all their files, their pages, etc... And the database running in the other machine.
|
TRACKER
