Could you please explain Linear Hashing Partitioning in MySQL
thanks,
DT
www.ejinz.com
Search Engine News
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to PHP + MySQL now visit
the following page:
http://dbconvert.com/order.php
Your feedback is highly appreciated.
Best regards,
Best regards,
Dmitry Narizhnykh,
http://www.dbconvert.com
Smart database conversion / synchronization tools
--
MySQL General Mailing List
For list archives: http
Hello All.
I need your help with Mysql.
I'am using version 5.1.22 compiled with libthread and MyISAM engine on
FreeBSD 6.2-STABLE and some times getting lock (deadlock?) on parallel
update queries from some hosts.
Very long time the query is keep state "Updating" and no disk, cpu and
other activit
DBConvert.com announces DBForms from MS Access to PHP + MySQL v.2.1.1
release.
Our application allows you to convert mdb (Microsoft Access databases) and
MS Access forms to AJAX based WEB page using PHP and MySQL. DBForms for MS
Access to PHP + MySQL supports elements in MS Access forms such a
Is that possible to count summ of numbers in field?
If field has value 12, 3 must be returned. (1 + 2 = 3)
--
Проник в школу через задний проход.
WBR, Дмитрий Лукашин
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Suppose some user issued 'select ... for update', then
went for coffee-break (to think hard on what he
really wants to update in that row). Another client
tries to update the same row and I don't want him to
wait, just immediately return an error, so he could
do some other useful task meanwhile. I
the both fields got the current date and time value.
I changed the name of field "date" to another and got the same result.
I got the same behavior in many mysql versions include 4.0.12.
Regards,
Dmitry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
or in many mysql versions include 4.0.12.
Regards,
Dmitry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Is there any possibility to check existing of autoextend option
for InnoDB ?
I mean by any sql command and not by searching in my.ini file ?
Regards,
Dmitry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
.
Thanks already,
Dmitry Kuznetsov
|Dmitry A. Kuznetsov, PhD |
|Office of Information Technology |
|Ludwig Institute for Cancer Research |
|WWW: http://www.licr.org/ |
|Ch. Des Boveresses 155 |
|CH-1066 EPALINGES
in some_table.
These are the column definitions in some_table (InnoDB):
CurrID char(42) NOT NULL,
OriginalID char(42) NOT NULL ,
DocRevision int(16) unsigned NOT NULL
.
.
.
I check this in 3.51 and 3.53 and got the same results.
Regards,
Dmitry
This email and any files transmitted with
Hi,
I checked it with 3.23.54 on Windows
and got the same incorrect results.
Regards,
Dmitry
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 11:30 PM
To: [EMAIL PROTECTED]
Subject: Re: Group by problem
Dmitry,
- Original
ceive
response, since it (or end part of it) is in the BufferedInputStream buffer.
I might be wrong, but I usually see the same stack trace. I need to restart
my application.
Best,
Dmitry.
-
Before posting, please check:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 10:55 AM
To: Dmitry Kosoy
Subject: Re: compression protocol
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the
Hi all.
Check out http://mysqlxpcom.mozdev.org/
Quick intro:
Allows to write MySQL interfaces in pure JavaScript, XUL or HTML.
Multiplatform.
Usable right now.
Enjoy and Happy Xmas !
--
Deem0N** [EMAIL PROTECTED] **
Natural born YASPer http://www.yasp.com/
Just Anoth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 6:46 PM
To: Dmitry Kosoy
Subject: Re: Innodb: Create different db on separate disks
Your message cannot be posted because it appears to be either spam or
simply off topic to our
Hi,
It is good for MyISAM tables.
For Innodb it puts on separate disk frm files only.
And what about Innodb tables of the specific database?
Regards,
Dmitry
> Is there any way to put different db on separate disks ?
You can move database directory to another disk and create a symlink. M
lse
echo "mysql-server isn't running"
fi
;;
*)
echo ""
echo "Usage: `basename $0` { start | stop }"
echo ""
exit 64
4 /usr/local/libexec/mysqld --basedir=/usr/local
--datadir=/var/db/mysql --user=mysql --pid-file=/var/db/mysql/bingo.pid
there is no log-bin parameter. why my server write binary logs?
i compiled the mysql-server from ports...
--
Dmitry Sukhodoev, network administrator of bingo.ru, icq#550315
Friday, February 15, 2002, 2:23:52 AM, Lars Heidieker wrote:
> Just copy the backup files into the database dir and the database should be
> back.
Are you sure that it's not need to CREATE it first ?
> At 08:22 AM 2/15/2002 -0500, Paul wrote:
>>Hello mysql,
>>
>> I dropped an entire database
est;
??? I get only 34465 byte.
I use mysql 3.23.33, 4.0.0-alpha on FreeBSD 4.3, 4.4.
If I use text instead mediumtext Select2 work correctly. But I use string >65 Kb.
If I use longtext, longblob or mediumblob problem repeat.
Can I use long string with SET CHARACTER SET cp1251_k
Hello
Is it possible to set up one mysql server *only* for listening on socket and
transfer client requests to another one server through network connection ?
Of course I mean return results too :-)
--
Dimitry
-
Before posti
Philip Mak wrote:
> On Thu, May 30, 2002 at 05:53:03PM +0300, Dmitry Alyabyev wrote:
>> Is it possible to set up one mysql server *only* for listening on
>> socket and transfer client requests to another one server through
>> network connection ? Of course I mean return re
.
My experience with tables, being hardlinked to the different directories (i.e.
databases), is bad, as these tables soon become corrupted. However, I did not
experiment with softlinks (ln -s).
Any ideas?
Thanks already,
Dmitry.
|Dmitry A. Kuznetsov, PhD |
|Office of
Hi all,
I am trying to compile mysql-3.23.49 on OpenBSD 3.1-stable
with pth lib. Note: since OpenBSD 3.1 mysql is compiling
with native OpenBSD threads. And I found it is very unstable.
I meant ports collection.
I am running mysql with pth lib on OpenBSd 2.9 without problems.
Once I get mysql c
2. to make such a table visible for DBA tools, which cannot jump from one DB to
another.
Best,
Dmitry
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Dmitry Kuznetsov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, Aug
re regular tables.
Although, one may have one master table (with master contents), and empty tables
with the same structure in other DBs. Such an empty table might be merged over
the master table. Yes.
Thanks for the hint!
Dmitry.
- Original Message -
From: "Sergei Golubchik" &l
prefix is the only
choice...
Thanks again, Dmitry.
- Original Message -
From: "Tod Harter" <[EMAIL PROTECTED]>
To: "Sergei Golubchik" <[EMAIL PROTECTED]>; "Dmitry Kuznetsov"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesda
Robert Macwange wrote:
> Hello y'all,
>
> I guess this is easy, but it is defeating me.
> I am having a problem with this query:
>
> $keyword = "search";
> SELECT * FROM table WHERE field LIKE '%$keyword%'
Hint, for 'search' in middle of phrase:
SELECT * FROM table WHERE field LIKE '% $keywo
iated,
Dmitry
-
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, e-m
How can I erase all data except for the fields in mysql table? I just want
to fill all data again in the same table.
Dmitry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
ure C:\MYSQL is not encrypted (this is only one possible reason for
this problem from many but it is still fresh in my memory as I had this
problem just yesterday).
Dmitry
-
Before posting, please check:
http://www.mysql.com/
Hello
Time to time I see strange overload of MySQL on dedicated server. The server is
powerful enough to handle ~ 500 req/s. MySQL version is 3.23.40
and runs on Linux 2.4.16-SMP. The overload which I mean leds to stop
answering to queries and looks like:
6:24pm up 6 days, 2:34, 2 users, l
Saturday, January 19, 2002, 9:21:04 AM, Jeremy Zawodny wrote:
> On Fri, Jan 18, 2002 at 10:38:43AM +0200, Dmitry Alyabyev wrote:
>> Hello
>>
>> Time to time I see strange overload of MySQL on dedicated
>> server. The server is powerful enough to handle ~ 500 req/s.
Tuesday, January 29, 2002, 1:57:21 AM, David Piasecki wrote:
> I have a server here that is troubling me -
> I have a database server that is lagging no matter what I do. When I
> start the server, I can watch CPU usage slowly creep up to 99% and it
> never drops. The queries that are hitting t
What would I do if there are InnoDB tables ?
--
Dimitry
Wednesday, January 30, 2002, 9:31:09 PM, Paul DuBois wrote:
> At 11:10 -0800 1/30/02, JC wrote:
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>I'm kind of interested to find if there is a way to rename a database
>>with something
Hi!
I use mysql on amateurish level mainly for personal needs and so please
forgive me if this feature request is impossible to fulfil or if it is
sent to the wrong mail-list, or if this functionality has been already
realized in other ways :)
Note: I've read the discription of C-function mysql_i
te this record
5. see the "??" instead of russian letters
--- regards, Dmitry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archi
Good day,
could you help me to solve this problem?
MySQL server segmentation faults when remote mysql client
tries to connect on source and binary distributions. Local
client connect does not cause any problems whatsoever.
-
Bef
39 matches
Mail list logo
