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
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
Dec 22, 2010
anybody knows any tool to measure cpu performance on opensuse box, graphically would be great.
View 5 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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