Re: UUIDs - first usage for me

2005-09-17 Thread Gleb Paharenko
-- 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 A

Re: mysqldump and import

2005-09-17 Thread Gleb Paharenko
om/?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 arc

Re: QUERY CACHE TUNING QUESTION

2005-09-16 Thread Gleb Paharenko
>> +Qcache_not_cached+Qcache_hits)) * 100 >> >> >> >> As per the above analysis we observed that qcache hit rate came >> down after >> increasing query_cache_size from 10 MB to 32 MB and qcache_hits got >> increased but the remaining parameters Qcache_inserts, >> Qcache_not_cached, >> Qcache_lowmem_prunes also increa

Re: Too many Mysql processes at startup after upgrade to 4.1.14

2005-09-16 Thread Gleb Paharenko
is 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 ar

Re: re: determing how loaded my mysql server is

2005-09-16 Thread Gleb Paharenko
PUim7Yo713+GbcbZZ30Z0= > =AQZl > -END PGP SIGNATURE- > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ /

Re: Problem with symbolic link

2005-09-16 Thread Gleb Paharenko
y help > -- 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] /_/ /_/\_, /___/\___

Re: places index in separate DISK.

2005-09-16 Thread Gleb Paharenko
please correct me if i am wrong. > > regards > anandkl Ananda Kumar <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____

Re: user and hostname connection priveleges

2005-09-15 Thread Gleb Paharenko
t? > -- 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] /_/ /_/\_, /___/\___\_\_

Re: Adding auto increment value in the dump file

2005-09-15 Thread Gleb Paharenko
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.m

Re: Transactions are not enable

2005-09-15 Thread Gleb Paharenko
r] Transaction are not enable > Is ot a mysql server message or not ( my application ) > thank's > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __

Re: places index in separate DISK.

2005-09-15 Thread Gleb Paharenko
I am using Linux and MYSQL version 4.1 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /

Re: [newbie] moving mysql db to new server

2005-09-15 Thread Gleb Paharenko
m/?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 arch

Re: spanned indexes

2005-09-14 Thread Gleb Paharenko
x be saved? > > -thanks. > -- 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

Re: About database criterion

2005-09-14 Thread Gleb Paharenko
ating a > database? > > _ > MSN Explorer: http://explorer.msn.com/lccn/ > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____

Re: unexpected EXPLAIN result with subselect

2005-09-14 Thread Gleb Paharenko
uot; scan of t1, as t1 > will become huge. OTOH, the subquery will be very restrictive: The > number of data_ids will always be very small, at least compared to the > number of rows in t1. > > Are there any non-obvious reasons for the behaviour described above? Is

Re: Migration 4.0 to 4.1 performance problem

2005-09-13 Thread Gleb Paharenko
_ > Disk table 28.27k 0.83/s > Table 87.37k 2.56/s > File 19 0.00/s > > > ### top > top - 00:02:46 up 5:38, 3 users, load average: 1.84, 1.71, 1.50 > Tasks: 165 total, 1 running, 164 sleeping, 0 stopped, 0 zombie > Cpu

Re: serial primary key produces two indexes

2005-09-13 Thread Gleb Paharenko
please confirm my opinion? > > I am using version 4.1 > > Kemin > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ /

Re: Error msg: ERROR 1030 (HY000) at line 52: Got error -1 from storage engine

2005-09-13 Thread Gleb Paharenko
he middle word in life." > -- 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] /_/ /_/

Re: Benchmark of MyISAM vs Innodb vs Innod without FKs?!

2005-09-13 Thread Gleb Paharenko
so by how >much. If it's close to the speed of MyISAM then I'll be a happy camper. > >Thoughts? > >Kevin -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensi

Re: Behaviour of like expression

2005-09-12 Thread Gleb Paharenko
t; > > The like function returned everything instead of only the people without a > > name. Is this known (and correct) behaviour? It does not sound logical to > > me. I couldn't find anything about it on the mysql website. > > You didn't find it on the m

Re: Replication

2005-09-12 Thread Gleb Paharenko
t; | > -- 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] /_/ /_/\_, /___/\___\_\___/ My

Re: MySQL 5.0 crashes

