Claus Bo Hansen wrote:
> "If you need big tables ( > 2G), you should consider using 64 bit hardware
> like Alpha, Sparc or the upcoming IA64. As MySQL uses a lot of 64 bit
> integers internally, 64 bit CPUs will give much better performance."
>
> But in the MySQL benchmark Results on different platforms
> (http://www.mysql.com/information/benchmark-results/result-mysql-platform.ht
> ml)
> it seems like Intel Pentium machine out-perform anything else significantly
> !
>
> Can you give me hints on which platform to use ?
MySQL is most used on Linux/x86 and Sun/Solaris platforms. So if you
want to use most tested platform, take Sun Sparc. Sun Ultra Enterprise
450 is one of the most used servers for MySQL I have seen.
> If possible - can you give me a rough estimate on how many select operations
> the server can handle per second ? (I now it's an impossible question, but I
> am just interested in the order of magnitude)
Check out our benchmarks page on:
http://www.mysql.com/information/benchmark-results/result-mysql,pg.html
and around it. Benchmark is included in MySQL distribution, so you can
run it on your site with modifications if you need.
--
+----------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Tõnu Samuel |
| /*/ /*/ /*/ \*\_ |*| |*||*| tonu@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn, Estonia |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------+
