Hi!
On Feb 14, Mariella Petrini wrote:
> Hi All,
>
> Is there any plan to release a binary version for
> mysql-5.1.23-maria-alpha for Linux 64 for AMD ?
Yes.
Regards / Mit vielen GrĂ¼ssen,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[
-allocated to the buffer pool size?
No, I don't. Sorry :(
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Kerpen, Germany
in most 32-bit computers the process
> InnoDB: memory space is limited to 2 GB or 4 GB.
>
> How can I make the size of LOBs I insert NOT be memory constrained?
No way.
Unfortunately, it's the way MySQL works at the moment.
Which does not mean it's not going to be changed i
how we could repeat this bug.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mail
>
> just looking for tips/suggestions to tweak the results it returns and
> anything else i should know.
>
> lastly... this might be more related to php, if anyone knows of a
> reliable function/class to highlight search terms, please let me know.
>
Regards,
Sergei
--
al bugs in name resolution
for INSERT ... SELECT ... ON DUPLICATE KEY UPDATE reported recently,
I believe yours is one of those.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/
> InnoDB tables, only on MyISAM tables. Is this correct?
Yes.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL
Hi!
On Apr 11, Christian Hammers wrote:
> Hello Sergei
>
> On Thu, Apr 07, 2005 at 03:14:10PM +0200, Sergei Golubchik wrote:
> > > I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a
> > > using precomiled Debian packages on Debian Woody al
ne?
In the unix source distribution (any recent one).
Probably it'll be in the 4.1.11 windows source distribution too.
> And where can I find other documentation that provides
> pointers on the subject?
Check other engines in the sql/examples directory.
Ask your questions in the
caches the result
of the query as it is sent to the client. Raw data on the wire (almost).
So it can only cache the complete query, not a part of it.
By the way, there's no need to measure query execution time, you can
do 'SHOW STATUS' and watch Qcache% variables - just like
. In particular it defines '+' for "must be
present" and a space ' ' for "optionally present" words.
You want to put the space first (for "must be present" words)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \
. It's not functioning in Mysql 4.1
You can submit a bugreport at http://bugs.mysql.com/
(but please provide a *readable* EXPLAIN output, using "mysql -t")
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <
text.
>
> As far as this is technically possible it would be helpful to give some
> extra relevance to those hits where the 'distance' between words is small.
Tnanks, good idea.
(I'll see how it could be done)
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /
qldoc
repository on mysql.bkbits.net).
Plans - yes, if the current one is bad.
But I don't know what to put instead.
Feel free to suggest a better weighting scheme :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\
gards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://li
keys. And even if you have an index over
VARCHAR(255), actual values are usually shorter, right ?)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_
ere in cache,
> this would speed up things so much !
It's fixed in 4.1.8.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
ems one can use a sequence in postgresql in different
> tables. is it possible in a similar way?
Try UUID() function
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, S
added ony a few days ago - documentation is catching up still.
For now - take a look at the mysql-test/t/federated.test file.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Seni
Hi!
On Dec 17, Sergei Golubchik wrote:
> On Dec 16, Ken Johanson wrote:
> > Hi all,
> >
> > Does anyone know fo a way to run the server in more of a string-quoting
> > standards compliant mode, so that a generic SQL string quoting function
> > only has to esca
to be able to do is have \",\\,\0 characters treated as
> any other so that statements become portable.
MySQL 5.0
NO_BACKSLASH_ESCAPES sql mode.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / //
this problem. Thanks for any help
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL Ge
to remove unrelated rows, or create a
completely independent test case. Actually you can even upload big
tables if you don't want to spend time on a test case.
But only with a repeatable test case you can make sure that the bug
won't be present in 4.1.8.
Regards,
Sergei
--
__
Hi!
On Nov 22, Santino wrote:
> At 15:23 +0100 22-11-2004, Sergei Golubchik wrote:
> >Hi!
> >
> >On Nov 22, Dilipan Sebastiampillai wrote:
> >> I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query
> >> using LEFT JOIN gives me different r
think it comes from an 'optimization' how can I make a query
> without using the LEFT JOIN optimization of MySQL 4.1.7 ?
What is the query ?
Can you provide a repeatable test case ?
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /
vileges on the
underlying tables, than nobody will be able to select from them.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/
)
Yes, it is worth to wait 35 minutes when the index will be rebuilt.
Maintaining live fulltext index is much slower.
(at least, inserting lots of rows into a table with fulltext index could
be up to 100 times slower than adding an index afterwards).
Regards,
Sergei
--
__ ___ ___ __
ther exists or gets added or dropped, which I'd also call a bug.
Sorry, I don't understand. Could you elaborate ?
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Softwa
Hi!
On Oct 06, Christopher L. Everett wrote:
> I've also found a problem with "myisamchk --sort-keys":
I recently fixed one bug in myisamchk --sort-keys where fulltext indexes
are present. Try 4.1.7 release.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __
Hi!
On Oct 21, Phil Bitis wrote:
> >From: "Sergei Golubchik" <[EMAIL PROTECTED]>
> >
> >But for auto_increment field (on BIGINT, I believe ?),
> >you'll have hundreds of keys on one key page, so logarithm base will be
> >few hundreds, and log N s
only few nodes - on the path from the root to the last leaf. Thus
these nodes/keypages will be always cached and the performance should be
somewhat better as compared to random accesses (assuming the index is
too big to fit in cache completely).
Regards,
Sergei
--
__ ___ ___ __
e light on how B-tree indexes work. Do
> they behave well when values passed in are sequential (1, 2, 3, ...)
> rather than random values?
Yes.
B-tree is always balanced: http://www.nist.gov/dads/HTML/btree.html
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Serg
se? How does this work, what's the syntax?
In the manual:
http://dev.mysql.com/doc/mysql/en/INSERT.html
> Is this ANSI-SQL standard ?
No.
> Or is it even documented?
Of course.
http://dev.mysql.com/doc/mysql/en/INSERT.html
Regards,
Sergei
--
__ ___ ___ __
/
ble aliases - or works, but
> eatch alias must be locked separately and the final queries must contain
> same aliases. Examples a and b cause both an error that tables are not
> locked. Examples c and d work well.
Right.
This is how, according to the manual, LOCK TABLES should work.
e statement did (see the url above for the
example).
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Maili
ibedit library, that is used for mysql command line client),
all gpl binaries are linked with readline and are not affected by this
problem. That's why there're no 4.1.4a binaries, only 4.1.4a source
tarball.
> Is gamme the last step
> until the 4.1.4 will be released?
Yes.
> Or will
; Please check that the
> user exists!
> 040824 17:29:49 Aborting
>
> 040824 17:29:49 ./bin/mysqld: Shutdown complete
http://bugs.mysql.com/bug.php?id=4408
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
Hi!
On Aug 22, Robert Nagy wrote:
> Stardate [040822 00:26]. Sergei Golubchik of Borg wrote:
> > Roger, it is explained my reply to the bugreport, and in my reply to
> > you.
> Thanks I can read. But the question was not that.
> >
> > http://www.mysql.com/doc/
l.com/doc/en/Installing_source_tree.html
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<_
.frm file? Or
> am I missing something here?
Nope, you are right.
MySQL does fsync(), not sync().
It was my mistake - I didn't know all these flavours of syncs so I
wrote sync() in my email :(
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/
Hi!
On Aug 04, Egor Egorov wrote:
> Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>
> >> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
> >> ALTER test results of sql-bench had been greatly improved, CREATE has
> >> shown nasty p
;t create tables at the huge rate, it is not a
problem.
Unfortunately, it is apparently a problem for sql-bench :(
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /
d
innodb tables (otherwise they'll be corrupted).
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mai
ogress using
http://bugs.mysql.com/4844
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www
.html for more
> information.
Did you notice at the above url:
"Version(s): 4.1 prior to version 4.1.3; also version 5.0 "
4.0.18 is NOT vunerable.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ _
en run.
Could you provide a repeatable test case ?
(if yes, you can submit it on bugs.mysql.com, instead of replying here -
and be sure it will get a proper attention)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
rect my.cnf.
By the way, if you want to disable query cache you can turn it of with a
command line switch :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sen
;), (0), ('aaa');
Query OK, 4 rows affected (0.02 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> select hex(b) from a;
++
| hex(b) |
++
| NULL |
||
| 30 |
| 616161 |
++
4 rows in set (0.01 sec)
Regards,
Sergei
--
__ ___
s that were
hidden in the old version.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For li
ll for 2GB table.
read the manual about this variable, and increase accordingly.
check show processlist during indexing
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Soft
?
It was not intentional.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
Hi!
On Jun 25, Dan Cumpian wrote:
> Is there any harm in using the USE_FRM directive by default whenever
> repairing a table?
Yes.
See http://bugs.mysql.com/4252
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL
uot; in the manual.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://
xed.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Maili
ack warnings:
>Warning: Asked for 196608 thread stack, but got 126976
Same here.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___
27;, ''))
will convert uuid to 16-byte string
There's no easy way to do a reverse conversion yet. HEX() will do, but
you'll lose dashes.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
Hi!
On May 12, Nico Sabbi wrote:
> Alle Wednesday 12 May 2004 14:12, hai scritto:
> > Hi!
> >
> > On May 12, Nico Sabbi wrote:
> > > Alle Wednesday 12 May 2004 11:19, Sergei Golubchik ha scritto:
> > > > Hi!
> > > >
> > &g
Hi!
On May 12, Nico Sabbi wrote:
> Alle Wednesday 12 May 2004 11:19, Sergei Golubchik ha scritto:
> > Hi!
> >
> > > sorry for replying to myself, but I verified that adding
> > > replicate-do-db=db to my.cnf doesn't work as I expected
> >
> > W
ent
> > slaves that are configured to
> >
> > replicate-wild-do-table=db.%
> >
> > because there's no db.table syntax, so the slaves discard the insert.
> > Maybe adding
> >
> > replicate-do-db=db (for all of my dbs) will do the trick?
>
>
next block begins.
In the future LOAD INDEX ... will be extended to allow preloading only
some indexes, and not all the file. Then it will be possible to load
indexes of different block lengths.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
Hi!
On Apr 07, Hirofumi Fujiwara wrote:
>
> From: Sergei Golubchik <[EMAIL PROTECTED]>
> > Hi!
> >
> > On Apr 06, Hirofumi Fujiwara wrote:
> > >
> > > I am testing regular expression feature of MYSQL 4.1.1-alpha
> > > (REGEXP) with UTF-
doesn't.
>
> I'd like to know if REGEXP handles UTF-8 characters.
No it does not :(
(we need to change regexp library that we use, to have it fixed)
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/
AIN say in each case ?
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL
T('+("art" "graphic" "publishing")' IN
> BOOLEAN MODE)
Yes. Or simply
'art graphic publishing'
> "web design" AND "web development" AND "webmaster":
> MATCH (jobdescription) AGAINST('+("web design")
ing INNER JOIN or by making
> list of tables seperated by comma (table1,table2,..) with using WHERE
> clause?
no.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ My
m_ftdump to get this
functionality.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
27;;
>
> # Seems to work correctly.
>
> SELECT *
> FROM `table`
> WHERE `name` LIKE 'Ren?';
>
> # This previous line gives no result, and I've understood it is because of
> how "Rene" and "Ren?" are somehow
try your query after upgrade.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archiv
?
Ok, sorry.
If the original query is '"16-bit Touch"' then it would be executed
functionally similar to
MATCH keywords AGAINST ('Touch' IN BOOLEAN MODE)
AND keywords LIKE '%16-bit Touch%'
> Sergei Golubchik wrote:
>
> >Hi!
> >
> >
hing like
select IF(UNCOMPRESSED_LENGTH(msg_body) > 102400, msg_body,
IFNULL(UNCOMPRESS(msg_body), msg_body)) ...
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Sof
T ('+touch +bit') AND ... LIKE '%16-bit%'
that is rows would be selected based on an index lookup for two words,
and as a post-processing a substring search would filter out rows
without "16-bit" substring.
Regards,
Sergei
--
__ ___ ___ __
/
g to get some variables.
> Some pointers may be invalid and cause the dump to abort...
> thd->query at 0x8584920 = O.H..B.
> thd->thread_id=4
> The manual page at http://www.mysql.com/doc/en/Crashing.html contains
> information that should help you find out what is causing
se and query that illustrates the
> problem. Please let me know if you would like me to do this.
Yes, please do!
Then, please, submit a bugreport at http://bugs.mysql.com/
Thank you for your help!
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Se
's the first. Each new need for a temp file picks from
> the round-robin list.
Yes, it's how it works.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Dev
akes a
string as a value. Now it's possible, but 4.0 is stable, so I cannot
make ft_boolean_syntax a changeable variable there.
But I just pushed this to 4.1.
Should be in 4.1.2
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Serge
table test case on http:/bugs.mysql.com.
This way you can make sure it won't happen for the third time :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software
iority issue that I can probably look at
later. As a workaround just compile MySQL without libwrap.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/
me thing happens for a single column fulltext index.
Fixed.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
all table rows, get
> the column and tokenize and collect words?
Use the ft_dump utility program that comes from MySQL source
distribution.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__
How big are your tables (rows and bytes) ? What are typical values for
ThemenCount and MessageCount in the result of this query ?
Can you provide the results of SHOW CREATE TABLE for forum and forum_msg ?
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubch
0.0 1:37 0 sshd
>
> Thanks
> Rob
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/
.com/bug.php?id=1737
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
F
sted
Thanks for alerting us!
> Can this be fixed ?
It should be.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /__
pect that you need only a few rows from your table for this
bug to appear. (of course, finding these exact rows in your gigabytes
could be not easy :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/
uot;upgrading" sections are difficult to follow.
I'm forwarding this request to our doc team.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
it helps ?
Unfortunately we don't have FreeBSD-5/Alpha
to try this ourselves.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___
gives
> me a table of about 16Gb, leaving 75+Gb of free space on my Compaq
> Proliant DL380G2, 1.2Gb RAM. The kernel is compiled with HIGHMEM
> support, and the MySQL database is using a cnf based on my-huge.cnf.
>
> Somebody knows where to start looking?
What is the exact comm
--+
> 1 row in set (5.00 sec)
Not a bug.
In the manual, section "Upgrading from Version 3.23 to 4.0", there is
* To use `MATCH ... AGAINST (... IN BOOLEAN MODE)' with your tables,
you need to rebuild them with `REPAIR TABLE table_name USE_FRM'.
Regards,
Sergei
Hi!
On Jan 11, Matt W wrote:
> Hi,
>
> - Original Message -
> From: "Sergei Golubchik"
> To: "Steven Roussey"
> Sent: Wednesday, December 10, 2003 7:44 AM
> Subject: Re: 4.1.1 FTS 2-level?
>
>
> > Hi!
> >
> > On Dec 09
or phrase syntax.
I tried - works ok.
So - examples are not enough, I need a repeatable test case (e.g. your
table data).
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
the first prefix is
> > looked up in the index) and to add a row scan (in the LIKE sense and as you
> > described in #1), to remove "half-matched" rows.
>
> OK, I see. :-) I'm surprised they're not looked up in the index. But
&
may tell myisamchk that all rows longer
than that are false matches and should be ignored.
> 1) Are there any tools which will allow me to salvage some data?
myisamchk as of 4.1.1.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Go
er of row reads.
I agree this optimization is not the best for all situations,
optimizing this type of queries is in the todo.
btw, it could be that my guess about the slowness was wrong :)
Compare these N,M,K,L numbers yourself.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ _
ed to waste the time sending emails back and forth and speculating,
when your test case is small enough :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/
NULL,
> `xmlstatus` enum('HTML','XML') NOT NULL default 'HTML',
> `bid` char(6) NOT NULL default '',
> `toolbar` int(1) default '0'
> ) TYPE=MyISAM;
What columns are you trying to index ? What is the in
ackup is always recommended :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
My
( http://lists.mysql.com/mysql/149644 ),
> you said "Another reply will follow..." I never saw another reply
> though. :-/ It's OK, I was just wondering what other interesting things
> you were going to say! :-)
Oops, checking...
Yes, sorry.
But I have to admit, I abso
) table names to import them on my webhoster's
> > Linux server. If the setting was enabled, I'd get all wrong table names and
> > my application couldn't find its tables anymore (as 'bb1_GroupMembers' gets
> > to 'bb1_groupmembers' and that's something
1 - 100 of 398 matches
Mail list logo