2005-09-12 Thread Gleb Paharenko
p://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:h

Re: Adding InnoDB support

2005-09-12 Thread Gleb Paharenko
o 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.m

Re: innoDB and autoincrement

2005-09-12 Thread Gleb Paharenko
gt; Priya -- 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]

Re: Behaviour of like expression

2005-09-12 Thread Gleb Paharenko
does not sound logical to > me. I couldn't find anything about it on the mysql website. > > Thanks in advance! > > With regards, > > Casper Gondelach -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NE

Re: Copying data stored in different field formats from one table to another

2005-09-12 Thread Gleb Paharenko
>Am I using the wrong statement? How do I take a value from one field, such as >the date, and make it into a different format for inserting into another field >if the INSERT command won't accept those modifications? > -- For technical support contracts, goto

Re: searching through a mysql db/tbl

2005-09-12 Thread Gleb Paharenko
of describes/solves > what i've described, i'd appreciate it!!! > > thanks > > -bruce > [EMAIL PROTECTED] > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __

Re: default my.cnf vs huge.cnf nearly same performance with

2005-09-10 Thread Gleb Paharenko
9.00| 8.00| 8.00| > 5.00| 30.00| > update_of_primary_key_many_keys (256| 13.00| 13.00| 14.00| 17.00| 16.00| > 34.00| 37.00| > update_with_key (30)| 44.00| 43.00| 40.00| 29.00| 28.00| > 21.00| 148.00| > update_with_key

Re: Which License of MySQL Should We Buy?

2005-09-10 Thread Gleb Paharenko
> Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensit

Re: How to save graphs in a table?

2005-09-10 Thread Gleb Paharenko
Linear Accelerator Center > ph: 650-926-2879=20 > "Happiness is found along the way, not at the end of the road, and 'IF' = > is the middle word in life." > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita Thi

Re: stop loading when error

2005-09-10 Thread Gleb Paharenko
I > can figure what is wrong. > > The man page for this function, does not seem to give any hint: > http://dev.mysql.com/doc/mysql/en/load-data.html > > Kemin > > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponso

Re: MySQL install problems on OSX 10.4

2005-09-10 Thread Gleb Paharenko
r through socket > '/opt/local/var/run/mysqld/mysqld.sock' (2) > > Very confused as to why it isn't working. > > Any help most appreciated > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita

Re: Oddity with data pointer size

2005-09-10 Thread Gleb Paharenko
setting the value (and restarted the mysql service) if it > doesn't actually do anything? :) Or, what have I done wrong? > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.en

Re: Replication started but not running

2005-09-10 Thread Gleb Paharenko
Master_SSL_Cert: > Master_SSL_Cipher: > Master_SSL_Key: > Seconds_Behind_Master: NULL > > Any ideas as to what is locking it up? > > Thanks, > > Jeff > > > -- For technical support contracts, goto https://order.mysql

Re: Help with SQL Command

2005-09-09 Thread Gleb Paharenko
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 /

Re: Delayed UPDATE execution?

2005-09-09 Thread Gleb Paharenko
that time and even >unresponsive. > Would that affect the order of query execution? > >Any ideas? > >Thanks in advance for your help! > >Jenifer "Subscriptions" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.

Re: LVM-snapshot + mysqldump -- is this a reasonable backup strategy?

2005-09-08 Thread Gleb Paharenko
unmount and delete snapshot) > > So what monsters lurk within this backup strategy? > ..jim > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ _

Re: Copying data stored in different field formats from one table to another

2005-09-08 Thread Gleb Paharenko
user input. How do I combine > two fields from one table, and put them into another? > >Any assistance is much appreciated. Thank you. > > Dave > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET htt

Re: Talking Limit

2005-09-08 Thread Gleb Paharenko
m/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com

Re: log event entry exceeded max_allowed_packet

2005-09-08 Thread Gleb Paharenko
ram. > > Thanks for any help. > Jacob > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko /

Re: trouble understanding why query is not using the index.

2005-09-08 Thread Gleb Paharenko
| NULL | > NULL | NULL| NULL | Select tables optimized away | > ++-+---+---+---+---+-+-+------+--+ > 2 rows in set (0.00 sec) > > On Wed, 7 Sep 2005, Gleb Paharenko wr

