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 MYS
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
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
sql4 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?
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]
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
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 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]
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
