473,385 Members | 1,615 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

FreeBSD 5.4 and Poor performance using MySQL Administrator

Thanks for the help in advance,

It has been over 5 years since I have messed with FreeBSD and I have
never messed with MySQL until now so forgive me if my issue is trivial
and I thank everyone for the help.

The hospital I work for is finally getting off of Micrisift IIS to
server the Hospital website. i built a FreeBSD server with Apache
2.0.54 and PHP5 as well as MySQl 5.x.x. Running queries on the server
locally is fast as lighting as well as is creating db's and tables. How
ever if I use MySQL query or Administrator it takes what seems like
like about a minute or more to finally connect. I believe I have ruled
out all network issues as this server also sits in our corporate dmz by
attempting to connect directly to the server via cross over cable with
a laptop.

I have been fuddling with this for about a week and it is supposed to
go into production next week. I do not know where to start so if anyone
could point me in the right direction it would be greatly appreciated.

i have looked at the MySQL documentation as well as searched all over
google.

Sincerely,

Steven Johnson

Apr 27 '06 #1
0 1090

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Andy Tran | last post by:
I built a system using mysql innodb to archive SMS messages but the innodb databases are not keeping up with the number of SMS messages coming in. I'm looking for performance of 200 msgs/sec where...
2
by: siliconmike | last post by:
http://dev.mysql.com/doc/mysql/en/freebsd.html says: You can link MySQL on FreeBSD 4.x against the LinuxThreads library, which avoids a few of the problems that the native FreeBSD thread...
3
by: news.sf.sbcglobal.net | last post by:
Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt. I'm...
23
by: | last post by:
hi i try to malloc 2G size mem . so i wirte code like that. it failt in freebsd 5.3 and win2k what's bug in my code ? how can i change it ? thank all :) benjiam
7
by: phillip.s.powell | last post by:
We're looking at a GUI interface for our MySQL DB and I am interested in MySQL Administrator, however, one of our requirements is to be able to import/export databases. Is this possible or do I...
1
by: ZacT1984 | last post by:
Hi, I am trying to set up my mySQL server on FreeBSD to log every query a user runs. I understand I must edit the my.cnf file. But one does not exist for my install. I installed mySQL from the...
4
by: Richard | last post by:
Hi All, I've been trying to build a Ruby-on-Rails plus MySQL application. I'm running Ruby 1.8.2, Rails 1.1.4 and MySQL 5.0.15-nt over WinXP-Pro/SP2. I run under an Administrative account. ...
4
by: Jim Devenish | last post by:
I have converted an Access back-end to SQL Server back-end but am having some problems. The Access to Access application has been running well for some years. I have successfully copied all the...
1
by: grabro | last post by:
Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will not work. When I try to acccess it I get the following message. linux:/home/grabro # mysql-administrator...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.