Re: Mysql monitering and performance tool

resource fails. > > Regards > Baron > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Cheers, Maxim Veksler "Free as in Freedom" - Do u GNU ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to limit MySQL child processes?

many client connections at the same time. It is possible to limit their count? I try to set this options in my.cnf but without result: max_connections = 1 max_user_connections = 1 max_delayed_threads = 1 Thanks. -- Maxim Nechaev -- MySQL General Mailing List For list archives:

Trouble configuring mysql-nt as a service with --skip-.* switches

C:\mysql\bin>mysqld-nt.exe --skip-bdb --skip-isam --install MySQL --defaults-file=%windir%\my.ini 050821 12:50:39 mysqld-nt.exe: unknown option '--isam' What am I doing wrong ? -- Cheers, Maxim Vexler (hq4ever). Do u GNU ? -- MySQL General Mailing List For list archives: http:/

Can I use the information from "SHOW STATUS" in a SELECT statment ?

Hello to everyone on [EMAIL PROTECTED], In 2 words, what I wish to do is something like : mysql> SELECT @@Qcache_queries_in_cache / @@Qcache_hits; Is it possible ? Thank you. -- Cheers, Maxim Vexler (hq4ever). Do u GNU ? -- MySQL General Mailing List For list archives: h

A little help with mysql's "Query Cache" configuration

--+-+ | Variable_name | Value | +---+-+ | query_cache_limit | 5242880 | | query_cache_size | 3145728 | | query_cache_type | ON | +---+-+ 3 rows in set (0.00 sec) Thank you. -- Cheers, Maxim Vexler (hq4ever).

Implication and usage of character sets for i18n data (?)

s it comes into effect for me, as an application developer relaying on mysql (or similar database software) for the storage of my data? Thank you very much, Maxim Vexler. -- Cheers, Maxim Vexler (hq4ever). Do u GNU ?

- HELP Foreign key constraints

re id = "1"; There is a mistake: Error: Cannot delete a parent row: a foreign key constraint: fails. Probably it is connected with blocking? I do not understand. How to remove a line from parent table so that the line child table has in cascade left connected on a key parent_id? --

- Foreign key constraints

re id = "1"; There is a mistake: Error: Cannot delete a parent row: a foreign key constraint: fails. Probably it is connected with blocking? I do not understand. How to remove a line from parent table so that the line child table has in cascade left connected on a key parent_id? --

Re: Problem in configuring InnoDB tables. Help !

innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 -- Best regards, maximmailto:[EMAIL PROTECTED] -

HELP the poor programmer!

). Where to find the theory of construction master/slave, monitoring systems... HELP the poor programmer! I unique at university who am engaged MySQL at such level... The problem that simply is not present at whom to ask. Beforehand thank -- Best regards, maxim

HELP the poor programmer!

). Where to find the theory of construction master/slave, monitoring systems... HELP the poor programmer! I unique at university who am engaged MySQL at such level... The problem that simply is not present at whom to ask. Beforehand thank -- Best regards, maxim

Systems of a high degree of availability

on the given subject It is beforehand grateful. Maxim - 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

Systems of a high degree of availability

Hi, all -- Best regards, maxim mailto:[EMAIL PROTECTED] Hi, all Links to the information are necessary. Master/slave the architecture. Implementation of the system of a high degree of availability on a basis master/slave. Implementation of a control

--- InnoDB for Win

Hi? all Can i use InnoDB tables in MySQL Max for Win9x ? Thanks... -- Best regards, maxim mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the

-- e-shop B2C B2B