Re: mysqladmin question

2005-09-08 Thread Gleb Paharenko
gt; mysqladmin is truncating the output, how can i disable this? >>> or is there a better way to examine what the serer is executing at that >>> moment in time? >>> >>> [EMAIL PROTECTED] root]# mysqladmin process >>> +-----+--

Re: Total newb at performance tuning mysql

2005-09-08 Thread Gleb Paharenko
er. > > Thanks again, and if there are any questions that would help me get a better > answer, please let me know. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/

Re: LARGE operation stuck. What now?

2005-09-08 Thread Gleb Paharenko
lp it. > >Thanks! -- 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

Re: Getting Record Count w/o doing 2 queries.

2005-09-07 Thread Gleb Paharenko
eality, my tables are very large, and involve joins, so executing > the query TWICE is taking its toll on the server. > Thanks! > Pow > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ens

Re: re:mysqldump: Error 2013

2005-09-07 Thread Gleb Paharenko
red 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]

Re: Why does Mysql use a filesort ?

2005-09-07 Thread Gleb Paharenko
> > vdg > > -- 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] /_/ /_/

Re: old settings

2005-09-07 Thread Gleb Paharenko
gt;Does someone know which files or registry entry/entries must be deleted >or reset? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gl

Re: trouble understanding why query is not using the index.

2005-09-07 Thread Gleb Paharenko
) syntax. Feel free >> to file a bug :) > > http://bugs.mysql.com/13024 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /G

Re: please help .........very urgent

2005-09-07 Thread Gleb Paharenko
__ > Click here to donate to the Hurricane Katrina relief effort. > http://store.yahoo.com/redcross-donate3/ > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/

Re: Sort aborted

2005-09-06 Thread Gleb Paharenko
ql.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 -- My

Re: query-log.html

2005-09-06 Thread Gleb Paharenko
gt;> >>> and yet it still insists on logging. How do I disable this? >> >>> (My current method is to use --log=/dev/null but I'm sure >> >>> this cant be the best way). I cant find any evidence of >> >>> a my.cnf anywhere, so I dont t

Re: Sort aborted

2005-09-06 Thread Gleb Paharenko
have a clue, what might be the problem ? > > Thanks > Bgs > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Pahare

Re: Replication problem

2005-09-06 Thread Gleb Paharenko
trator. > > Ideas welcome > > Cheers > Terry > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\

Re: How concerned should I be about Collation?

2005-09-06 Thread Gleb Paharenko
is by going to this web site: >http://grace.evergreen.edu/mysqlDoc/manual_Charset.html >But further searching via Google did not turn up any instructions > for specific commands to make the changes I am looking for. > >Any assistance is much appreciated. Thank yo

Re: Connections with bad DNS cause lockups

2005-09-05 Thread Gleb Paharenko
iting. Every other service >> >> > on the machine is fine, but MySQL becomes completely >> >> > unresponsive. When I said "DOS", I meant only against MySQL. >> >> > The rest of the machine is fine to process anything it wants. >> >>

Re: How to optimize fulltext selection?

2005-09-05 Thread Gleb Paharenko
ttp://qaix.com/ http://ryxi.com/ > http://gyxe.com/ http://gyxu.com/ > http://xywe.com/ http://xyqe.com/ > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net

Re: Confused about privileges

2005-09-05 Thread Gleb Paharenko
---+--++ > > If I issue the following command, no changes take place in the above tables: > > grant all on sfyc to todd identified by 'my_password' with grant option; > > Do I need to do an "insert SQL command" to specifically enter

Re: Connections with bad DNS cause lockups

2005-09-05 Thread Gleb Paharenko
t; is completely hung? >> >> >> >No other services are affected, only attempts to connect >> > to MySQL via the socket or TCP. This makes what little access there >> > is to the database (A searchable orchid database) stop, and monitoring

Re: Connecting using MyODBC

2005-09-05 Thread Gleb Paharenko
ver could not be loaded) > > Thanks for any help. > -Ryan > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko

Re: How to migrate from V4.0.23 to V5?

