Re: Improve MYSQL performance on large database
Hello, Here, you can get some help: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ Regards. Salah NAIT-MOULOUD www.echovox.com | www.m-boost.com On Sat, Nov 8, 2008 at 7:08 AM, Guillermo Nardoni [EMAIL PROTECTED]wrote: Hello everyone, good evening. This is my first time posting here and it is just for asking...!!! Well, we are building a project for our customer wich is basically a searcher, google style. We use mnoGoSearch as indexer, 3.2.27-mysql, to more specific.!. We already try lots of version even compiling from source to discard indexer as a problem. The database, wich is about 20 gb and increasing!!!, is distributed among 5 server, 4 of 5 has SATA disks, 2 gb RAM, the 5th, is 512 mb ram and 80 gb SCSI 3 disk with adaptec 2940U as host scsi adapter. Well, after lots of testing, if you enter on the site, aka: www.lomejordetodo.com.ar, and type a text to search to. it takes about 5 minutues if query has lots of result, like linux kernel query. We read lots of posting, messages and googling but we couldn't solve the problem at all!. If anyone here has o had the same problem I'l give lots of thanks if you could show me the path to investigate. Regards Guillermo Nardoni Rosario - Argentina. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tuning a MySQL desktop database
Hello, Here, you can get some help: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ Regards. Salah NAIT-MOULOUD www.echovox.com | www.m-boost.com On Sun, Nov 9, 2008 at 12:33 PM, RP Khare [EMAIL PROTECTED] wrote: We are testing MySQL in production environment with real data. When the application is ready and all tests have been conducted well, we will finally migrate to MySQL Enterprise. At present our application is running on a desktop machine with MySQL 5.1 Community Edition installed on it. MySQL 5.1 is using default settings. Machine is: Pentium 4 with 256 MB RAM. What settings I need to change to tune MySQL? ... Rohit. _ Movies, sports news! Get your daily entertainment fix, only on live.com http://www.live.com/?scope=videoform=MICOAL
Master-Slave replication error: Last_Errno: 1146
Hi all. I have 2 MySQL servers. One master and one slave. In order to add new slave server, and because i can't stop the master one, i have tried this: http://forums.mysql.com/read.php?26,99846,102058 *You don't have to modify the other slaves configuration. What you need to do is obtain a snapshot of the data on those slaves with their current position relative to the master. The easiest way to do this is to stop mysql on one of the slaves and copy it's data directory (except for the bin logs) and my.cnf to the new slave. Then start the old slave so it doesn't get too far behind in replication. On the new slave change the server-id in my.cnf so it's unique from the other servers. Add skip-slave to my.cnf. Start mysql, login and run show slave status\G Then run the following command substituting the $values from the show slave status change master to master_log_file='$Relay_master_log_file', master_log_pos=$Exec_master_log_pos; Then start the new slave; Once replication catches up it's good to go :)* The issue is when i do START SLAVE; i obtain this error: Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 1146 Last_Error: Error 'Table 'XX.y' doesn't exist' on query. Default database: ''. Query: 'INSERT INTO y ' MySQL Server version: version 5.0.32 . Any idea ? Many Thanks. -- Salah NAIT-MOULOUD Echovox - www.echovox.com m-Boost - www.m-boost.com
Re: PHP Question
Hi. try this ?php mysql_connect('localhost', 'login', 'password') or die('Could not connect: ' . mysql_error()); mysql_select_db(election) or die (Could not select election database); $result = mysql_query(update election set Votes = Votes + 1 where Name='TheGuy'); if (!$result) { $message = 'Invalid update: ' . mysql_error() . \n; $message .= 'Whole query: ' . $result; } mysql_close($link); die($message); ? or this ?php $connect = mysql_connect('localhost', 'login', 'password'); if(!$connect){ die('Could not connect: ' . mysql_error()); } $db = mysql_select_db(election); if(!$db){ die (Could not select election database); } $result = mysql_query(update election set Votes = Votes + 1 where Name='TheGuy'); if (!$result) { $message = 'Invalid update: ' . mysql_error() . \n; $message .= 'Whole query: ' . $result; } mysql_close($link); die($message); ? regards On Tue, May 6, 2008 at 4:39 PM, Michael Condon [EMAIL PROTECTED] wrote: I have a PHP script that seems to be failing. I execute it using window.location.href(http://www.vote.com/vote2.php;): ?php $link = mysql_connect('localhost', 'login', 'password'); if (!$link) { die('Could not connect: ' . mysql_error()); } $result = use election if (!$result) { die('Could not connect: ' . mysql_error()); } $result = mysql_query(update election set Votes = Votes + 1 where Name='TheGuy'); if (!$result) { $message = 'Invalid update: ' . mysql_error() . \n; $message .= 'Whole query: ' . $result; die($message); mysql_close($link); ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Salah NAIT-M Echovox http://www.m-boost.com