Ubuntu Servers :: How To Measure - MYSQL Performance

Mar 9, 2011

Recently set up a webserver at Linode. I've been reading alot about tuning the mysql, but other than hitting web pages and seeing how fast they load, how do I tell how well my tuning is working?

View 2 Replies


ADVERTISEMENT

Ubuntu Servers :: How To Measure Performance On A Computer

Aug 3, 2011

how do you measure performance on a computer?I know there are benchmark sites, they do give a general guidance in selection. However, I want to learn how to build a cluster from commodity parts and want to make sure it is equivalent to a specific server in performance.I know clustering is a bit abstract and it will be difficult to measure direct performance and compare it to one specific board. I am fine with that

View 5 Replies View Related

OpenSUSE :: Tool To Measure Cpu Performance?

Dec 22, 2010

anybody knows any tool to measure cpu performance on opensuse box, graphically would be great.

View 5 Replies View Related

General :: How To Measure Synchronization Performance

Jul 9, 2010

I'm looking for a tool for Debian Linux that can measure the synchronisation performance between two desktops.

I'm using RADClock instead of the NTP client to synchronise my desktops.

View 1 Replies View Related

Ubuntu Networking :: Measure Network Speed Between Two Servers

Jan 18, 2010

Any command line tool to measure the network speed between my two linux servers without taking disk speed into account? My network is supposed to be 100Mb, but it doesn't feel like that so I wonder where the bottleneck is. The numbers that I see doesn't correlate well to that. So I'd like to know the speed network card to network card.

View 2 Replies View Related

Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?

Jun 17, 2010

I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this

* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.

View 1 Replies View Related

Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?

Jan 14, 2011

i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :

Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing

[code]....

View 4 Replies View Related

OpenSUSE Hardware :: Slow Performance With Mutexes And MySql On Multi Core CPU - AMD Phenom II X4 965 - With 11.3

Nov 11, 2010

I have installed OpenSuse 11.3 32 Bit in a virtual machine on an older computer on a Windows XP host and on a new computer with AMD Phenom II X4 965 processor.

With sysbench I tested the performance of mutex and on the new computer it is 3 - 4 times slower than on the virtual machine. Other performance tests with sysbench for CPU, memory and threads are faster on new computer like expected. I tested this, because I have a slower performance of table creation in MySql tested with sql-bench, where creation of 10000 tables lasts 45 seconds on the virtual machine but over 400 seconds on the new computer.

I have tested with kernel-desktop and kernel-default but there are not large differences. File creation was tested with bonnie++ and is on newer computer faster as expected.

My questions are:
- Why is the mutex handling on the multi core CPU slower than in the virtual machine and how to speed up this?
- Or is there another reason why table creation of MySql is so much slower on multi core CPU?

View 7 Replies View Related

Ubuntu Servers :: Software Raid5 - Very Low Performance?

Mar 5, 2010

I recently installed a new home backup server with Ubuntu 9.10 x86_64 using the alternate CD. I used the CD's installer to partition my disk and created a software RAID 5 array on 4 disks with no spares. The root file system is located outside the raid array.

At first the array performed nicely but as it started to fill up, the io performance dropped significantly to the point where I get a transfer rate of 1-2MB/s when writing!

[Code]...

View 9 Replies View Related

Ubuntu Servers :: Setting Up A Cache Improve The Performance?

Feb 26, 2010

dns cache serThis is probably more of a network question but I figured some one who is a network expert might know. Currently my organization has DNS servers. But my questions is would setting up a cache server improve the performance any? When I first thought about it i thought probably not. But since it stores information in ram that made me think maybe it would improve network performance a little.

View 3 Replies View Related

Ubuntu Servers :: WRITE Performance Down On RAID 1 Array

Sep 7, 2010

I'm currently experiencing some serious issues with WRITE performance on a RAID-1 array. I'm running Ubuntu 10.04 64 bit server with the latest updates. To evaluate the performance ran the following test: [URL]... (great article btw!) Using dd to measure, write performance is only at 8.7 MB/s. Read is great though at 74.5 MB/s. The tests were ran straight after rebooting and I have not (YET!) done any kernel tuning or customization, running the default server package of the Ubuntu kernel. Here's the motherboard in the server: [URL]... with a beta bios to support drives over 300GB.

[code]...

As you can see from the bo column there is definitely something stalling. As per top output, the %wa (waiting for i/o) is always around %75 however as per above, writes are stalling. CPU is basically idle all the time. Hard drives are quite new and smartctl (smartmontools) does not detect any faults.

View 4 Replies View Related

Ubuntu Servers :: Next Steps In Improving SAMBA Performance?

Jul 13, 2011