2005-09-05 Thread Gleb Paharenko
e > to another? > > I created all the tables my self using MySQL CC and I never did anything > special like incorporate innodb (sp?). > > Thanks, > Siegfried > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email

Re: how to design junction table?

2005-09-05 Thread Gleb Paharenko
SERT ... ON DUPLICATE... and maybe there > are others. (Apparently REPLACE will INSERT if it is not already there). I > was using REPLACE and now that I am using V5 I can use INSERT... ON > DUPLICATE. Which would be best? > > Thanks, > Siegfried > >

Re: Sorting results ith umlauts in UTF8 tables

2005-09-05 Thread Gleb Paharenko
bers > ORDER BY lastname > COLLATE utf8_general_ci > > returns: > $hlz > $der > Ober > Ohm > Ower > > The proper sorting order according to german sorting rules is: > Ober > $der > Ohm > $hlz > Ower > > > Any idea ho

Re: query-log.html

2005-09-05 Thread Gleb Paharenko
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

Re: How to optimize fulltext selection?

2005-09-05 Thread Gleb Paharenko
> > -- 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 PRO

Re: Migrating MySQL users

2005-09-05 Thread Gleb Paharenko
(0.00 sec) > > But still cannot login: > # mysql -u testing -psomepassword testing > ERROR 1045 (28000): Access denied for user 'testing'@'localhost' (using > password : YES) > > Thanks a ton for any suggestions! > -- For technical support

Re: How to optimize fulltext selection?

2005-09-03 Thread Gleb Paharenko
), > KEY subsubsubcategor (subsubsubcategor,rating), > KEY subcategor1 (subcategor,when_modifed), > KEY subsubcategor1 (subsubcategor,when_modifed), > KEY subsubsubcategor1 (subsubsubcategor,when_modifed), > KEY categor_2 (categor,language,rating), > KEY categor_3 (ca

Re: Remote access denial

2005-09-03 Thread Gleb Paharenko
> > Cheers, > Terry. > >> >> -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/

Re: Multiple query execution (probably OT)

2005-09-03 Thread Gleb Paharenko
port 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 -

Re: Connections with bad DNS cause lockups

2005-09-03 Thread Gleb Paharenko
the already >> > suggested >> > changing to pure IP, is there any other ways to stop the DOS? >> > >> >Thanks, Tuc >> > >> >> >> -- 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]

Re: Connections with bad DNS cause lockups

2005-09-03 Thread Gleb Paharenko
s, Tuc > -- 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] /_/ /_/\_

Re: Remote access denial

2005-09-02 Thread Gleb Paharenko
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

Re: show master/slave status privileges ?

2005-09-02 Thread Gleb Paharenko
> 'h4x0r'; > No luck there ethier. > > > Regards > Morten > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gl

Re: Trouble with revoke all

2005-09-02 Thread Gleb Paharenko
TECTED]> wrote: > on 9/2/05 1:27 AM, Gleb Paharenko at [EMAIL PROTECTED] wrote: > > > Modify them how? > show grants for 'root'@'localhost'; > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, > PROCESS, FILE, REFERENCES,

Re: Upgrade from 4.0.12 to 4.0.25

2005-09-02 Thread Gleb Paharenko
mysql/186726 > -- 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] /_/ /_/\_, /___/\

Re: database

2005-09-02 Thread Gleb Paharenko
tem:XP > Compiler: VC++ 6.0 > Architecture: i > > [-- text/plain, encoding 7bit, charset: us-ascii, 5 lines --] > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net

Re: Trouble with revoke all

2005-09-02 Thread Gleb Paharenko
work. > -- 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

Re: How to optimize fulltext selection?

2005-09-02 Thread Gleb Paharenko
sql.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]

Re: Connections with bad DNS cause lockups

2005-09-02 Thread Gleb Paharenko
gt;> > >> >Has anyone else seen this, or knows how >> > to stop it? >> > >> >Thanks, Tuc >> > >> >> >> -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sp

Re: Install error on fedora Core3

2005-09-02 Thread Gleb Paharenko
how to fix it??? > > Thanks, > > Jeff > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / //

Re: install_driver (mysql) failed

2005-09-02 Thread Gleb Paharenko
pport 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

Re: Master Log Files

2005-09-02 Thread Gleb Paharenko
name program reports the machine name correctly i.e. foo. > > > Cheers, > Tedy > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___

Re: Master Log Files

2005-09-01 Thread Gleb Paharenko
ql.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 archiv

Re: a mysqldump question

2005-09-01 Thread Gleb Paharenko
; `f15` varchar(50) default NULL, > `ad_username` varchar(50) default NULL, > `valid` tinyint(4) default NULL, > `expire_days` int(11) default NULL, > `sold` tinyint(4) default NULL, > `notify` int(11) default NULL, > `is_special` int(11) default NULL, > PRIMA

Re: replication slave's warnings

2005-08-31 Thread Gleb Paharenko
n 32080517 in log 'tana-bin.001' produced > 6 warning(s). Default database: 'TSM' > > What's happened? How i can see the "produced warning" on the slave? > > Thanks in advance, > Francesco Dalla Ca'. &g

Re: Mysql can't start

2005-08-31 Thread Gleb Paharenko
Hello. >> # /etc/init.d/mysql start >> Starting MySQL database server: mysqld...failed. Sorry for replying to myself, but this link is helpful as well: http://dev.mysql.com/doc/mysql/en/starting-server.html Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. &

Re: Mysql can't start

2005-08-31 Thread Gleb Paharenko
> Aug 31 12:16:03 cagliostro /etc/init.d/mysql[4544]: > > > thanx -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/

Re: too less place for whole info in innodb status

2005-08-31 Thread Gleb Paharenko
rt 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 &

Re: table in use

2005-08-31 Thread Gleb Paharenko
om/?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

Re: stopping drop index command on table

2005-08-31 Thread Gleb Paharenko
t). > > Thanks in advance. > -- 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] /_

Re: Connections with bad DNS cause lockups

2005-08-31 Thread Gleb Paharenko
it? > >Thanks, Tuc > -- 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 PROTE

Re: Server hangs and table gets corrupted on simple subselect

2005-08-31 Thread Gleb Paharenko
) =3D 1; > > As mentioned, none of these work and all of these hang the server and > break the database. > > How do I do this? > -- 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]

Re: Linux+AMD64+MySQL.

2005-08-30 Thread Gleb Paharenko
What's the best io scheduler for 20GB MyISAM DB? I'm currently using > cfq. > 3) Does anyone have any tips on running MySQL+AMD64+Linux? > > Thanks a lot! > > Best regards, > RV > > -- For technical support contracts, goto https://order

Re: A lot of instances of mysqld

2005-08-30 Thread Gleb Paharenko
le=/var/lib/mysql/db.forum.com.pid.pid --skip-locking --port=3306 > --socket=/var/lib/mysql/mysql.sock > > > tia, > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ /

Re: [Replication] Problem connecting to master

2005-08-30 Thread Gleb Paharenko
--+---+ > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_

Re: AES_DECRYPT output

2005-08-29 Thread Gleb Paharenko
ng an ORDER BY or GROUP BY, right? > > Kind regards, > > Martin > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko

Re: mysqldump: Error 2013

2005-08-29 Thread Gleb Paharenko
nyone shed some light on how >to successfully back up this database? > >Thanks! "Gustafson, Tim" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __

Re: [Replication] Problem connecting to master

2005-08-29 Thread Gleb Paharenko
lib > > [mysqld_safe] > err-log=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > -- > > Could not see skip-networking anywhere. > > Greetings Jan > > -- For technical support cont

Re: Key Buffer Size

2005-08-29 Thread Gleb Paharenko
.15. Most of my configuration is in lines with > my-huge.cnf. > > Thanks in advance for your help. > > Cheers > > Manoj > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www

Re: AES_DECRYPT output

2005-08-29 Thread Gleb Paharenko
e MySQL server: > Public ConnectionString As String = "driver={MySQL ODBC 3.51 > Driver};server=localhost;uid=root;database=mydatabase" > > As you can see the version of the Connector is 3.51. I use MySQL version > 4.1.11. > > Martin > > >>F

<    1   2   3   4   5   6   7   8   9   10   >