Dramatic performance problem
Hi to every body, I am newbie for mysql lists. I have a mysql server with 2GB of ram and Core2Duo cpu. Until today mysql server had very acceptable performance results. But today, server is very slow. No db change, no php code change. But I can't find the reason of this slowness. I am using MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew Montgomery - to set up my.cnf and some results are below (Results are taken from script but server is up only 2 hours) TABLE CACHE Current table_cache value = 2060 tables (THIS VAS 512 I HAVE INCREASED) You have a total of 204 tables You have 771 open tables. The table_cache value seems to be fine MAX CONNECTIONS Current max_connections = 500 Current threads_connected = 9 Historic max_used_connections = 232 The number of used connections is 46% of the configured maximum. Your max_connections variable seems to be fine. MEMORY USAGE Max Memory Ever Allocated : 1 G Configured Max Per-thread Buffers : 2 G Configured Max Global Buffers : 554 M Configured Max Memory Limit : 2 G Physical Memory : 1.96 G Max memory limit exceeds 90% of physical memory How can I define the problem of performance? Best Regards, OKAN
mysql order question
I have a sql query like SELECT * FROM table WHERE id IN (4,88,23); Result order in ID is: 4,23,88 But I need to receive result in order 4,88,23. So how can I manage to receive result in order LIKE IN() clause? regards, okan
Query help
I have 3 tables Table 1: user(id, name, surname) Table 2: crime(id, detail) Table 3: user_crime(id, user_id, crime_id) Table 1 1, OKAN, ARI Table 2 1, "detail 1" 2, "Detail 2" Table 3 1, 1, 1 1, 1, 2 So user 1 takes 2 crime from crime table... I want to receive info with 1 query: I need name surname and his crime_ids of user_id 1 So result might be: user_id, name, suername, crime_ids 1, OKAN, ARI, {1-2} Is it possible? gibi Mumkun mu? - Iletisim teknolojilerinin gucunu ispatlayan iletisim teknolojileri dergisi: Tele.com.tr http://www.tele.com.tr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: charset
yes it is mysql 4.0 how can I set i to latin 5 or how can I set the server to latin 5? os: centos 4.2 Thank you - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 31, 2006 1:40 PM Subject: Re: charset Hello. In case mysql4 is mysql4.0 there should be a server system variable default_character_set. If it is 4.1 see: http://dev.mysql.com/doc/refman/4.1/en/charset-syntax.html http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html OKAN ARI wrote: How can I set the characterset to latin5 for mysq4 in linux? OKAN -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
charset
How can I set the characterset to latin5 for mysq4 in linux? OKAN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: good database design
sorry for wrong reply:( And Did you do an analysis to come to this conclusion? Is it really MySQL that's hogging your CPU? Did you analyse what queries were bringing the server down? The senteces above are my big problem. How can I be sure about the quesries making my server down Please, any link, any info, any word is important forme. I can't find the right start point. Thanks OKAN - Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: Sent: Thursday, September 22, 2005 11:25 AM Subject: Re: good database design Hi, Please reply to the list and not to me personally only. I want to explain my condition. I have a web site that habe 110onlne users at same time. But cpu usage is 2.00/2.00 (p4 3.0ghzHT) I think my database design is horrible because of this high cpu load. Did you do an analysis to come to this conclusion? Is it really MySQL that's hogging your CPU? Did you analyse what queries were bringing the server down? SO I want to learn something about good database design. Can you suggest any thing to me? Read a book, any book, that describes the normal forms. After that, analyse your queries and their plans and see if any indices are needed. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
good database design
I need links about good database design information for high loaded web sites... regards, okan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to benchmark performans
How can I test the performans benchmark of my MYSQL? For instance how can I learn query per second information? And any other informatioin? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
innodb and myisam and db optimising
I have a web site that have 100unique users online at the same time. I will optimize DB structure. 1. Is there anysource about mysql optimization and performance tricks? 2. I can change the DB type, which is the best for high mysql traffic web sites, innoDB or MyIsam? Thanks