Hello!
Hereis my mysqldump command line
mysqldump -u root --events --complete-insert --skip-opt
--single-transaction --add-drop-table --add-locks --create-options
--disable-keys --
extended-insert --quick --set-charset --routines --triggers --hex-blob
DB_NAME
But i see tons of Waiting for
09.12.2015 19:35, shawn l.green пишет:
INSERT operations are special as you can enable a mode to allow
INSERTs to happen only at the end of the file and not be blocked while
one of the other two operations are in progress.
Cannot find anything about that. Can you be a little more specific
09.12.2015 19:35, shawn l.green пишет:
On 12/9/2015 9:59 AM, Artem Kuchin wrote:
Hello!
|THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE
TABLE_SCHEMATABLE_NAME
268871 MDL_INTENTION_EXCLUSIVE MDL_EXPLICITGlobal read lock
270022 MDL_INTENTION_EXCLUSIVE MDL_STATEMENT Global
Hello!
I am actually using MariaDB, but they do not seem to have any public
discussion system
and i suppose that engine is the same basically, so, problems are
probably the same.
Today i setup the server to show locks and notice this:
|THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TY
Hello!
I cannot figure out the fastest way to do a select on the floowing field:
f_spectinyint not null;
It is a table of 100 000 records of products and f_spec is set only for
about 200 products.
I figure it could be done in two ways:
1) create an index on f_spec and do simple
select *
. As far as i can remember it was not like this before. I
am running
5.1.3
--
Artem Kuchin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
y popular in mysql list!
--
Artem
-----Original Message-
From: Artem Kuchin [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 27, 2007 1:19 PM
To: mysql@lists.mysql.com
Subject: Indexing one byte flags - what implementattion is better
Maybe someone could provide a good resonable
input on th
Maybe someone could provide a good resonable
input on this issue.
Let's say i have a table products
CASE 1:
table: products
id int unsigned not null,
name char(128) not null,
f_new tinyint not null
id - is basically the id of a product
name - is the name of a product
f_new - is a one byte fla
n table it gets stuck because user group quota is
exceeded.
--
Artem
This would be the same as the last e-mailed proposed solution, but
with two extra steps to copy back and forth from the temp directory.
-RG
- Original Message -----
From: "Artem Kuchin" <[EMAIL PROTECTED
until the soft_limit
is satisfied.
This is a great way to control temp space, and not let users abuse
it, but still give them a lot of space to perform things like large
mysql database recoveries.
-RG
Artem Kuchin wrote:
I am asking this question as a hosting PROVIDER, not
as a hosting client.
Th
Baron Schwartz wrote:
Regards,
Baron
Yes it is. Even worse, people love to convert a top-posted thread to
bottom-posted and verse vice-a!
I see topposting i popular in this mail list :)
And now for the bottom-posting part of this reply...
Any idea on how to limit connection per user? (so
it
is satisfied.
This is a great way to control temp space, and not let users abuse
it, but still give them a lot of space to perform things like large
mysql database recoveries.
Artem Kuchin wrote:
I am asking this question as a hosting PROVIDER, not
as a hosting client.
The sitation is like this
Steven Buehler wrote:
-Original Message-
From: Artem Kuchin [mailto:[EMAIL PROTECTED]
Sent: Friday, December 07, 2007 4:35 AM
To: mysql@lists.mysql.com
Subject: How to auto repair db on hosting with quota
I am asking this question as a hosting PROVIDER, not
as a hosting client.
The
I am asking this question as a hosting PROVIDER, not
as a hosting client.
The sitation is like this (this is a simple example with small
numbers):
1) a client has 100mb quota for site and db files (set on unix group)
2) 80mb is already taken by 75MB database in ONE TABLE and 5mb of files
3) data
Kristen G. Thorson wrote:
-Original Message-
From: Artem Kuchin [mailto:[EMAIL PROTECTED]
Sent: Friday, November 02, 2007 9:23 AM
To: Baron Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: sporadic error 13 on windows
DBD::mysql::st execute failed: Can't create/write to file
'
or message is sometime in uknown dir
(like '#sql_948_0.MYD' ) and sometimes
in 'C:\Program Files\MySQL\MySQL Server 5.0\Data\
HELP!
--
Artem
Artem Kuchin wrote:
anyone any idea on this ?
On 10/31/07, Artem Kuchin <[EMAIL PROTECTED]> wrote:
I am running
Server version:
anyone any idea on this ?
On 10/31/07, Artem Kuchin <[EMAIL PROTECTED]> wrote:
I am running
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
on WIndows 2003 R2 Service Pack 2 Standard Edition
I have a database dig perl script with basically does a lot of
SELECT [somefie
#sql_152c_0.MYD' (Errcode: 13) at cleanfilestore.pl line 89, line
1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at cleanfilestore.pl
line 90, line 1.
--
Artem
On 10/31/07, Artem Kuchin <[EMAIL PROTECTED]> wrote:
I am running
Server version: 5.0.45-community-
I am running
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
on WIndows 2003 R2 Service Pack 2 Standard Edition
I have a database dig perl script with basically does a lot of
SELECT [somefield] as tt FROM table;
When i run it i get:
DBD::mysql::st execute failed: Can't crea
w broken in
this
manner.
Artem
"Artem Kuchin" <[EMAIL PROTECTED]> wrote:
MySQL: 4.1.8a
OS: FreeBSD 5.3
The problem is that BINARY LIKE '..' returns no rows no
matter what specified in '..' however BINARY field_name LIKE '..'
work, but I cannot us
MySQL: 4.1.8a
OS: FreeBSD 5.3
The problem is that BINARY LIKE '..' returns no rows no
matter what specified in '..' however BINARY field_name LIKE '..'
work, but I cannot use it because this does not use index (EXPLAINs are
bellow). According to documentation BINARY LIKE shoud work. But it
does no
21 matches
Mail list logo
