Re: shall i jump from 5.1 to 5.5
I've been running some bench marking between 5.1 and 5.5 myself and haven't notice any huge performance improvements on 5.5. Even though white papers claim it put performs 5.1. Any noticing the same or have some input in my findings? Regards, Alvin On Aug 16, 2011, at 3:55 PM, Prabhat Kumar aim.prab...@gmail.com wrote: correct. you have to understand the problem first. but still its recommendable to always use latest stable version. On Tue, Aug 16, 2011 at 10:02 AM, Reindl Harald h.rei...@thelounge.netwrote: Am 16.08.2011 17:59, schrieb Luis Daniel Lucio Quiroz: as far as my readings, they claim that 5.5 is the best my question is, shall i jump from 5.1 to 5.5. right now i have a performance problem, would 5.5 help me in that? Regards, LD why do you believe without any information you will get a useful answer? i have a performance problem is simply NO information if you even do not tell which storage engine and wich sort of problem in which context if you should update can nobody answer for you because we do not know if you have any crappy apps / scripts which would have troubles? we have upgraded some hundret webspaces and two dbmail-servers in februray becaus we know our self written applications and having test-environments, if you can do this can nobody say -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: shall i jump from 5.1 to 5.5
I know my previous email was vague, it was sent via smartphone. I’ve got a
simple PHP page pulling information from one of larger database tables:
PHP Code:
html
head
basefront face=Arial
/head
body
?php
// set server access variables
$host = 127.0.0.1;
$user = web;
$pass = password;
$db = md ;
// open connections to database
$connect = mysql_connect($host, $user, $pass) or die (Unable to connect!);
// select database to use
mysql_select_db($db) or die (Unable to select database!);
// create SQL query string
$query = SELECT * FROM members limit 1000;
//execute query and obtain result set
$result = mysql_query($query) or die (Error in query: $query. .
mysql_error());
// are there any rows in the result?
if (mysql_num_rows($result) 0)
{
// yes
// iterate through result set
// format query results as table
echo table cellpadding=10 border=1;
while($row = mysql_fetch_assoc($result))
{
echo tr;
echo td . $row['member_id'] . /td;
echo td . $row['fname'] . /td;
echo /tr;
}
echo /table;
}
else
{
// no
// print status message
echo NO rows found!;
}
// close connection
mysql_close($connect);
?
/body
/html
I’ve got apache benchmark then running 5 concurrent connections 10,000 times.
I changed the $host to the IP for the 5.5 server then to the 5.1 server and
here are one of my many results:
5.1 results:
Server Software:Apache/2.2.3
Server Hostname:aramos.dev
Server Port:80
Document Path: /mysqlfetch51.php
Document Length:35808 bytes
Concurrency Level: 5
Time taken for tests: 3263.909079 seconds
Complete requests: 1
Failed requests:0
Write errors: 0
Total transferred: 35964 bytes
HTML transferred: 35808 bytes
Requests per second:3.06 [#/sec] (mean)
Time per request: 1631.955 [ms] (mean)
Time per request: 326.391 [ms] (mean, across all concurrent requests)
Transfer rate: 107.60 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect:01 2.3 1 155
Processing: 593 1629 699.7 1524 13580
Waiting: 574 1611 699.7 1506 13562
Total:595 1630 699.7 1526 13580
Percentage of the requests served within a certain time (ms)
50% 1526
66% 1725
75% 1856
80% 1944
90% 2215
95% 2559
98% 4339
99% 4741
100% 13580 (longest request)
5.5 results:
erver Software:Apache/2.2.3
Server Hostname:aramos.dev
Server Port:80
Document Path: /mysqlfetch.php
Document Length:35808 bytes
Concurrency Level: 5
Time taken for tests: 3400.300474 seconds
Complete requests: 1
Failed requests:0
Write errors: 0
Total transferred: 35964 bytes
HTML transferred: 35808 bytes
Requests per second:2.94 [#/sec] (mean)
Time per request: 1700.150 [ms] (mean)
Time per request: 340.030 [ms] (mean, across all concurrent requests)
Transfer rate: 103.29 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect:01 2.7 1 168
Processing: 595 1697 724.8 1598 14505
Waiting: 577 1679 724.8 1580 14486
Total:596 1698 724.8 1600 14506
Percentage of the requests served within a certain time (ms)
50% 1600
66% 1799
75% 1939
80% 2028
90% 2314
95% 2640
98% 4387
99% 4805
100% 14506 (longest request)
I’ve ran tests even against our web sites and its slower than the 5.1 server.
Any suggestions, anything I should change on the 5.5 server? The hardware and
OS is identical from the 5.1 server. Thanks!
Alvin Ramos
From: w...@pythian.com [mailto:w...@pythian.com] On Behalf Of Singer X.J. Wang
Sent: Tuesday, August 16, 2011 4:08 PM
To: Alvin Ramos
Cc: Prabhat Kumar; Reindl Harald; mysql@lists.mysql.com
Subject: Re: shall i jump from 5.1 to 5.5
Are you doing concurrent workloads?
On Tue, Aug 16, 2011 at 16:04, Alvin Ramos alvin.ra...@reachsmart.com wrote:
I've been running some bench marking between 5.1 and 5.5 myself and haven't
notice any huge performance improvements on 5.5. Even though white papers claim
it put performs 5.1. Any noticing the same or have some input in my findings?
Regards,
Alvin
On Aug 16, 2011, at 3:55 PM, Prabhat Kumar aim.prab...@gmail.com wrote:
correct. you have to understand the problem first.
but still its recommendable to always use latest stable version.
On Tue, Aug 16, 2011 at 10:02 AM, Reindl Harald h.rei...@thelounge.netwrote:
Am 16.08.2011 17:59, schrieb Luis Daniel Lucio Quiroz:
as far as my readings
Re: shall i jump from 5.1 to 5.5
Thanks for the suggestions. I will change the tables to in innodb and change my
php coding. Then I will revisit the benchmarking with hopefully improving
results. Thanks again!
Regards,
Alvin
On Aug 16, 2011, at 7:57 PM, Johnny Withers joh...@pixelated.net wrote:
This is a poor benchmark because the query never changes. Query cache takes
over after first request.
Sent from my iPad
On Aug 16, 2011, at 4:28 PM, Alvin Ramos alvin.ra...@reachsmart.com wrote:
I know my previous email was vague, it was sent via smartphone. I’ve got a
simple PHP page pulling information from one of larger database tables:
PHP Code:
html
head
basefront face=Arial
/head
body
?php
// set server access variables
$host = 127.0.0.1;
$user = web;
$pass = password;
$db = md ;
// open connections to database
$connect = mysql_connect($host, $user, $pass) or die (Unable to connect!);
// select database to use
mysql_select_db($db) or die (Unable to select database!);
// create SQL query string
$query = SELECT * FROM members limit 1000;
//execute query and obtain result set
$result = mysql_query($query) or die (Error in query: $query. .
mysql_error());
// are there any rows in the result?
if (mysql_num_rows($result) 0)
{
// yes
// iterate through result set
// format query results as table
echo table cellpadding=10 border=1;
while($row = mysql_fetch_assoc($result))
{
echo tr;
echo td . $row['member_id'] . /td;
echo td . $row['fname'] . /td;
echo /tr;
}
echo /table;
}
else
{
// no
// print status message
echo NO rows found!;
}
// close connection
mysql_close($connect);
?
/body
/html
I’ve got apache benchmark then running 5 concurrent connections 10,000
times. I changed the $host to the IP for the 5.5 server then to the 5.1
server and here are one of my many results:
5.1 results:
Server Software:Apache/2.2.3
Server Hostname:aramos.dev
Server Port:80
Document Path: /mysqlfetch51.php
Document Length:35808 bytes
Concurrency Level: 5
Time taken for tests: 3263.909079 seconds
Complete requests: 1
Failed requests:0
Write errors: 0
Total transferred: 35964 bytes
HTML transferred: 35808 bytes
Requests per second:3.06 [#/sec] (mean)
Time per request: 1631.955 [ms] (mean)
Time per request: 326.391 [ms] (mean, across all concurrent requests)
Transfer rate: 107.60 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect:01 2.3 1 155
Processing: 593 1629 699.7 1524 13580
Waiting: 574 1611 699.7 1506 13562
Total:595 1630 699.7 1526 13580
Percentage of the requests served within a certain time (ms)
50% 1526
66% 1725
75% 1856
80% 1944
90% 2215
95% 2559
98% 4339
99% 4741
100% 13580 (longest request)
5.5 results:
erver Software:Apache/2.2.3
Server Hostname:aramos.dev
Server Port:80
Document Path: /mysqlfetch.php
Document Length:35808 bytes
Concurrency Level: 5
Time taken for tests: 3400.300474 seconds
Complete requests: 1
Failed requests:0
Write errors: 0
Total transferred: 35964 bytes
HTML transferred: 35808 bytes
Requests per second:2.94 [#/sec] (mean)
Time per request: 1700.150 [ms] (mean)
Time per request: 340.030 [ms] (mean, across all concurrent requests)
Transfer rate: 103.29 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect:01 2.7 1 168
Processing: 595 1697 724.8 1598 14505
Waiting: 577 1679 724.8 1580 14486
Total:596 1698 724.8 1600 14506
Percentage of the requests served within a certain time (ms)
50% 1600
66% 1799
75% 1939
80% 2028
90% 2314
95% 2640
98% 4387
99% 4805
100% 14506 (longest request)
I’ve ran tests even against our web sites and its slower than the 5.1
server. Any suggestions, anything I should change on the 5.5 server? The
hardware and OS is identical from the 5.1 server. Thanks!
Alvin Ramos
From: w...@pythian.com [mailto:w...@pythian.com] On Behalf Of Singer X.J.
Wang
Sent: Tuesday, August 16, 2011 4:08 PM
To: Alvin Ramos
Cc: Prabhat Kumar; Reindl Harald; mysql@lists.mysql.com
Subject: Re: shall i jump from 5.1 to 5.5
Are you doing concurrent workloads
queries take too many time
hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf), linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU PIII 800. But for some reason queries take too many time. During the long query, I did a mysqladmin proc to see what was going on. Under the column State I saw the value copying to tmp table which lasted a good 6 seconds. So I'm thinking that the copying to tmp table is slowing down the query - but I don't know why. I think I'm not the only one. Anyone can help me? -- Best regards, Alvin mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VB Application using myODBC?
Hi ppl, I have an application that used to run on ODBC to MS Access, but the application started slowing down after a period of time. Some of my friends suggested that it maybe due to the database. Which is why i am switching to mySQL. Can Anyone please provide me with the sample codes to connection and open the database for mySQL using myODBC?? I have already setup myODBC and tested the data source. It works! :P Please help! Thanks! alvin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC for VB application
Hi ppl, I am having problem with my existing application (writen in VB with ODBC to an Access database). The program starts crawling.. after running for a period of time. Slow down the entire production process. I was advise to change the database as the problem was most likely to be due to the Access database. Can anyone please advise how i could go abt it and what are the things i should look out for? Can i just install myODBC and export Access database to mySQL? Not sure how to do that too... Please help! Alvin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation problem
Hi, I'm trying to install MySQL into my Mac OS X 10.0.4 But i encountered problems halfway through the installation. I created a new netinfo directory mysql. After 'gunzip' and changed into the top-level directory, the './configure --prefix=/usr/local/mysql doesn't seem to workand there's no return command prompt. So i had to press the return key. And when i try to type 'make', 'make: *** No targets specified and no makefile found. Stop. ' appeared on the screen. Attached are two terminal screen display. I couldn't locate the config.log file in my system. If you need more informations, pls let me know. Thanks. Alvin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Best way to generate laser-printed reports from mysql
Shankar Unni wrote: [EMAIL PROTECTED] writes: I am wondering how most users generate reports from mysql that they can print on a laser printer (e.g. invoices)? [...] I guess some people user something like Crystal Reports via ODBC, but I wonder what most people do??? Use Crystal Reports :-)? Depends on (a) how professional you need the reports to be, and (b) how much you can afford.. But more seriously, you *could* create a layout for "tbl" (part of GNU "groff", available for all POSIX platforms and even NT via the cygwin port), and generate output using that template: .TS H page-header specs .TH other header specs. header lines body lines-- generate this using MySQL .TE And then run all this through "tbl" followed by "groff". Haven't tried this myself in this particular combination, but having used tbl in the past, I don't see any major conceptual problems with it. It's free, but needs some elbow grease to get it to work.. A "tbl" reference is at http://www.primate.wisc.edu/software/troffcvt/tbl.html. This question strikes a chord with me also. I started looking to see if there is any Perl modules/Bundles/Packages for generating postscript reports. What I have found is fairly primative. Does anybody have any suggestions?? -- Alvin Starr || voice: (416)585-9971 Interlink Connectivity|| fax: (416)585-9974 [EMAIL PROTECTED] || - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: potential vulnerability of mysqld running with root privileges
d some way to gain root privileges if shell access is granted, but it is far more difficult than the two-liner above, which each script kiddie can use. the point is correct. If you make the shell for the mysql user /bin/true you cannot do what you wanted to without root access. You don't really want to compare that, do you? You have missed the point. Btw, I don't need full shell access. I only need the possibility to create a link, for example a buggy CGI-script with www privileges which I can talk to executing ln -s /... you have crafted an example that is sure to fail in real life. Anybody who places there databases in /tmp is asking for trouble. This way two "harmless" bugs become a serious one. Just take a look at passwd or shadow file, crack it and you can have what ever you want. Well, the wit about shadow file is that it is *not* world readable. I always thought, that's what it's made for. It just makes the problem a little more diffuclut to deal with. It is not impossible to get access to the information in the file. If you lose control of your passwords you are beat. plain and simple. In other words: on a properly secured system, it's not impossible, but a lot more difficult to do what you are talking about. Now you are getting the point. I cannot really believe that you meant that stuff as a serious explanation that the bug shown above is not harmful. once again it is not a bug. It is the way the OS works. Last but not least, there is another matter. CREATE and FILE privileges also should not be granted lightly. Of course, that why I was explicitly talking about the fact, that the user needs CREATE privileges (FILE privileges are not needed, If I am not mistaken). If you can without becoming the "mysql user" and running a shell do what you want. then you have found a real MySQL bug. For example try this one. copy /bin/cp to /tmp/test before you create the database and before you make the symbolic link. They try to re-run your test. You should get different results - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Alvin Starr || voice: (416)585-9971 Interlink Connectivity|| fax: (416)585-9974 [EMAIL PROTECTED] || - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
