* NEWMEDIAPLAN > what variable values /mysql tuning you suggest for more than 2000 > potential concurrent users and big tables.
2000 concurrent users is much, at least if you mean 2000 concurrent requests to the database, as opposed to 2000 concurrent users of a web site. It is hard to give you a usefull answer without knowing more about your application. The default setting for 'max_connections' is 100, but this can be raised to 500-1000 for Linux and Solaris, according to the manual: <URL: http://www.mysql.com/doc/en/Too_many_connections.html > If there are many tables in the database (highly normalized database), and each query requests multiple tables (joins), then you may run out of file handles, because each query need at least one filehandle for each table in the query, usually more. <URL: http://www.mysql.com/doc/en/Table_cache.html > This is probably a bigger problem with MyIsam tables compared to InnoDb tables, because InnoDb stores data and indexes for all tables in a single (or multiple) tablespace, and only the table format as a separate file, while MyIsam tables use three files for each table: the format file (*.frm), the data file (*.MYD) and the index file (*.MYI). In most cases there is a middle layer server (application server), and this server could use a pool of connections to serve the real clients, it could cache query results, it could cache and delay inserts, and/or it could use a round robin method of selecting from multiple replicated mysql server slaves. Your initial question suggested that you mostly wanted to write to this big table, as it was described as a log file. If you want 2000 people to simultaneously query and/or update the same table, it's a lot more heavy. I think you would need multiple redundant mysql servers and replication, or very heavy hardware, probably both. :) > I still have doubts on mysql possibilities, and the correct setup. Need more info on your application. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
