what happened to error log in MySQL 4.1x/Windows XP

correct place for such a line (or both). Next, is there supposed to be a way to start/restart MySQL in Windows other than by going to the Services panel for the general computer? Is this something that can be done from the command line? Many thanks, ari [EMAIL PROTECTED] -- MySQL General Maili

Clipper RDD for MySQL ?

Where i found Clipper RDD for MySQL ? Ari [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

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

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

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]

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]

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

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: charset

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?

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

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 MYS

stress testing

Any suggestions? stress testers that have matched up against specific types of configuration? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

missing something obvious w/grant statement length?

RANT ALL ON *.* TO "[EMAIL PROTECTED]" IDENTIFIED BY "foo"; ERROR 1145: The host or user argument to GRANT is too long I must be missing something very obvious--how to incorporate a hostname with a hyphen, for instance. Can someone help? ari Ari Davidow [EMAIL PROTECTED] http://

Reverse DNS question

level? (Obviously I can restrict access to specific users - that's the next level of security down.) ari -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL 4.1 Production Release

production, or even (not speaking of MySQL here) that the implementation will be done in a way that is useful to you. ari At 03:00 PM 1/6/2004, you wrote: Any chance that there's a quarterly strategic roadmap published somewhere? I have projects that sometimes depend on a feature in the nex

Re: user d/b access

FLUSH PRIVILEGES; and all will work. ari -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

tab import question

oming data with the appropriate fields? Many Thanks, Ari D. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: tab import question

never mind... just discovered the --columns= option for mysqlimport. :-) On Jan 15, 2004, at 3:43 PM, Ari Denison wrote: Hi. I'm new to MySQL (and LOVING it) and have a simple question about importing tab delimited files into MySQL. I have a table in mysql called form_instances wit

Installing on Red Hat

hat can be done to fix it? Many thanks. MANY thanks to whomever can help me with this. Ari D. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing on Red Hat

k' (2) If that helps narrow down what's going wrong. On Jan 22, 2004, at 9:57 PM, Ari Denison wrote: A few quick questions for installing on red hat 9 (on a funky old Pentium 2 333mhz machine with 256MB ram). When I attempt to install the rpm for the server I get a HUGE list of confli

duplicating records

ields, just the data. Many thanks, Ari -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: duplicating records

void this error? Ari On Feb 17, 2004, at 7:13 PM, Sasha Pachev wrote: Ari Denison wrote: I have a need to duplicate individual records in a table with a large number of fields. This is not part of a backup or restore process. I simply need to be able to duplicate a record or two on occasio

Using Visio to diagram MySQL db, export SQL

is total toast for this purpose, is there a comfortable open source tool that works under windows that will let me/help me visually set up my entity diagrams as I work out my database schema? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list

Full Text Stopwords

ay from the stopwords list and have reindexed the field but still return no records. Any idea how to get my May students to show in full text search results? Thanks, Ari Denison -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Full Text Stopwords

s for the help! Ari On Sep 6, 2004, at 2:26 AM, Thomas Spahni wrote: Ari, what's the result of mysql -N -e "SHOW VARIABLES;" | grep 'ft_min_word_len' ? Default is 4 but you need to reduce this to 3 (or even to 2, if you want to match first_name against('Al')). Regard

Re: Full Text Stopwords

all the help Ari On Sep 6, 2004, at 10:11 AM, Michael Stassen wrote: Ari Denison wrote: the ft_min_word_length is now set to 3. That did the trick. Many thanks. I forgot to mention that I need to be able to perform boolean searches on the first_name field. If it's possible to do boolean sear

practical MySQL database size limits

arge MySQL databases? What are the practical limits under Solaris 2.8? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

two masters, one slave

Is it possible to have two masters and one slave? I'm trying to replicate two master databases so that I have a failover. The alternate, I guess, would be to have two instances of mysql listing on different ports on the slave server platform? ari Ari Davidow [EMAIL PROTECTED]

user table read only by root?

le. How can I make a table not read only? Thanks -- Ari - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <

mysql user table is read only by root

27; is read only' Or mysql> UPDATE user SET Password='mynewpassword' where User='root'; ERROR 1036: Table 'user' is read only Any idea on how I can go about replacing root's password? Thanks Ari on 2/25/02 1:41 AM, Ari Kahn at [EMAIL PROTECTED] wrote

@HOSTNAME@: not found

.internetfaxjack.com > === > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list a

my_print_defaults: not found

the startup to terminate. Is this something that can just as easily be disabled, or is there some information that is being sought here that should be placed correctly somewhere? ari Ari Davidow [EMAIL PROTECTED] www.klezmershack.com -

permissions for updating from one machine to another

NSERT? What would be a reasonable way to approach this? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manua

binding a domain name to a MySQL instance

launch. Is this possible? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

sum function doubling

known bug? I couldn't find anything. Or is it just my SQL? Any help is much appreciated! Thanks Ari - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (th