I have a query that I need to tune.
Basically, substr a text, and select first and last entry.
The table is currently a few million rows big. Index is on FromHost (text
field) and ReceivedAt (index field)
Is the best way to optimize my query.
1) create an index on substr() and the two date columns
Can someone point a link, or show an example.
basically, i have something like
select week(mydate), count(mystuff) from table group by week(mydate);
however, I need week to start on Wed 9am and end next Wed.
What's the easiest way to accomplish that?
thanks,
andrey
--
MySQL General Ma
ne by one... yes, i
know there are app drawbacks to my approach, but it's an inventory db.
I am open to other suggestions (e.g. I think something like that might be
doable via Access too, but it's obviously not web based)
Thanks,
-Andrey
--
MySQL General Mailing List
For list archiv
Is there are a reason why this wouldn't work?
select upper( monarch.group_decode(lower(hg.alias)) ) from
nagios.nagios_hostgroups hg;
++
| upper( monarch.group_decode(lower(hg.alias)) ) |
++
| database
ohts or streams.
Thanks,
andrey
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Have identical versions installed, in one query works fine, in another,
pukes with the error in the subject.
When I query by hand (via mysql client) works fine.
Not even that much data to complain about!
mysql> select
-> group_concat(concat('',hosts.name,'') order by hosts.name asc
separa
All,
We are using group_concat but there seems to be some sort of display
limit.
Is there are a way to unset or increase it?
Thanks,
Andrey
DROP FUNCTION IF EXISTS secs_to_hrs;
DELIMITER |
create function secs_to_hrs (secs varchar(10))
returns varchar(13)
DETERMINISTIC
BEGIN
return CONCAT_WS(' h ',lpad(secs/60 div 60,3,' ') ,
CONCAT(lpad(round(secs/60 mod 60),2,' '),' mins') );
END;
|
DELIMITER ;
What if I wanted to not display mi
I knew I’ve seen this error before ☺
Thanks a lot.
-andrey
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 30, 2007 1:55 AM
To: Andrey Dmitriev
Cc: mysql@lists.mysql.com
Subject: Re: query question
>Thanks.. It doesn't seem
o:[EMAIL PROTECTED]
Sent: Monday, October 29, 2007 4:00 PM
To: Andrey Dmitriev
Cc: mysql@lists.mysql.com
Subject: Re: query question
Hi,
Andrey Dmitriev wrote:
> This is kind of achievable in Oracle in either sqlplus mode, or with
the
> use of analytical functions. Or in the worst case by w
omething
like
| SSH | mt-ns4,
tsn-adm-core, tsn-juno, tsn-tsn2 |
Can this be done w/o writing procedural code in mysql?
We are running ver5.
Thanks,
Andrey
RMAN or EXP.
Thanks,
Andrey
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
\On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote:
\> Hello,all.
\> There is the function "phpinfo" in the PHP interpreter, which allows to\>
know configure options. Is there analog ability in Mysql?
\The equivalent command for mysql is: mysql> show variable
\On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote:
\> Hello,all.
\> There is the function "phpinfo" in the PHP interpreter, which allows to\>
know configure options. Is there analog ability in Mysql?
\The equivalent command for mysql is: mysql> show variable
on 2-d server. Changes
go to the 1-st server by replication.
And only then replication of this changes is done the cashes of data
must be updated
That is why I need the condition of changing some tables on 1-st table.
Hi Andrey.
Andrey Kotrekhov wrote:
SQL
Hello!
Is there any way to inform
Hello,all.
There is the function "phpinfo" in the PHP interpreter, which allows to know
configure options.
Is there analog ability in Mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
second process?
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Can someone advise the best way to determine
a) the # of days since the first of the month from last month (e.g. from
5/1/07)
b) the # of days since the end of last month (e.g. from 5/31/07)
Is there are a good way to determine the # of workdays in a month.
Thanks,
Andrey
--
MySQL General
It depends on what's in the datetime column.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Something like this:
select store.storeid, store.stName
from store left outer join transaction
on(store.storeid = transaction.storeid)
where transaction.created IS NULL
and store.ac
Thanks, that works..
Next question
Does MySql support using it's own functions within this code?
E.g. I tried
set str = select concat (str,'hello');
set str = concat (str, 'hello');
And it didn't seem to like either.
Thanks,
-andrey
_
From
Perhaps a better solution is to determine why mysql is 'hogging'
resources in the first place.
There is a tuning section in MySQL manual.
-a
-Original Message-
From: Chuck Swiger [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 5:46 PM
To: Don O'Neil
Cc: [EMAIL PROTECTED]; [EMAIL
All,
I've been trying to create a function that will generate URLs so that I
wouldn't have to wrote ugly SQL all the time. After no success, I've determined
that I don't seem to be able to create functions at all. I am relatively new to
mysql development (or management), so any advice is apprec
st regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Добрый день.
Yes, this has been reported on this list a couple times already.
Really baffling how this one made it out of QA.
Thank you for your answer.
Are there any plans to release snapshort bugfix?
Josh
On Thu, 23 Dec 2004 21:43:27 +0200 (EET)
Andrey Kotrekhov <[EMAIL PROTECTED]> wrot
4.1.8
4.1.7 compiled on the same PC at the same time with .so suffix in library
names.
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list archives:
I did the following (before that I have created the
table) :
mysql> load data local infile "/home/andrey/Desktop/sample2.txt" into table ALARM FIELDS
ESCAPED BY '\\';
Query OK, 1 row affected, 1 warning (0.03 sec)
Records: 1 Deleted: 0 Sk
Can you post one or 2 sample lines from alarm.txt ?
Regards,
Andrey
P.S.
(i am not on [EMAIL PROTECTED] so add me to the CC:)
[EMAIL PROTECTED] wrote:
Hi,
I tried with the spool option to get the data from the tables in the oracle.
For this go to pl/sql editor, go to file menu, select
-db \
--without-isam \
--without-innodb \
--enable-thread-safe-client
because I need koi8 charset and etc...
And I don't have any problem
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
Did you compile mysql from source or you use precompiled binary package?
I use mysql with different versions
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
hould I set that my programs/clients have
character_set_client and etc is set to koi8r ?
Is this possible?
May be it is bug?
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL Gen
then client gives to server
string withanother
charset as column 'price', but comparing two strings is possible only if
they have
identical charsets and collations .
Thats all
Andrey Kotrekhov wrote:
Добрый день.
Andrey Kotrekhov wrote:
SQL
Hi, all!
I have a problem afte
/ www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Best regards.
___
Andrey Kotrekhov [EMAIL PR
" ??
> gpg: ÷???: ??!
> gpg: ??? ?? ?? ??. http://www.gnupg.org/faq.html
> gpg: ??? ??? ???, 6 2004 ?. 16:09:38 EEST ?? DSA ? ID
> 663AF798
> gpg: ?? ? ???: ?? ??
t where price rlike '_R';
ERROR 1267 (HY000): Illegal mix of collations (koi8r_general_ci,IMPLICIT)
and (latin1_swedish_ci,COERCIBLE) for operation 'regexp'
I can't find this in docs.
I try to set LC_COLLATE in environtment variables
like
setenv LC_COLLATE ru_RU.KOI8-R
But there
e &" has worked
> > for anyone. In order to turn that on, I will need to take our site
> > down completely, which is (of course) not desirable.
> >
> > Thanks!
> >
> > Steve Meyers
> >
>
>
> --
> MySQL General Mailing List
> For list archives:
VP> Can you supply us with an example? Some explain plans to corroborate your
VP> reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
I've made some experiments and can
VP> Can you supply us with an example? Some explain plans to corroborate your
VP> reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
SELECT ...
FROM positionReports p
, Andrey Chernyh.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/ // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> ><___/ www.mysql.com
> >
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.co
__ ___ __
> / |/ /_ __/ __/ __ \/ /Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
><___/ www.mysql.com
>
>
>
>
>
> --
> MySQL General Mailing List
&
SQL
Hi!
> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> > SQL
> > Hi, All!
> > Is 4.1.1 replication compatible with 4.0.x?
> >
> > I have problem to replicate data from 4.0.17 to 4.1.1
> > show slave status show all are OK
> > perlicate positi
.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ng mysqld, grants work again.
>How-To-Repeat:
Fix:
I don't know. But restarting server restore grants working.
>Submitter-Id:
>Originator:Andrey Kotrekhov
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
Synopsis:existent gr
gt; --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
т
Hello Binay.
Friday, December 19, 2003, 2:04:51 PM, you wrote:
B> Hi Andrey,
B> many thanks for quick response. plz find my further query below.
>> AFAIR, you usu. do that with:
>> LOCK TABLE mytbl WRITE;
>> // do smth. here
>> UNLOCK TABLE mytbl;
B> ++
/ do smth. here
UNLOCK TABLE mytbl;
--
See you,
Andrey.
[ [EMAIL PROTECTED] | ICQ# 114087545 | 2:5090/[EMAIL PROTECTED] ]
...I know on which side my bread is buttered. -- John Heywood
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
p
> SET analit.status=price_grp.status, analit.currency=price_grp.currency
> WHERE analit.price=price_grp.price AND analit.service=price_grp.service
> AND analit.city=price_grp.city AND label=1070931600'.
> Default database: '' _ 0_ 2210187 _
&g
re');
or
INSERT INTO ttt (id, name) VALUES (NULL, 'some name here');
INSERT INTO ttt (id, name) VALUES (NULL 'another name here');
Anyway, you'll get the following two records after that:
1, 'some name here'
2, 'another name here'
I hope t
SQL
Hi all!
Nearly very night I have this problem.
This query is done every 3 hours. But problem is happened only at 3:00
Both master and slave are 4 CPU (2 with HTT) computers.
Both have mysql 4.0.16
And when I test table analit. There are many records which have the same
conditions as in WHERE s
length. Values are not padded; instead, trailing spaces are removed
when values are stored. (This space removal differs from the SQL-99
specification.)
[taken from 6.2.3.1 The CHAR and VARCHAR Types of MySQL Reference Manual]
--
See you,
Andrey.
[ [EMAIL PROTECTED] | ICQ# 114087545 | 2:50
; For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
www.mysql.com
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Best regards.
___
Andrey Kotrekhov [EMAIL
Добрый день.
> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> > Hi, All.
> > Other question is:
> > Can I create case sensitive field with right ordering of national
> > characters.
> >
>
> Take a look at collation name: "ci" at the end of th
use fields as binary.
> But I don't want binary on each field.
> I need old types on fields.
>
> How can I resolv this?
>
> Best regards.
> ___
> Andrey Kotrekhov [EMAIL PROTECTED]
> ISP Alkar Teleport
> тел. +38
on't want binary on each field.
I need old types on fields.
How can I resolv this?
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list
SQL
> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> >
> > Sorry. I am wrong. Situation is worse.
> > Both tables aren't replicate to the slave.
> > But query try run it on slave :(
> >
> > slave: mysql-4.0.13
> > master: mysql-4.0.14
r example, master has tables A, B
> But slave has only A table
>
> The problem:
>
> query: UPDATE A,B SET A.a=B.a WHERE A.c=B.c;
> the result: crash replication on slave;
>
> Is it right?
>
>
> Best regards.
> ___
>
?
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ual/en/install.windows.php
--
Astashov Andrey, Web developer
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/mysql --user=mysql
--pid-file=/var/lib/mysql/sight2.pid --skip-locking --log-slow-queries
>>/var/lib/mysql/server.err 2>&1
Number of processes running now: 1
mysqld process hanging, pid 31502 - killed
030730 00:45:52 mysqld restarted
--
Best regards,
Andrey
While accessing MySQl data base by means of perl the value of variable $! sometimes
equals " Resource temporarily unavailable". At the mean time everything works correct.
What does that mean?
___
http://chat.bigmir.net/ - ñàìûé óäîáíûé
deas would be highly appreciated!
Thank you,
Andrey
PS. Please respond to my email address directly, as i am not able to subscribe to the
mailing list.
-
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
I've got a problem using temporary tables. Tring to make one (mysql> CREATE TEMPORARY
TABLE ... ) I recieve an error message:
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'hardware'
At the mean time all other sql requests work correctly. How
I've got a problem using temporary tables. Tring to make one (mysql> CREATE TEMPORARY
TABLE ... ) I recieve an error message:
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'hardware'
At the mean time all other sql requests work correctly. How
Hi,
I jusr downloaded the latest release of mySQL server
in RPM for Linux and when i've installed it i found
that some tools such as mysqladmin are mising...Any
suggestions?
Thank you,Andrey
__
Do you Yahoo!?
Yahoo! Web Hosting - establish
Hi,
I've got a problem:
I'm using Berkeley DB tables in my database, but mysql fails to restart
after dropping such database. Mysql claims that it can't restore some of
database tables on start and fails to do it, because tables' files do not
physically exists after database dropping...
I can r
Recovery after crash mechanism in mySql?
IO> Thanks, Inbal
http://www.mysql.com/doc/en/Disaster_Prevention.html
--
Best regards,
Andreymailto:[EMAIL PROTECTED]
-
Before posting, ple
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Nothing about logs in startup options but logs created
>Description:
It's nothing in /etc/init.d/mysql.server and my.cnf files about logs.
But if i start mysqld
with '/etc/init.d/mysql.server start' or standala
l3.pid
Saturday, January 11, 2003, 2:16:29 AM, you wrote:
PD> At 23:45 +0300 1/10/03, Andrey V. Ignatov wrote:
>>It's *nothing* about query logging in configuration files!
PD> Okay, that's strange. Next step:
PD> - What's the name of the log file that the server is
ut=20
--set-variable=innodb_thread_concurrency=6
Friday, January 10, 2003, 10:25:00 PM, you wrote:
PD> At 18:59 +0300 1/10/03, Andrey V. Ignatov wrote:
>>Hi, all!
>>
>>I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about
>>logging in mysql.server sta
Hi, all!
I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about
logging in mysql.server startup script and in my.cnf, but mysqld
create log file and write a lot of queries to it. How i can disable
this?
My configure options:
./configure --without-berkley-db
--with-named-curses-libs=
äÏÂÒÙÊ ÄÅÎØ.
> On Thu, Nov 14, 2002 at 02:44:47PM +0200, Andrey Kotrekhov wrote:
> > Hi, All! sql
> >
> > Can I run 2 mysqld that use the same DB?
> > Not replication , 1 DB on my HDD but 2 mysqld work with this DB.
> >
> > For example I have external RAID a
regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +380 562 34-00-44
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
>Description:
If a thread grabs a lock on a table, the
__unlocked__ tables don't show properly in "show table status". In particular,
almost all fields (except for table name) are returned as NULL.
>How-To-Repeat:
show table status from mysql;
lock tables my
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Andrey Hristov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 23, 2002 6:23 PM
Subject: Re: Problem with select.
>
>
> Andrey Hristov wrote:
>
gards
Andrey Hristov
-
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 <[EMAIL PROTECTED]>
To unsubscr
> AK> And after close connection table will destroy.
> AK> What is the reason to replicate it?
>
> Andrey, you can use temporary tables in INSERT ... SELECT statement, in
> multi-table deletes etc.
Thank you. I understand.
Best regards.
___
äÏÂÒÙÊ ÄÅÎØ.
sql
> Andrey,
> Tuesday, October 01, 2002, 11:53:41 AM, you wrote:
>
> AK> Why is temporary tables replecated?
> AK> Is it true?
>
> Yes, temporary table are replicated properly since 3.23.29:
> http://www.mysql.com/doc/en/Replication_Features.h
sql,query
Hello, All!
Why is temporary tables replecated?
Is it true?
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +380 562 34-00-44
.
So:
Select * from user_table as tb1 left join user_table as tb2 on (tb2.referer
= tb1.id) left join user_table as tb3 on (tb3.referer = tb2.user_id)
and so on.
AFAIK the you can join up to 32 tables in a join.
Andrey
-
Before
Hi,
No, it does not support stored procedures.
Best regards
Andrey Hristov
- Original Message -
From: "Kepa Zalbide" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 10:56 PM
Subject: MySQL : Store Procedure
>
>
> Good morni
Hello.
In mysql tables Db, User, Host I can use templates as host ,for example.
But can I use templates in tables_priv as table name?
For example I want to set INSERT permission to H_% tables.
How can I set it?
Best regards.
___
Andrey Kotrekhov
me in thread programs.
> Regards,
> Monty
>
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +380 562 34-00-44
-
Before posting,
äÏÂÒÙÊ ÄÅÎØ.
> Andrey> Are mysql know about this!!!
>
> Sorry but if your OS doesn't support gethostbyname_r(), then
> mysql_real_connect() is not thread safe (I have just updated our
> documentation about this)
Thank you.
>
> Another issue is that if your client
gt; > $1 = (char **) 0x0
> > (gdb) p state->func
> > Cannot access memory at address 0x8.
> > (gdb)
> >
> >
> > Best regards.
> > ___
> > Andrey Kotrekhov [EMAIL PROTECTED]
> > ISP Alkar Teleport
> > ÔÅ
äÏÂÒÙÊ ÄÅÎØ.
> Andrey Kotrekhov writes:
> > Hi!
> >
> > %> g++ -v
> > Using builtin specs.
> > gcc version 2.95.3 20010315 (release) [FreeBSD]
> > And libstdc++ is include in compiller
> > How can I see version of libstdc++ ?
> > In /u
Hi!
> Andrey Kotrekhov writes:
> >
> >
> > my program crash in another plase
> > (gdb) bt
> > #0 _db_enter_ (_func_=0x280fe4dc "mysql_ping",
> > _file_=0x280fdd48 "libmysql.c", _line_=2248, _sfunc_=0xbfa87d3c,
> > _sfile_=
1 and let us know the values for the
> following parameters :
>
> const char *dir, const char *config_file, const char *ext, TYPELIB *group)
>
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +
äÏÂÒÙÊ ÄÅÎØ.
> Andrey Kotrekhov writes:
> > Hello, All!
> >
> > I have program which try to connect to different mysql servers twice at
> > the same time.
> > When I use libmysqlclient.so sometimes one or two mysql connection freeze
> > in mysql_rea
t; Permanent e-mail address : [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> - Original Message -
> From: Andrey Kotrekhov <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, April 21, 2002 4:55 PM
> Subject: problem with
client_flag
$7 = 0
(gdb)
OS FreeBSD 4.4-RC
mysql version 3.23.42, but I try to use 3.23.49 with the same effect
Will anybody help me?
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +380 562 34-00-44
--
gt; [mysqld]
> set-variable = table_cache=512
>
>
> --
> Dan Nelson
> [EMAIL PROTECTED]
>
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +380 562 34-00-44
sql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
Best regards.
_
DB for speed up query speed.
Many thanks!
Andrey.
-
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 &
stuck.
Andrey.
-
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 <[EMAIL PROTECTED]>
To unsubscribe,
ysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
Best regards.
___
Please, help. How connect to other PC with TCP/IP? (i.e. I have mysql-server
on some PC and want connect(and access to Data Bases) with him as
mysql-client).
-
Before posting, please check:
http://www.mysql.com/manual.php (
I install mysql (v 3.23.39) on Windows 2000 pro, but server is not run:(
Plese, help me... What I must to make?
ó Õ×ÁÖÅÎÉÅÍ, áÎÄÒÅÊ.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
Hi,
How to create query to get data from tables of two different databases ?
Best regards, Andrey
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
1 - 100 of 113 matches
Mail list logo
