Re: sample my.cnf
Martin Gainty [EMAIL PROTECTED] wrote: I recently downloaded 4.1beta when i run the DB initialisation utilities I get D:\MySQL\mysql\binmysqld-opt --skip-grant-tables 031128 16:18:09 Can't find messagefile 'I:\MySQL\share\english\errmsg.sys' I:\MySQL was my old (now deleted) folder I suspect that I can set the MySQL path via my.cnf or my.in but cannot find any my.ini or my.cnf in the downloaded zip Could someone supply me their my.ini or my.cnf so I may overcome the hardcoded I:\MyMySQL spec? You should create my.cnf (my.ini) manually. Examples of my.cnf (my-huge.cnf, my-large.cnf, my-small.cnf) file you can find in the MySQL directory. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
How to Deploy MySQl with VB
Hai .. Iam Sreedhar , If iam not wasting ur time - please help me out. Prob: Is it neccessary to instal MYSQL Software in clients place to do transactions with database. for example: If an an application is developed using MS-Access and VB then we have to add .MDB file in PD . There is no need to Install MS-Access. My Question is , What are the files we have to add (MYSQL files) at the time of Package and Deployment? Waiting for ur reply Sreedhar Love, Sreedhar Reddy .D - Do you Yahoo!? Free Pop-Up Blocker - Get it now
Re: MySQL log files
Admin-Stress [EMAIL PROTECTED] wrote: How can I enable MySQL 4.0.16 log ? I just compiled and installed it in my RedHat 9.0 system, but I cant see any log files. I use default /etc/my.cnf from my-large.cnf. Depends on what exactly logging you want to turn on (binary, update, general query log, slow query log) you should put to the my.cnf appropriate entry. For example, to enable binary log put to the my.cnf: [mysqld] log-bin -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
Re: Order by a number not leading in zero
Scott Haneda wrote: I have the following... tSql = SELECT l.team, l.link, lc.category, l.age, l.date FROM league AS l INNER JOIN league_category AS lc ON l.category = lc.id WHERE lc.id = prepSQL(tConn, id) AND l.status = '1' ORDER BY l.age, l.date; L.age has data in it as varchar() where there are some without a leading zero. Bit of a late response ... try: ORDER BY lpad( l.age, 7, '0' ), l.date It might slow down response as index on I.age is no longer used by sort. On the long term consider storing the value with prepended zeros and trim them during select: SELECT l.team, l.link, lc.category, trim(leading '0' from l.age ), l.date HansH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL users.
Check also the other tables in the `mysql` database such as db and host to make sure that there are no entries of that user with 'locahost' as host. If you created the entries earlier, there is a chance that the entries are still there with the localhost entry. Or simply delete everything in DB table and restart. Hope this helps. Thanks Emery - Original Message - From: m i l e s [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED] Sent: Saturday, November 29, 2003 02:26 Subject: Re: MySQL users. Emeyr miles'%' or miles% or [EMAIL PROTECTED] or miles@'%' all FAIL to authenticate. and that's in the USER table in the USER field. do I need to change any other tables and fields ? Sincerely, -- M i l e s President Toolbox Architect MagicMiles Software (413) 374 - 5161 PO Box 414, Northampton, MA 01060 http://www.servicetoolbox.com/ http://www.workshoptoolbox.com/ http://www.healingartstoolbox.com/ http://www.artshoptoolbox.com/ We create content management systems for the rest of us, starting at $25.00 a month, includes domain registration, web hosting, email and webmail. Great for Yoga Teachers, Massage Therapists, Lawyers, Doctors, and any professional! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC and MySQL 4.1
I know how to grant privileges but the problem is with the password type of mysql 4.1.0 After granting privileges using GRANT (in 4.1.0), I can only login using the mysql client. But I can't use the same username and password for logging in. Nor MyODBC will succeed. But c:\mysql\bin\mysql.exe will login without any problem. I think it's a compatibility issue. Thanks Emery - Original Message - From: abaid al-mutairy To: Director General: NEFACOMP Sent: Saturday, November 29, 2003 08:30 Subject: Re: MyODBC and MySQL 4.1 To create a new user use the Grant command from the mysql command prompt: Mysql GRANT ALL PRIVILEGES ON *.* TO user1@'%' - IDENTIFIED BY 'some_pass' WITH GRANT OPTIONGRANT ALL PRIVILEGES this will allow the user1 with the some_pass to access the database Director General: NEFACOMP [EMAIL PROTECTED] wrote: Hi groups, does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new passwords? When I create a password using PASSWORD( ), I can only login using the MySQL client (the one that comes with MySQL). But if I create the password using OLD_PASSWORD( ), I can login from both my applications and the MySQL client!!! Curious!! The server says: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I received this error when I used - MySQL Front 2.5 - MySQL Control Center 0.9.2 - My Application developped in VB using MyODBC 3.51 to connect I have not yet tried PHP. I searched the archives but found only one people who faced the same problem but I didn't see any message saying that he got a solution. Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when encrypting passwords? Any advice? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- Do you Yahoo!? Free Pop-Up Blocker - Get it now
MySQL separate downloads
Hi group, This is not a problem as such but a limitation. I have a problem with downloading MySQL due to its download size. Can someone tell me where I can get MySQL in separate files? For example I am interested in only the standard MySQL binary for WinNT (mysqld-nt.exe) But, I cannot find where to download it alone since the package contains everything (the clients that I never use, the ---max version that I think I don't need, ...) and this makes the size of the package something 20MB which is very big for DialUp connection!!! Also, I sometimes need an updated documentation but I cannot get it alone without downloading everything I hope the packaging team will do something for us disabled people. Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/
Re: MyODBC and MySQL 4.1
I have found the issue. It is talked about at the URL http://www.mysql.com/doc/en/Password_hashing.html The question now is When Will MyODBC support that new hashing? Thanks Emery - Original Message - From: Director General: NEFACOMP [EMAIL PROTECTED] To: abaid al-mutairy [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 29, 2003 13:43 Subject: Re: MyODBC and MySQL 4.1 I know how to grant privileges but the problem is with the password type of mysql 4.1.0 After granting privileges using GRANT (in 4.1.0), I can only login using the mysql client. But I can't use the same username and password for logging in. Nor MyODBC will succeed. But c:\mysql\bin\mysql.exe will login without any problem. I think it's a compatibility issue. Thanks Emery - Original Message - From: abaid al-mutairy To: Director General: NEFACOMP Sent: Saturday, November 29, 2003 08:30 Subject: Re: MyODBC and MySQL 4.1 To create a new user use the Grant command from the mysql command prompt: Mysql GRANT ALL PRIVILEGES ON *.* TO user1@'%' - IDENTIFIED BY 'some_pass' WITH GRANT OPTIONGRANT ALL PRIVILEGES this will allow the user1 with the some_pass to access the database Director General: NEFACOMP [EMAIL PROTECTED] wrote: Hi groups, does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new passwords? When I create a password using PASSWORD( ), I can only login using the MySQL client (the one that comes with MySQL). But if I create the password using OLD_PASSWORD( ), I can login from both my applications and the MySQL client!!! Curious!! The server says: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I received this error when I used - MySQL Front 2.5 - MySQL Control Center 0.9.2 - My Application developped in VB using MyODBC 3.51 to connect I have not yet tried PHP. I searched the archives but found only one people who faced the same problem but I didn't see any message saying that he got a solution. Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when encrypting passwords? Any advice? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- Do you Yahoo!? Free Pop-Up Blocker - Get it now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: Retrieving info from a Joined column
This is what I tried to find an entry in the column, but it doesn't work for some reason. This is a download center, and I want to se if $cfpd[5] has already been downloaded. my ($dls, @downloads); $query = qq{ SELECT downloads,bytesdown,filesdown FROM $utable WHERE handle=? }; $sth = $dbh-prepare ( $query ); $sth-execute ($user); $sth-bind_col(1, \$dls); while ($sth-fetch) { @downloads = split(/:/,$dls); } push(@downloads,$cfpd[5]); # added this part to find item $already_downloaded = 0; foreach $dl_file (@downloads) { if ($dl_file eq $cfpd[5]) { $already_downloaded = 1; last; } } if ($already_downloaded eq 0) { # end addition my $downloads = join(':',@downloads); if ($dl =~ /$song$/) { $query = qq{ UPDATE $utable SET dlcounter=dlcounter-1, downloads=?, bytesdown=bytesdown+$fsize, filesdown=filesdown+1 WHERE handle=? }; }elsif ($dl =~ /$video$/) { $query = qq{ UPDATE $utable SET dlcounter=dlcounter-3, downloads=?, bytesdown=bytesdown+$fsize, filesdown=filesdown+1 WHERE handle=? }; } $sth = $dbh-prepare ( $query ); $sth-execute ($downloads,$user); Any ideas? On Sat, 29 Nov 2003 00:53:10 +0100 Hans van Harten [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: From: Bruce Therrien [EMAIL PROTECTED] Date: 2003/11/28 Fri PM 01:42:14 CST To: [EMAIL PROTECTED] Subject: Retrieving info from a Joined column We have a column in our table that has new info added each time using a JOIN function. The data sample makes me rather think update table set field=CONCATE(field,':','more') The data is separated using a : separator. This doesn't answer your question... However, note that in most instances using columns with multiple values is a bad idea in a relational database. If possible, you'd be better off with a design that does not require multiple values in a single column. I'ld second that. However, to maintain compatible output to your Perl script consider GROUP_CONCAT http://www.mysql.com/doc/en/GROUP-BY-Functions.html How does one retrieve this info from the colomn and put it into list format, In Perl there is 'split'; takes a 'field delimiter and a string to return an array of strings. or check for duplicates, Using 'where NOT( field LIKE '9807:' and field LIKE ':9807' and field LIKE ':9807:' ' ) within your UPDATE should do the tric or do a search in the column for a certan string. On an existing data base you might consider LIKE ... where field LIKE '9807:' and field LIKE ':9807' and field LIKE ':9807:' Adding a ':' to both the beginning and end of the content would obsolete the first and second part of the above. However, you need to 'shift' and 'pop' a pair of empty fields in Perl AND change to CONCATE(field,'more',':') HansH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Bruce Therrien [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Win32 Service
Robert ... An excellent suggestion. Our best Programmer / Analyst has already reviewed the source code, and his conclusion is that there is absolutely nothing 'non-standard' about the way MySQL installs/removes services. G R Jensen -Original Message- From: Robert Rowe [SMTP:[EMAIL PROTECTED] Sent: Friday, November 28, 2003 8:05 PM To: Gerald R. Jensen; Stefan Hinz Cc: [EMAIL PROTECTED]; robert_rowe Subject:Re: MySQL Win32 Service If I understand correctly, the MySQL source is available. If you are familiar with the code that registers/starts/stops services you might want to take a look at it. You might even try sending that section of the code to the vendor and challange him to tell you how it is non-standard. Robert Rowe --- Gerald R. Jensen [EMAIL PROTECTED] wrote: Stefan: I think you have just reinforced my position ... our contention is that MySQL works the same way as any other application that installs as a service. We have a number of applications (written by our own programming staff) that all use exactly the same procdure used in MySQL to install the service. I think the vendor in question has buggy/incomplete code, and is blaming MySQL for their problems. G R Jensen - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; robert_rowe [EMAIL PROTECTED] Sent: Friday, November 28, 2003 5:38 PM Subject: Re: MySQL Win32 Service Gerald, How closely does the MySQL Service on Win32 platforms conform to any known standard for installing/removing services? I raise the question because the vendor that provides the utility we use to create our installation package claims that MySQL uses non-standard commands for installing and removing services. As a result, they say, we cannot expect their program to install or remove the service. The irony is ... their program **does** install the service. It just can't stop the service and remove it. We use a third-party installer because we package the six databases our software suite requires with MySQL. I'm not sure I'm getting what you're after, but here's what MySQL does: shell mysqld --install # installs a service with the name Mysql shell mysqld --install MyMySQL # installs a service with the name MyMySQL shell mysqld --remove # removes a service with the default name (Mysql) shell NET START Mysql # starts the service called Mysql shell NET STOP Mysql # stops the service called Mysql shell would be something like c:\mysql\bin, depending on where you've installed MySQL. mysqld may as well be a different flavour of the MySQL server, e.g. mysqld-max-nt. What --install does is write a couple of entries to the Windows registry, and --remove will delete those entries. I don't know whether that procedure is considered standard on Windows systems or not; if it isn't, you might want to have a look at what --install actually writes, and then use a standard way of writing those entries (using a .reg file or whatever). Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Win32 Service
At 08:29 29/11/2003 -0600, Gerald R. Jensen wrote: Hi Gerald, all Some comments about this thread: Installer tools handle the service application in basic general way, I think the vendor would said non-simple service than non-standard service. For example MySQL aborts the service start if the configuration file was not created and edited the variables basedir/datadir if the install location is different than the default one. Also MySQL has 3 types services: the default MySQL which the image path don't have argument, a custom service with an extra argument for the service name and a custom service with 2 extra arguments the --defaults-file= option and service name. In my opinion I don't expect that these installer tools does that task instead I prefer the tool provide me a way for to launch an external custom DLL or console application which contents the routines for. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL separate downloads
In the last episode (Nov 29), Director General: NEFACOMP said: Can someone tell me where I can get MySQL in separate files? For example I am interested in only the standard MySQL binary for WinNT (mysqld-nt.exe) But, I cannot find where to download it alone since the package contains everything (the clients that I never use, the ---max version that I think I don't need, ...) and this makes the size of the package something 20MB which is very big for DialUp connection!!! Downloading a 20MB file at 14.4 modem speeds should take 3 hours. Not really that long, and you could always download for an hour each night, and resume where you left off the next day. If you can't download a 20MB file, how on earth are you keeping up with the security patches released by Microsoft? :) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: UFT-8 support under mysql-3.23.5x?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Zsolt Koppany wrote: Hi, we use mysql-3.23.5x? under Linux and cannot upgrade to 4.x. Our java applications can store and fetch UTF-8 characters we have problem only with sorting. Any ideas how I can fix the problem? Zsolt If you can't upgrade to 4.1 (where you could apply a collation to your sort), you will have to do your sorting _outside_ of MySQL, and _after_ you've converted your UTF-8 characters to full unicode characters (and even then, you will need to pick a collation for sorting). UTF-8 encoded characters have no real sorting order (there is a 'natural' one that works for some cases, but not all). UTF-8 is an _encoding_ that can encode many different unicode character sets, it's not a character set itself (like latin1, Cp1250, etc), so the notion of 'sorting' doesn't really make sense with it. Regards, -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/yNF5tvXNTca6JD8RAuwFAKCskNb6c2VkR13Ek0215gH4dGAxxwCcCuJE rmOfdxR4op4coIm+McMkrK0= =NC3f -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql Server Overload
Hello Everybody, We have a relatively busy e-commerce shop running MySQL 4 + PHP 4. We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram because our last server was very slow. On this new server at peak times when we receive in the region of 150 to 200 connections at anyone time, our server grinds to a halt. In the processes the cpu is being used 99%! In the no peak periods it happily chugs along at between 1% - 30% which is fine. The memory is not even being used that much during the peak periods. I have played around with the config with no real noticeable differences. FYI Our database is roughly 25mb with 450 products. I have tried indexing some tables with no real joy either. Another related point, in the MySQL documentation it says in the mysqladmin show extended status that the Select_full_join value should be zero mine is very high, what does this mean? Please help I'm losing hair at a rapid rate! -- Best regards, Nev mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Images in a table
How can I insert images in a table if I can do it with MySQL? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
HELP!
hi I bought a book with your mySQL program and seemed to have installed it worng and i cant stop it. I never set a user name or a password. ~AndyR.
Database replication
Hi, I'm working on setting up db replication, and I have a question. If I have a master server, which will replicate to a slave, what about vice versa? What I'm thinking I want to do, is load balance between two database servers (our mail authentication database) using the Cisco LocalDiretor. My concern is, if db0 replicates to db1, what if the LD directs the connection to db1, and it tries to write to the database. Will those changes be done on db0 also? What would be the best way to go about doing this? Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Images in a table
Yes, you can insert the binary into a table. Richard -Original Message- From: Zenzo [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 1:42 PM To: MySQL List Subject: Images in a table How can I insert images in a table if I can do it with MySQL? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.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]
Re: MySql Server Overload
Nev wrote: We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram because our last server was very slow. What operating system? Another related point, in the MySQL documentation it says in the mysqladmin show extended status that the Select_full_join value should be zero mine is very high, what does this mean? It means you don't have your tables properly indexed. When you do a join, ideally MySQL should be able to join the tables using indexed fields. Instead, Mysql has to walk thru your entire table to find the records for the join. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Database replication
Ok, but the slave would also replicate to the master? Is anyone using this type of setup? Thanks, Richard -Original Message- From: Chuck Gadd [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 6:34 PM To: Richard Bewley Subject: Re: Database replication Richard Bewley wrote: Hi, I'm working on setting up db replication, and I have a question. If I have a master server, which will replicate to a slave, what about vice versa? It works, but there is no conflict resolution built in. If both servers update the same record, it will cause problems. I believe you would also have problems if both servers added records to a table with an autoincrement field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database replication
Richard Bewley wrote: Ok, but the slave would also replicate to the master? Is anyone using this type of setup? Both machines would be set up as both masters and slaves. We tried it during the Mysql class I took a few weeks ago. Worked fine, except for when there were conflicting updates. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installing MySQL on Fedora
I tried installing MySQL on Fedora and all seemed to go fine, but there is no mysqladmin. Have I missed something here? And I am not sure where the mysql executable resides. The version is MySQL-3.23.58-1.i386.rpm Todd -- inline: NewLogo.gif
DB Replication
Hi, I did manage to get two-way replication to work properly, but I have to type: mysql load data from slave; This is the only way it replicates the data. Is there a way to have it replicate back and forth in real time? Thanks, Richard -Original Message- From: Richard Bewley [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 6:33 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Database replication Ok, but the slave would also replicate to the master? Is anyone using this type of setup? Thanks, Richard -Original Message- From: Chuck Gadd [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 6:34 PM To: Richard Bewley Subject: Re: Database replication Richard Bewley wrote: Hi, I'm working on setting up db replication, and I have a question. If I have a master server, which will replicate to a slave, what about vice versa? It works, but there is no conflict resolution built in. If both servers update the same record, it will cause problems. I believe you would also have problems if both servers added records to a table with an autoincrement field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: MySql Server Overload
At 07:34 PM 11/29/2003, you wrote: Hello mike, Saturday, November 29, 2003, 11:45:59 PM, you wrote: m At 11:14 AM 11/29/2003, you wrote: Hello Everybody, We have a relatively busy e-commerce shop running MySQL 4 + PHP 4. We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram because our last server was very slow. On this new server at peak times when we receive in the region of 150 to 200 connections at anyone time, our server grinds to a halt. In the processes the cpu is being used 99%! In the no peak periods it happily chugs along at between 1% - 30% which is fine. The memory is not even being used that much during the peak periods. I have played around with the config with no real noticeable differences. FYI Our database is roughly 25mb with 450 products. I have tried indexing some tables with no real joy either. Another related point, in the MySQL documentation it says in the mysqladmin show extended status that the Select_full_join value should be zero mine is very high, what does this mean? Please help I'm losing hair at a rapid rate! m Nev, m 1) Is your MySQL server on the same machine as your web m server? If so, then split them. Yes I am considering this. Also dual processors will speed things up some, perhaps by 30%. m 2) Is the problem related to reads or writes to the database? What's the easiest way to check? Chuck may be right in that your joins are not using indexes. Use Explain select to see which indexes are being used for your joins. If indexes are being used, then investigate: Show Status or Show Status like key% to get just some of the lines. Look for Handler_Write which shows the number of times a write was performed Max_Used_Connections, If Opened_Tables is large then increase table cache size. Select_Full_Joins: The number of joins that did not use indexes Select_Scan: Number of joins that did a full scan of the first table Table_Locks_Waited: # of times the operation had to wait to get a table lock Also look at join_buffer_size which is the size of buffer used in non-index joins. If for some reason you can't use an index in the join, you may have to change this setting. Needless to say, you want to use an index if at all possible when running on a webserver. Mike m 2a) If the problem is with reads, I'd recommend put a Limit 10 or m 20 on your Select statements so they don't pull too much data at one time. m Chances are they are only going to look at the first 10 choices anyway. To m get the next page, increment the page # and increment Offset m which=(PageNum-1)*RowsPerPage. m 2b) If the problem is with writing to MyISAM tables have you m looked at InnoDb for the tables with a heavy # of updates? m 3) I've also found that 20%-25% of the CPU time is spent loading m the PHP script from the disk. Every time the PHP page loads, it needs to m re-read the PHP file(s) from disk. You can speed this up considerably by m creating a small RAM drive and put your PHP script files on that. Change m your PHP configuration to look for the RAM disk first. m 4) You can try a PHP accelerator. There are several free ones out m there. Yeah I will try this. m 5) You can of course replicate the data to 2 machines and use a m load balancer to handle read queries. Updates would be made to one database. m 6) If all else fails, shave your head and tell the ladies you are m Vin Diesel looking for a new co-star in XXX-2 and you'll forget all about m your MySQL problem. g Yes this sounds the best solution, I wish I could forget! m Mike Thanks for the suggestions -- Best regards, Nevmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
New To MySQL Connector J
Hi I am new to MySQL connector J. I do not know how to install it. I just downloaded the .zip file and I am using XP Home. I want to use it with tomcat which is already running OK. I need someone to help me how to install it and connect to MySQL which is also installed and working fine. Thank you. -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail)
RE: Installing MySQL on Fedora
As far as I am aware mysqladmin is a server control program so it comes with the mysql-server RPM .. The one listed below is purely a mysql client and shared library package. Regards, Phil. From: Todd Cary [mailto:[EMAIL PROTECTED] Sent: 30 November 2003 01:02 To: [EMAIL PROTECTED] Subject: Installing MySQL on Fedora I tried installing MySQL on Fedora and all seemed to go fine, but there is no mysqladmin. Have I missed something here? And I am not sure where the mysql executable resides. The version is MySQL-3.23.58-1.i386.rpm Todd -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]