I built my own file server based on the Intel Atom 525 and Ubuntu 11.04 (amd64):http:[url]....It has 2 2TB Western Digital Green drives connected via SATA.Internal file transfers (disk-to-disk) using Nautilus zip along at 80 Mb/sec. Over SAMBA, however, I'm getting 35 Mb/sec. Other than creating the shares, I haven't modified smb.conf.have a gigabit network. I've run atop on the receiving computer and it isn't being taxed. At 35 Mb/sec the file server is also not being taxed.

Should I be focusing on testing the onboard NIC (RealTek 8111E) in the file server or looking at SAMBA?

View 3 Replies View Related

Ubuntu Servers :: Performance Monitoring Tool For Trend Analysis?

Feb 9, 2010

It is vital to get a useful server performance monitoring tool that prevents growth related performance issues. Moreover, it should offer long term capacity planning and trend analysis along with detecting performance issues and unwanted outages.

View 3 Replies View Related

Ubuntu Servers :: Samba Filesystem Type Impacts Performance?

Jun 4, 2010

I installed a month or so ago a Samba File Server along with Active Directory integration in my company. I choose to install on my newly created raid array, all in ext3 filesystem. The purpose of this fileserver is to have lots of files from the different departments on the company (all windows workstations except mine). Everyone has a private folder and a department folder, along with the common folder for all employees.did I made a mistake formating all to ext3? would I get a significant increase in performance if I resize the current ubuntu partiton and created a new NTFS new one and move the files to it?

View 2 Replies View Related

Ubuntu Servers :: Linux Freezes When Running A JVM Performance Test?

Jun 6, 2010

I am in the process of running a set of performance tests for the latest Sun JVM 1.6.0_20. I am using for that the dacapo test suite: [URL]

I ran the test suite very often with all sorts of settings, but recently it happened once that my Ubuntu system froze. I could still ping the machine, but nothing else was responding any more, no screen output, no ssh login, not possible to switch consoles. After rebooting the system the system logs were quiet. No single trace of any problem.

I am using a custom compiled kernel 2.6.34: Linux i7 2.6.34-custom-201005231602 #1 SMP PREEMPT Sun May 23 16:06:01 CEST 2010 x86_64 GNU/Linux and I am experimenting around with the -XX:+UseLargePages JVM switch the requires to set-up the hugetlbfs on the Linux system: [URL]

A similar issue happened in March 2010 on one of our CentOS 5.4 systems where we run a heavy load Java application on, where we had to hard power off the machine and after the reboot there was no trace of the problem in the logs. On that server we used JDK 1.6.0_17 and did not use hugetlbfs.

My first question would be what to do so that next time something like that happens I have more information available after the incident to debug and analyse the problem?

View 3 Replies View Related

Ubuntu Servers :: Anyway To Control Server Remotely / Without Any Impact On Performance

Sep 4, 2010

I run a dedicated specialty Quake 3 Arena Server.It currently runs a stock Debian 5.05. These are the hardware specifications.

256mb SD Ram
10gb Hard Drive
Intel Celeron

I think I should be getting more speed then I am.I would like to install Ubuntu Server.What version is the most stable, and will provide the best speed?I have to download my server files from the internet. Is this possible without the GUI?Is there anyway to control my server remotely, without any impact on performance, VNC is a huge impact.I want to run a mail server as well, is this possible with out a performance hit?

View 9 Replies View Related

Fedora Servers :: Mysql At Boot Time In 10 / Get Mysql To Start At Boot?

Jul 28, 2009

I am trying to get mysql to start at boot without any success.

The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:

Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended

The same init script works fine in Ubuntu.

View 2 Replies View Related

Ubuntu Servers :: Use The Select Method On The Datatable Object The Performance Really Detoriates?

Apr 25, 2011

I am using MonoDevelop with SQL Server whenever I try to do use the Select method on the Datatable object the performance really detoriates it is 3 times slow than it is with .Net. Are there any work arounds?

View 1 Replies View Related

Ubuntu Servers :: Performance For Large Scale Website Or Critical Mission?

Aug 6, 2011

anyone of you could share if you have been using ubuntu for large scale website or critical mission project, say for 500.0000 secure transaction per 3 hours with 4 million users accessing server. how does ubuntu perform?

View 1 Replies View Related

Ubuntu Servers :: Slow Performance On File Server (LVM/ReiserFS/SoftwareRAID)?

Aug 18, 2011

It stores all my important stuff, as well as some music and movies.I use a second linux box in my living room to "stream" content via NFS or SAMBA share.The streaming tends to stop several times during playback, and needs to fill up its buffer again before continuing to play.I also have some Windows XP and 7 based computers that connect to this file server.I have noticed that directory listing is VERY slow, and there is a huge lag when I want to save/read a file from/to my home directory.