would you set up a hot swap? i.e. if the primary database fails, bring up the mirrored database? This is an interesting question in general. I would be grateful for any information or links. -- Best regards, maxim mailto:[EMAIL PROTECTED

-- OpenSSL and MySSL ... Is it real?

Hello All In MySQL 4.x MySQL Reference Manual for version 3.23.49 in 1.1.6 The Main Features of MySQL there is a support OpenSSL. Who used that this opportunity in MySQL + php? What impressions? Difficulties? Features? -- Best regards, maxim mailto:[EMAIL

-- e-shop

connection The mirror-database when basic-databases will be broken. I shall be glad to any information, links on increase of reliability of systems of such type. Beforehand thank. -- Best regards, maxim mailto:[EMAIL PROTECTED

-- e-shop

connection The mirror-database when basic-databases will be broken. I shall be glad to any information, links on increase of reliability of systems of such type. Beforehand thank. -- Best regards, maxim mailto:[EMAIL PROTECTED

-- e-shop

Hello All, I am sorry for Russian. I shall mean. The question remains open. How to reach(achieve) a high degree of reliability of system the Internet of commerce on a basis MySQL. At the expense of that it is possible to raise(increase) reliability of system? -- Best regards, maxim

Re[2]: --- MySQL

Hello Victoria, Wednesday, April 10, 2002, 3:07:01 PM, you wrote: VR> Hello maxim, VR> Wednesday, April 10, 2002, 2:14:54 PM, you wrote: m>> ñ ÐÉÛÕ ÄÉÐÌÏÍ, É-ÎÅÔ ÍÁÇÁÚÉÎ MySQL+php+Apache .. m>> ÷ÏÐÒÏÓ: ÇÄÅ ÍÏÖÎÏ ÎÁÊÔÉ ÐÏÄÒÏÂÎÕÀ ÄÏËÕÍÅÎÔÁÃÉÀ Ï ÏÓÏÂÅÎÎÏÓÔÑÈ m>>

Re[2]: -- e-shop

Hello sean, Wednesday, April 10, 2002, 2:37:34 PM, you wrote: sosi> Hi maxim, sosi> I'm not sure what you mean, given your earlier posts you seem sosi> to be talking about transactions in mysql. if thats the case sosi> i recommend you take a look at innodb. its a table typ

-- e-shop

Hi all! Problem. How to ensure(supply) reservation MySQL in a context of creation the Internet shop to raise(increase) his(its) reliability. -- Best regards, maxim mailto:[EMAIL PROTECTED

Re[2]: --Transactions

Hello Dicky, Wednesday, April 10, 2002, 1:42:00 PM, you wrote: DWP> On Wed, 10 Apr 2002 13:27:30 +0300 DWP> maxim <[EMAIL PROTECTED]> wrote: >> Hello , >> >> >> >> i've just started work with MySQL. Does anybody know how can i >> use

--Transactions

Hello , i've just started work with MySQL. Does anybody know how can i use transaction with MySQL? Is this capability supported? I write web-shop... Sory my eng is bed... -- Best regards, maxim mailto:[EMAIL PROT

- Error 127

Hello mysql, Hello What is .. the "Got error 127 from table handwler" Pl send me error table ... My english is very bad sory -- Best regards, maxim mailto:[EMAIL

Re[4]: client dependent timezone

ch 29, 2002, 1:16:03 PM, you wrote: DN> Hello Maxim, DN> There's a bit of confusion in this discussion: Do you (a) want to have DN> several databases running on the db-server, and all set to different DN> time zones, or (b) want each client to see db-stored times stated in DN>

Re[2]: client dependent timezone

set it to your local timezone so it GRJ> does not return values in GMT. GRJ> If you want clients to have different timezones, perhaps you should write GRJ> that capabilty into your front-end application. GRJ> Gerald Jensen GRJ> - Original Message ----- GRJ> From: "Maxim

Re[2]: client dependent timezone

set it to your local timezone so it GRJ> does not return values in GMT. GRJ> If you want clients to have different timezones, perhaps you should write GRJ> that capabilty into your front-end application. GRJ> Gerald Jensen GRJ> - Original Message ----- GRJ> From: "Maxim

client dependent timezone

Hello mysql, So nobody here (even at MySQL AB) knows how to set a timezone for a MySQL client ? Not for whole server but per client? (or maybe for database???) I already posted this question here few days ago - and didn't get any reply. Please! Somebody help! -- Best regards,

temporary tables select

table already exists ! Somebody help please ! -- Best regards, Maxim mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

Re: PHP, BLOB file, MySql and my web site

(the list archive) OT> To request this thread, e-mail <[EMAIL PROTECTED]> OT> To unsubscribe, e-mail <[EMAIL PROTECTED]> OT> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Best r

MySQL client timezone

Hello 'mysql, Does anybody know is this possible to set some particular timezone for the session? ie: server is in GMT, but application needs time selected in GMT+3 Is there any universal way ? Thanx for any hint in advance -- Best regards, Maxim mailto:[

Bad file descriptor

Sometimes I have in my .err file Error in accept: Bad file descriptor FreeBSD 4.4, mysql 3.23.47 startup script: -O key_buffer=256M -O table_cache=18000 -O sort_buffer=32M -O record_buffer=16M --log-slow-queries -O long_query_time=180 -O max_connect_errors=50 -O back_log=500 --warnings -O max_

Crashes

The MySQL server keeps crashing together with half the tables (MySQL-3.23.38). The server is tight-loaded, but not enough for a possible lack of resources. It all acts on a Dell server, Linux-2.2.18. Sincerely yours Maxim A Belushkin System Administrator Hosting Unit RUNET.COM

Writing MySQL's log back into log database

Hello, Normally, MySQL maintains a flat log file to write all queries passed to it. Is it possible (any module or whatever) to get it to put this log into a specific database, in order to be processed more efficiently? Thanks for the reply. Maxim Pavlov [EMAIL PROTECTED

Problem with OBDC

is there anyone who can help me with my problem i posted a earlier? i know i shouldn't post this kind of requests, but i REALLY need help. i am on a deadline and having major problems exporting tables from access 2000 to mysql. please help

Compilation error on HP-UX 11.00 with mysql-3.23.37

INI_UNBUFFERED_IO, OPT_SKIP_SAFEMALLOC }; static struct option long_options[] = { Regards, Maxim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: [PHP] Time needed for a SQL-statement

tats. Catch the time it gives you and vuale... not sure though, it might be useless if the time taken to do that is equivalent as to select pulling the results out. (think it is) Sincerely, Maxim Maletsky Founder, Chief Developer PHPBeginner.com (Where PHP Begins) [EMAIL PROTECTED]

SQL : multiple SELECT and missing rows.

no such address.ID as stated in my WHERE clause. Can anyone suggest me how do I SELECT ALL of the accounts having simply NULL on 'addresses.*' when there's no such row, instead of 'loosing' the whole 'account' row? I sure know how to do it using two quer

limiting, sql question

.xx ? Can one field be LIMITed and another not? I would like it to minimize the amount of data sent. (in the soft. this query will repeat itself quite a bit of times) P.S: sorry if the question is too stupid, but my 'SQL skills' are far not perfect. Thanks in advance, Maxi

RE: summarizing rows. an sql question

yup, thanks, this is what I was looking for! (just didn't know it) Cheers, Maxim Maletsky -Original Message- From: Thalis A. Kalfigopoulos [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 1:25 PM To: Maxim Maletsky Cc: [EMAIL PROTECTED] Subject: Re: summarizing row

summarizing rows. an sql question

r 00011 which is the summary of count in all rows) I, of course, can do it with PHP or whatever, but isn't there a feature in SQL that does that? Thanks in advance, Maxim Maletsky - Before posting, please check: http://www.my

Create DB's in different directories.Please!How?

se help me. With my reguards. Maxim M. Polyakov.

RE: will this work? [phpMyAdmin]

While downloading phpMyAdmin you can choose whether to use .php or .php3 extensions ... And if you don't want to then Just add .php3 to AddType in apache or through .htaccesss Cheers, Maxim Maletsky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]