Hi,
I faced a speed access problem today with the MySQL. In the morning was working well and fast, but after lunch when I tried to access the MySQl using Apache+PHP it was terrible. For just a select, it took 2 a 3 minutes to process. I checked the log files from Apache and PHP and I could not find any problem. The unique thing that I found was the hard-drive space. It was 1.7 GB. I am using Mac OS 10.3. So I cleaned and I got 3.1 GB and after 1 hour the fast speed came back.
Does MySQL use a lot the swap area? I am using Innodb.
Under certain circumstances it might. However, the problem you are describing seems to me more like a file system fragmentation issue - when the disk is crowded, newly created large files are likely to be fragmented. There could be a number of situations when MySQL will need to create a fairly large temporary file. Ideally you want to avoid them, and in most cases you can with careful programming, but very few applications actually do. When it happens, a crowded file system is likely to cause performance degradation.
Where I can find a tutorial or a good documentation that can help to set up a good MySQL environment, because I will hold a lot of data in near future.
I do not think one can write a comprehensive howto on the subject. In order to succeed at the task you will need to understand how MySQL works. With that in mind, to gain that understanding:
* read the list archives * read MySQL manual * try to optimize your own queries * participate in the list discussions * if you are a book person, read books
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