This is my setup:Ubuntu Server 10.10 64 bit (I have the same problem with 32bit ubuntu)
3 RAID5 arrays with 4 hard drives eachLVM on top of the 3 raid5 arrays.The Logical Volume i use is about 6.5TB, and I use the ReiserFS file systemThis LVM has grown over the years, and has had som replaced disks. So I have used the pvmove, and extend commands a bit.I have tried using IOTop and top to check if there is not enough resources available, but that doens't seem to be the problem.I haven't been able to find out why streaming over the network stops, but I know it is the server that causes the problem.Does ReiserFS have any performance problems with large logical volumes? Would changing to EXT4 or some other FS give any performance gain?

View 9 Replies View Related

Ubuntu :: Ondemand Vs Performance - Increases The Clock Speed To Performance When The CPU Is Under Load

Jul 31, 2010

I just wanted to know if having my laptop set to ondemand, will this affect performance in any way? I realize it increases the clock speed to performance when the CPU is under load, but does the time it take to go from ondemand to performance affect speed? Will there be any noticeable difference between the two setups? I have a dual core intel at 2.2GHz when in performance. When ondemand is set with no load it downclocks to 800Mhz.

View 7 Replies View Related

Fedora Servers :: Install Kqemu To The The Performance Improvements?

Jun 15, 2009

The kvm and qemu packages are integrated into a single package, but this doesn't mean qemu is integrated into the kernel now in any way does it? I should still install kqemu to the the performance improvements, right?

View 8 Replies View Related

Fedora Servers :: Install Of Httpd-devel Hurts Performance?

Jun 7, 2010

On F13 i386 inside Virtualbox. Host is a Win7 x64 box.

This may just be more idle curiosity than anything else since the server still works. . . but it's really bothering me because I can't explain it.

My (limited) understanding is that the devel files are just the source files and shouldn't actually affect peformance.

Yet, prior to installing httpd-devel (and its dependencies), /etc/init.d/httpd restart takes about 2 seconds total. After installing httpd-devel, the "stopping" phase of the httpd restart take 5-7 seconds (which seems really long when you're just sitting there waiting on it.

yum install httpd-devel also installs the following for dependencies:
db4-cxx
db4-devel
cyrus-sasl-devel
apr-devel
apr-util-devel
openldap-devel
expat-devel

All but one of those are devel files as well. And here's the real kicker: Uninstalling them through YUM doesn't put things back to normal (even after reboot).

I'm no linux expert. But I wouldn't think installing devel files would have this effect or any effect like this since they're just source code files (?). Can anyone explain what's happening or give me tips on how I can watch the apache process stop and see what's hanging it up?

View 2 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory

[Code]...

View 6 Replies View Related

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

Jun 2, 2010

i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error

[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.

[code]....

i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.

View 9 Replies View Related

Ubuntu Servers :: MySQL Will Not Start / What To Do?

May 4, 2010

I don't know. I have had tons of issues with the Linux today. Now when I try and start mysql it just fails. the syslog says code...

The command mysql results in:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have even tried to uninstall mysql and reinstall it an nothing works. Any suggestions?

View 4 Replies View Related

Ubuntu Servers :: MySQL Fails With My.cnf

Jun 5, 2010

I'm trying to start my MySQL server, and it fails if the /etc/mysql/my.cnf file is there. If it isn't, then it fails - syslog shows me this:

Code:
Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed

[Code].....

View 7 Replies View Related

Ubuntu Servers :: Weird Php And/or Mysql Bug?

Aug 20, 2010

I have probably found a bug in the Ubuntu php5 package. At first I thought it's a problem with Zend Framework, which I use, then I thought it's a php issue, but now it seems to be a problem with Ubuntu's php packages. My problem is that under certain conditions, php is going to read records from the mysql database table infinite times. For a much more detailed description of the bug,[URL]..

I've tried on an x86 Ubuntu Desktop edition, and an x64 Ubuntu Server edition, both 10.04, and both had this bug. I have set up a test system (x86 Ubuntu Server edition 10.04), and compiled apache2 and php5 from source, but used the mysql-server package from the repository. And I couldn't reproduce the bug. However, after copying the self-compiled libphp5.so file from the test system to the desktop that produces the error, I could still reproduce the error on the desktop. This suggests me that the problem is either not in php, or - more probably - there are multiple php binaries used in the repository version, and therefore it doesn't matter that I've copied my libphp5.so because mysql functions are somewhere else. I've found a mysql.so file in /usr/lib/php5/20090626+lfs coming from the php5-mysql package. Does that have anything to do with this issue?

View 8 Replies View Related

Ubuntu Servers :: Mysql Will Not Start?

Mar 14, 2011

ive been trying to fix this for a while. i dont have the original my.cnf, but i dont even know if thats the error:

Code:
pavel@pvl1:~$ sudo service mysql start
^C
pavel@pvl1:~$ cd /var/log/[code]....

View 1 Replies View Related

Ubuntu Servers :: Is There Php / Mysql Built In?

May 3, 2011

Is there a php,mysql built in?What folder do i put my website?What command do i need to use to start and stop apache?If there isnt php,mysql built in how do i install it ?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved