Re: How to write a multi query in mysqltest framework?

2014-07-10 Thread Sergey Petrunia
On Thu, Jul 10, 2014 at 10:33:04AM +0800, 娄帅 wrote: In the C API, we can call mysql_query(select 1; select 2); which just send the command once to the server, and server return two result sets, So i want to know if there is a command in the mysqltest framework to do the job? I want to write a

Devart news

2011-04-22 Thread Sergey Lazurenko
Hello! Could you place our news story on your site. W'll be grateful. Best Regards, Sergey Lazurenko April 19, 2011 Version Five of MySQL Administration Tool from Devart Looks and Feels Different! dbForge Studio for MySQL introduces the new standard of quality for MySQL development

[PR]

2011-02-01 Thread Sergey Lazurenko
Devart dotConnect Data Providers Bring Most Convenient Working with Large Models and Easier Generation of Autoincrement Fields! New versions of Devart dotConnect data providers come with new greatly improved model designer. It delivers the ability to create several diagrams per model and

[NEWS]

2010-12-27 Thread Sergey Lazurenko
November 29, 2010 Extended Model Design and Runtime Capabilities in LINQ to SQL Compatible ORM Solution from Devart New version of LINQ to SQL compatible ORM solution with extended functionality and advanced Model-First support and Update model from database functionality.

[NEWS]

2010-12-20 Thread Sergey Lazurenko
Hello! Our team created new comprehensive solution for data analysts. Could you place basic information about this product on your page. Best Regards, Sergey Lazurenko dbForge Data Studio for SQL Server 1.00.odt Description: application/vnd.oasis.opendocument.text -- MySQL General Mailing

[NEWS]

2010-12-15 Thread Sergey Lazurenko
Hello! Hello! I'd like to place basic information about our products. I'll be appreciate you. Best Regards, Sergey Lazurenko CodeCompare 2.50.odt Description: application/vnd.oasis.opendocument.text -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

PR

2010-12-13 Thread Sergey Lazurenko
Hello! I'll be gratefull if you'll place our news on your page. Best Regards, Sergey Lazurenko dotConnects 6.00.odt Description: application/vnd.oasis.opendocument.text -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: different type column and keys for EXPLAIN

2009-12-14 Thread Sergey Petrunya
Sergey -- Sergey Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: self-joins in hierarchical queries: optimization problem

2009-10-29 Thread Sergey Petrunya
opportinites. BR Sergey -- Sergey Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: self-joins in hierarchical queries: optimization problem

2009-10-29 Thread Sergey Petrunya
On Thu, Oct 29, 2009 at 07:53:25PM +0300, Sergey Petrunya wrote: ... taxonomic_units1 AS O1 LEFT OUTER JOIN taxonomic_units1 AS O2 ON O1.tsn = O2.parent_tsn current optimizer has only one option(*): use Nested-Loops Join algorthm, with the outer table being the first one

MySQL improvement offer. Sand-box

2007-05-31 Thread Sergey Ivanov
- no directories, for example. May be this function is already realized or it has any principal troubles with realization, but I hope to recieve answer, whether this idea can be realized or not and can offer all needed cooperation. Sergey Ivanov -- MySQL General Mailing List For list archives

struct ST_SCHEMA_TABLE

2005-11-02 Thread Sergey Glukhov
Hi! Hello I would like to ask about struct ST_SCHEMA_TABLE found in sql\tables.h (version mysql-5.0.13-rc. If I am correct this struct didn't exist in early 5.0 versions). ST_SCHEMA_TABLE introduced in 5.0.3. This struct holds the information about information_schema(I_S) tables(see

Re: ORDER by Question

2005-06-27 Thread Sergey Spivak
,'The ',''); ++ | name | ++ | | | The | | | | Xylophone | | The Yeti | --- must be earlier :) | Zyxel | | The | ++ 7 rows in set (0.00 sec) -- wbr, sergey v. spivak sergey

Re: Unable to install mysql

2005-06-26 Thread Sergey Spivak
and any user (for example, yannick) from localhost with no privilegies (only test database). so just login (after install) in mysql using root account with no password - can't you? -- wbr, sergey v. spivak mysql #spivak.kiev.ua zlob-uanic/eunic/ripe -- MySQL General Mailing List For list

disk quotas in mysql

2005-04-13 Thread Sergey Averyanov
Hello Is there any built-in way to set some kind of disk qoutas in mysql (database quotas, quotas per user, etc )? -- Best regards, Sergey Averyanov mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Random 1036 Table XXX is read-only

2005-02-09 Thread Sergey
After upgrading mysql server from 4.1.3beta to 4.1.9 (FreeBSD 4.8, mysql is installed from ports) I sometimes have the following problem: when some perl client tries to execute INSERT or UPDATE query via DBD::mysql it from time to time (but NOT always ) gets error 1036 (Table

Re: Cannot start 4.1.3 on Debian Linux

2004-07-09 Thread Sergey S. Kostyliov
, Pitsco, Inc. +++ Opinions expressed are my own, not my employer's +++ -- Sergey S. Kostyliov [EMAIL PROTECTED] Jabber ID: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Losing some records

2004-06-18 Thread Sergey . Chistyakov

innodb_flush_file_method=O_DIRECT

2004-06-16 Thread Sergey
/solutions to use with innodb_flush_file_method=O_DIRECT? PS: Sorry for my poor english... --- Sergey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL not finidng openssl/opensslv.h

2004-06-09 Thread Sergey Glukhov
Hi! How did you install OpenSSL? From source or packages (e.g. debian or rpm). In that case you also have to install the dev-Package of OpenSSL (openssl-dev) Sincerly, Oliver I was able to repeat this situation. It happens only when OpenSSL is installed to non-standart directory and no OpenSSL

Re: [Help-gnu-radius] mysql/radius populate db question

2003-11-28 Thread Sergey Poznyakoff
to use the account you had created for populating the database, which failed because *that account* did not have sufficient permissions to do so. In both cases, what happened seems to fit well the MySQL security framework. Regards, Sergey -- MySQL General Mailing List For list archives: http

How to link mysql to specific zlib library

2003-11-25 Thread Sergey Karpushkin
Hello gentelmen, can anybody guide or point me how to compile mysql (4.0) with specific zlib library? I've precompiled zlib which came with OS (FreeBSD 4.5) in /usr/lib: libz.a libz.so libz.so.1 libz.so.1.1.3 libz.so.2 and have installed myself libz 1.1.4 to /opt/zlib (with usual structure

MySQL/InnoDB-4.0.16 +Optimizer behaviour

2003-10-29 Thread Sergey S. Kostyliov
, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: 2.6.0-testX and InnoDB (was: Re: 2.6.0-test2-mm3 and mysql)

2003-08-28 Thread Sergey S. Kostyliov
20:15 From: Sergey S. Kostyliov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hello all, On Wednesday 27 August 2003 19:52, Sergey S. Kostyliov wrote: On Monday 04 August 2003 04:05, Matt Mackall wrote: cut All Linux kernels prior to 2.6.0-test2-mm3-1 would silently fail to complete fsync

Re: mysqld hangs when accessed from external interface / servers

2002-10-06 Thread Sergey S. Kostyliov
vulnerabilities in resolver http://rhn.redhat.com/errata/RHSA-2002-197.html) RedHat vesrions 7.{1,2,3}. AFAICS both mysql branches affected (tested on 3.23.52 and 4.0.4 with gcc 2.95.3/3.2/2.96-rh. -- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED

Re: mysqld hangs when accessed from external interface / servers

2002-10-06 Thread Sergey S. Kostyliov
/en/os/i386/glibc-devel-2.2.5-39.i386.rpm rpm -Uvh --force glibc*-39*.rpm -- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc

Re: mysqld hangs when accessed from external interface / servers

2002-10-06 Thread Sergey S. Kostyliov
On Sunday 06 October 2002 23:05, Sergey S. Kostyliov wrote: On Sunday 06 October 2002 22:04, Stan P. van de Burgt wrote: So, a fix to this MySQL bug anyone?? I don't think this is a mysql bug. cut I'm personaly solve this problem by just glibc downgrade E. g. RedHat-7.3. wget ftp

AES_DECRYPT(garabage, key) problem (4.0.4 bk snapshot)

2002-09-12 Thread Sergey S. Kostyliov
: Unknown Submitter-Id: Originator: Sergey S. Kostyliov Organization: eHouse holding (http://www.ehouse.ru/) MySQL support: none Synopsis: Server hang with AES_DECRYPT() Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql

BUG report (CREATE TEMPORARY TABLES problem) 4.0.2/4.0.3-bk snapshot

2002-07-30 Thread Sergey S. Kostyliov
FROM mysql.tables_priv; mysqadmin relad Submitter-Id: Originator:Sergey S. Kostyliov Organization: eHouse (http://www.ehouse.ru) MySQL support: none Synopsis: 'CREATE TEMPORARY TABLE' privilege broken by any per-tables grant Severity: serious Priority: medium

Re: BUG report (select distinct...) 4.0.2 and latest bk snapshot

2002-07-24 Thread Sergey S. Kostyliov
On Wednesday 24 July 2002 17:23, Sinisa Milivojevic wrote: Sergey S. Kostyliov writes: At first I want to thank you for a fast answer, On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote: On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote: Description: ERROR

BUG report (select distinct...) 4.0.2 and latest bk snapshot

2002-07-23 Thread Sergey S. Kostyliov
: submitter ID Originator:Sergey S. Kostyliov Organization: eHouse (http://www.ehouse.ru) MySQL support: none Synopsis: SELECT DISTINCT ... failed Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.3-alpha (Source

Re: BUG report (select distinct...) 4.0.2 and latest bk snapshot

2002-07-23 Thread Sergey S. Kostyliov
At first I want to thank you for a fast answer, On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote: On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote: Description: ERROR 2013: Lost connection to MySQL server during query. snip Note: The same results with oficial

Problem with load data infile and user's privileges

2002-06-15 Thread Sergey Bondar
am doing? Why whith my client's privileges I can create databases, tables but can't load any data in to the tables? Thank you. Sergey. _ Cool Quiz - Websites That Keep You Guessing! http://www.coolquiz.com

Problem with load data infile and user's privileges

2002-06-14 Thread Sergey
am doing? Why whith my client's privileges I can create databases, tables but can't load any data in to the tables? Thank you. Sergey. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: processlist

2002-06-04 Thread Sergey S. Kostyliov
-- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc - Before posting, please check: http

Number of mysqld

2002-01-06 Thread Sergey Potapov
, Is it possible to reduce number of mysqld? I could not find information about this in the manual. Thanks, Sergey Potapov - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

INNER JOIN doesn't work correctly..

2001-11-28 Thread Sergey S. Kostyliov
Description: Query with INNER JOIN return 0 rows, but the same query + yet another WHERE condition return 1 row How-To-Repeat: Query: SELECT orders_common.vendor_id FROM orders_common INNER JOIN orders_common_count ON

Re: INNER JOIN doesn't work correctly..

2001-11-28 Thread Sergey S. Kostyliov
, Sergey S. Kostyliov [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-mail [EMAIL

I uploaded a bug report innerjoin.tar [was: INNER JOIN doesn't work correctly..]

2001-11-28 Thread Sergey S. Kostyliov
regards, Sergey S. Kostyliov [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-mail

RE: mysql can't start

2001-03-07 Thread Sergey Yegorov
it function isn't present and with this kernel mysql work correctly. Why mysql stopped to work on kernel 2.2.14 after 6 month, I can't understand. -Original Message- From: Sergey Yegorov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 10:10 AM To: [EMAIL PROTECTED

mysql can't start

2001-03-05 Thread Sergey Yegorov
(sorry for my english, I am from Russia) I have a problem this MySQL on my linux (2.2.14) server. In some pretty day after reboot MySQL-server (3.22.25) stopped to answer on any exposure. I tried to do something and after all remove it completely and install again - nothing happens. I install