for global read lock
in show processlist for many tables in many different databases for all
modification queries and locks
Why? As i understood --skip-opt --single-transaction must disable
global read lock
mysql version
Server version: 5.6.27-log Source distribution
Artem
--
MySQL
requested global read lock.
All tables are myisam. MariaDB is 10.0.22 (mysql 5.6 based as i understand)
Artem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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
specific? It
is unrelated the my question, but would be great to have too.
Artem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
product
with f_spec set.
Is using index and doing
select id from products where f_spec=1 limit 1
will be very fast ?
Regards,
Artem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
. 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
considered new, nothing else. So, if product is new then its is
of course in products table and in newproducts table and if it is not new
then it is only in 'products' table.
ID is a seqential number (but no auto_increment - i hate it).
PS: top posting is really popular in mysql list!
--
Artem
method is better here and how each of the method performs.
I will greately appriciate input on this issue.
--
Artem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
To: Russell E Glaue [EMAIL
as the original
database files (i mean, for example, .TMD files which can be huge!).
So, i am currenctly stuck with no solultion to the problem.
--
Artem
Russell E Glaue wrote:
Using Quota on Unix, you can specify a different quota soft_limit for
temporary space.
You can set MySQL to use /tmp
,
Artem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
to limit connection per user? (so one user
cannot abuse the server and take all max_connections connections
for himself).
--
Regards,
Artem
Russell E Glaue wrote:
Using Quota on Unix, you can specify a different quota soft_limit for
temporary space.
You can set MySQL to use /tmp as the temporary
of simultaneous connections that the
account can make. If count is 0 (the default), the max_user_connections system variable determines the number of simultaneous
connections for the account.
We are still kinda stuch to 4.1. Well, its time to upgrade.
--
Regards,
Artem
--
MySQL General Mailing List
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 [somefield
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
'#sql_948_0
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: 5.0.45-community-nt MySQL Community Edition (GPL)
on WIndows 2003 R2 Service Pack 2 Standard
' (Errcode: 13) at cleanfilestore.pl line 89, STDIN line
1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at cleanfilestore.pl
line 90, STDIN line 1.
--
Artem
On 10/31/07, Artem Kuchin [EMAIL PROTECTED] wrote:
I am running
Server version: 5.0.45-community-nt MySQL Community
files?
Why there are files w/o path at all (Can't create/write to file '#sql_bdc_0.MYD') ?
These error accure at different moments every time script is run.
Anynow any idea what's going on here?
TEMP has full rights for ALL. But anyway, as you see, it is not even mentioned
here.
--
Regards,
Artem
Did you try:
select blob_field
from blob_table
order by length(blob_field) DESC limit 1
Regards,
Artem
-Original Message-
From: Roland Carlsson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 10:02 AM
To: mysql@lists.mysql.com
Subject: Find the biggest blobs
Hi
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 use it because this does not use index (EXPLAINs
are bellow). According
|
++-+---+---+---+---+-+--+--+-+
| 1 | SIMPLE | voc2 | range | i_vocabulary_word | i_vocabulary_word |
32 | NULL |1 | Using where |
++-+---+---+---+---+-+--+--+-+
1 row in set (0.00 sec)
This sucks.
Regards,
Artem
--
MySQL
see 12.2 Control Flow functions of MySQL manual
select name, if(adopted=0,'N','Y') from animal;
-Original Message-
From: Sue Cram [mailto:[EMAIL PROTECTED]
Sent: Monday, February 07, 2005 2:58 AM
To: mysql@lists.mysql.com
Subject: How do I Put a 'Literal' Value in a Report Column?
default-storage-engine=INNODB in [mysqld] section of the config file will make
InnoDB default for a server.
-Original Message-
From: symbulos partners [mailto:[EMAIL PROTECTED]
Sent: Friday, January 28, 2005 8:03 AM
To: mysql@lists.mysql.com
Subject: InnoDB engine as default for an
Hello Scott,
Make sure your tables are InnoDB type:
CREATE TABLE table_name ( table_def ...) ENGINE=InnoDB;
If you have default MyISAM tables, it won't work because they don't support
foreign keys.
-Original Message-
From: Scott Purcell [mailto:[EMAIL PROTECTED]
Sent: Thursday,
in the [mysqld] section of the MySQL
configuration file.
Regards,
Artem
-Original Message-
From: Lutz Maibach [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 9:58 AM
To: mysql Liste
Subject: Re: drop table is written to bin-log, load table is NOT -
why
Hello Artem
');
-Original Message-
From: Artem Koltsov [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 10:29 AM
To: Scott Purcell; mysql@lists.mysql.com
Subject: RE: cascade on delete problem
Hello Scott,
Make sure your tables are InnoDB type
I had similar problem after incomplete removal MySQL 4.0.x which left dead
service named MySQL that points to non-existing path c:\mysql. I changed the
windows service name for MySQL 4.1 to MySQL41, and it works fine. Also you can
try to execute mysqld from command line to see any extra
you may need log-slave-update option on if you have daisy-chain replication.
Regards,
Artem
-Original Message-
From: Lutz Maibach [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 26, 2005 8:24 AM
To: mysql Liste
Subject: drop table is written to bin-log, load table is NOT - why
Try Query Browser ( http://dev.mysql.com/downloads/query-browser ) for building
queries for MySQL.
Regards,
Artem
-Original Message-
From: Daniel Sousa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 26, 2005 11:18 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re
Works fine on WinXP 4.1.8. Only generates warning:
mysql show warnings;
+-+--+--+
| Level | Code | Message
|
Did you try to increase max_allowed_packet in server config to 5M, for example.
The default size is 1M and it is less then the size of your file (1.5M).
Artem
-Original Message-
From: J.R. Bullington [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 11:45 AM
To: mysql
Hello,
If you define table type as InnoDB, you can use transactions (see the link
below). You will need set AUTOCOMMIT=0, and after you can issue COMMIT or
ROLLBACK at the end of query or session to submit or cancel a transaction. I
don't think you can use transactions for mysql system tables
Check ALTER statement in MySQL doc. It explains how to add/modify an index
after a table has been created.
-Original Message-
From: sam wun [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 19, 2005 10:00 AM
Cc: mysql@lists.mysql.com
Subject: Re: sub query is extermely slow
- make sure log-bin is enabled on both master and slave (looks like it is not
present in the slave config)
- check replication account permissions on the master. I don't remember
details, but you can find required permissions in the docs on mysql web site,
or doc file in mysql installation
- make sure log-bin is enabled on both master and slave
(looks like it is not present in the slave config)
Why is log-bin needed on the slave? I thought the master logs changes
and the slave reads those changes and updates it's copy. Why should
the slave also log changes it is making?
--
Best regards,
artemmailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
@a:[EMAIL PROTECTED] as counter, field1, field2 from Table
however in some cases with complex queries it's not work
--
Best regards,
artemmailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
hello !
I'm using my french host's phpMyAdmin and I'd like to create manually a new table
using different character set and collation
than default one. This is the code I've used :
CREATE TABLE `ru` (
`pkey` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`titre` TEXT NOT NULL
) CHARACTER SET
personal Win98 Duron650 128MB Mysql 4.0.13 - 1.37 sec
busy server Redhat 7.0 Celeron 333 380MB Mysql 3.23.54 - 3.11 sec
-Original Message-
From: Jake Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 5:34 PM
To: Mysql
Subject: What is a good benchmark?
I ran
please clarify use of set autocommit
SET AUTOCOMMIT = 0 == mean start transaction
... - some actions
COMMIT == transaction end
now to return to autocommit mode
just one line:
SET AUTOCOMMIT = 1
or two?
SET AUTOCOMMIT = 1
COMMIT
insert one space before US ;)
in recieving do trim if not HTML output
-Original Message-
From: Ralph [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 7:32 AM
To: mySQL Mailing List
Subject: Sorting Countries
I am getting a list of all countries from database, and then I am
yesterday i had same problem on 4.0.13 for win
added [EMAIL PROTECTED] - and was rejected
added [EMAIL PROTECTED] - then accepted
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 4:54 PM
To: Roman Neuhauser; Riaan Oberholzer
Cc: [EMAIL
on earth this would be 300 times faster than the above
query? It seems as mysql just can't optimize the query
properly.
Also, maybe someone got a link to articles describe effective
technique for building full-text search engine?
Regards, Artem
morphology and some other stuff that I need.
Please, help, if you can.
Regards, Artem
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
depending if it is
plural, male, female, etc).
Actually, i cannot belive that it takes mysql 2 seconds
to select 120 records from a table with two ints with
23 records with a index. This just sounds unreal.
- Original Message -
From: Brent Baisley [EMAIL PROTECTED]
To: Artem Koutchine
On Wed, 12 Feb 2003 15:50:29 +0300
Artem Koutchine [EMAIL PROTECTED] wrote:
Hi!
I have posted this message yerstaday, but apperantly
did not give enough information for reader to figure out
what's going on. So, i am reposting it with more information.
I have the following table
. The request is using INNER JOIN to get
the words in the 'AND' manner (laws which contain ALL specified
words).
I don't understand what i am doing wrong, since i thought it is
a basic technology behind any search engine.
Please, help, if you can.
Regards, Artem
)
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Artem Koutchine' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 5:29 PM
Subject: RE: Very slow request with many ORs in where parts
Can you post your explain plan?
-Original Message-
From
select * from appointment a where a.adatetime now() - interval 3 minute;
read user manual date/time functions. it's all there with examples.
-Original Message-
From: Prabu Subroto [mailto:prabusubroto;yahoo.com]
Sent: Thursday, October 24, 2002 9:21 AM
To: [EMAIL PROTECTED]
Description:
Probably it's variation of recent bug with null joins, but just in case I want to post
it here because result depends on values inserted into tables, even if these values
are not participating in join.
After data insert with nulls the same query will produce different result after
Do you connect/disconnect before/after every insert?
-Original Message-
From: Dallas Engelken [mailto:dallase;nmgi.com]
Sent: Thursday, October 24, 2002 9:52 AM
To: [EMAIL PROTECTED]
Subject: DBI Connect Fails after 20,000 record inserts/updates
I am trying to parse an email log
I have v.4.0.4b max nt, and I have the same result, even more:
mysql INSERT INTO settest SET chain=A,C;
ERROR 1062: Duplicate entry 'A,C' for key 1
mysql INSERT INTO settest SET chain=C,A;
ERROR 1062: Duplicate entry 'A,C' for key 1
mysql
but
mysql SELECT * FROM settest WHERE FIND_IN_SET('C,A',
possible problems. Of course if there are any special
requirements for the database, they have to be incorporated into the model.
Am I missing your point?
Artem
-Original Message-
From: [EMAIL PROTECTED] [mailto:speters;metromls.com]
Sent: Monday, October 21, 2002 5:43 PM
To: [EMAIL PROTECTED
You can use TIMESTAMP field for this. It's automatically assigned current date if you
don't insert anything in this field type or insert null.
-Original Message-
From: Arthur [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 7:56 AM
To: MYSQL
Subject: Insert default Date
select sum(first) from example;
should work.
Artem
-Original Message-
From: Kevin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 10:36 PM
To: [EMAIL PROTECTED]
Subject: Help with Sum(), newbie
OK. Maybe I'm expecting too much of myself, but I can't figure out what I am
It looks like a bug. I was able to repeat it and I had different results for the same
join depending on when index was added and values of actual data in tables.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 6:33 PM
To: [EMAIL
Hello Victoria,
As far as I see bug of muliple log files still not fixed regardless
of last change in 4.0.4:
'FLUSH LOGS removed numerical extension for all future update logs.'
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
sql query
!
I tested it yesterday and also have got thousands of log files :(
4.0.3 Already out, but bug is still exists.
Does anybody something to fix this bus?
--
Best regards,
Artem mailto:[EMAIL PROTECTED
Hello mysql,
In case of repliacation circle (A-B-A) query 'flush log' on any of
this servers create endless loop, with creating new binary log file
on each iteration. (about 30 new files every second in my case)
--
Best regards,
Artem mailto:[EMAIL PROTECTED
Will be fixed this error in 4.0.3?
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Artem Ryabov
Organization:
MySQL support: none
Synopsis: too many bin-log files
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release
#
--
and so on.
Will be fixed this error in 4.0.3?
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Artem Ryabov
Organization:
MySQL support: none
Synopsis: too many bin-log files
Severity: serious
Priority
two long that cancel query.
question: how can i optimize the query(ies)? i need to match
web-server timeout of 30 secs.
Artem Mikhailov
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
Hello Sergei,
Tuesday, July 23, 2002, 10:17:06 PM, you wrote:
SG Hi!
SG On Jul 23, Artem V. Ryabov wrote:
Hello mysql,
see this 2 queries:
why they not equal?
why first skip many records?
mysql select left(ftText,20) from Txt_index where match(ftText)
against('+(wùd200206*) +wù12p
Hello Sergei,
Tuesday, July 23, 2002, 10:17:06 PM, you wrote:
SG Hi!
SG On Jul 23, Artem V. Ryabov wrote:
Hello mysql,
see this 2 queries:
why they not equal?
why first skip many records?
mysql select left(ftText,20) from Txt_index where match(ftText)
against('+(wùd200206*) +wù12p
in set (0.00 sec)
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
) write you all other bugs.
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
|
+-+
1 row in set (0.00 sec)
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
in set (0.00 sec)
mysql show variables like 'version';
+---++
| Variable_name | Value |
+---++
| version | 3.23.49yes-log |
+---++
1 row in set (0.00 sec)
--
Best regards,
Artem
|
+---+-+--+--+
1 row in set (0.93 sec)
JZ Jeremy
--
Best regards,
Artemmailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
database 'ubex'
Mysql is 3.23.40, OS is FreeBSD 4.4-RC, Perl is 5.005_03
DBI.pm is 1.14 (ID: v. 10.32 2000/06/14 20:04:03)
MySQL DBD is 2.0409 (ID: v 1.5 1999/10/03 17:46:19)
The same happens with other databases accessed from
a script run from a cron.
What could be wrong?
Regards,
Artem
(0.00 sec)
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
B:
1 a
2 b
5 e
6 f
RETURNS: 3,4,5,6
For simplicity assume, that one name can be only onces in a table and
if names match then IDs also match. (2 - b cannot be 2 -c in another
table).
The trick is to do it in ONE SQL statement.
Regards,
Artem
d
UPPLACE ids set id=4, name='z' where id=2;
after this table has:
1 a
4 z
3 c
Artem
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
where can i found description of BDB messages writed in log and also what
must be done in the case
or maybe somebody can help and tell me what went wrong:
bdb: Log sequence error: page LSN 1:2043982; previous LSN 1 2074929010608
21:12:22
bdb: Log sequence error: page LSN 1:2043982; previous
Hi
i'm newbie and have the problem -
sometimes after some INSERT and also sometimes just from nothing
simple SELECT begin work not properly - it returns not all rows in the table
that must.
in most cases FLUSH TABLES help, but yesterday it won't help - SELECT
continue return empty result,
There is a module for Perl which can read Excel. Then there is DBI for
accessing MySQL. Use both to transfer data.
If under Windows, you coudl also use ODBC and some ActiveX control
under Visual Basic for quick and dirty transfer scripting.
- Original Message -
From: Chris L. Gray
RT-F***ING-M!
No foreign keys in mysql!
- Original Message -
From: Russell Teo Wee Liang [EMAIL PROTECTED]
To: mysql mailing list [EMAIL PROTECTED]
Sent: Saturday, May 19, 2001 8:03 PM
Subject: Foreign Key in creating tables
Hi all,
I create a sample database using foreign keys.
? Or just grep the manual
so you find all possible information for the subject in
question.
PS: Replies like mine are not waste of time. They are
psychological burn-out. They make you feel better:)
- Original Message -
From: Nisha Raju [EMAIL PROTECTED]
To: Artem Koutchine [EMAIL PROTECTED
.
- Original Message -
From: Russell Teo Wee Liang [EMAIL PROTECTED]
To: Artem Koutchine [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, May 19, 2001 9:59 PM
Subject: Re: Foreign Key in creating tables
To infer without actual proof or evidence is not of a scientist's
ways. How
can u ever be sure
I wonder how people use RDBMS w/o ever
reading manuals. Do they get paid for their
work?
- Original Message -
From: Sheshadri YS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 26, 2001 6:57 PM
Subject: Unable to Solve NOT IN Problem
Respected Sir,
We are facing
Sinisa, i thought i pointed out that mysql ALWAYS
crashes on any single INSERT DELAY anytime,
any database, under any conditions and during any
weather. NO single INSERT DELAY can be executed
successfully.
Regards,
Artem
- Original Message -
From: "Sinisa Milivojevic" [EMAIL
on any database with ant
tables using any 3.23.xx It just says "Server has gone
away".
Sinisa, i want to point out that this is not LINUX, it
is FreeBSD which is fully rebuild weekly from cvs.
What shoudl i do to make it work?
Regards,
Artem
the range while inserting into aa. Tricky business.
Any ideas?
Not really impirtant, but i thought i would an interesting task.
Regards,
Artem
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
ad.
Mysql is 3.23.33 compiled from the tar ball (NOT FROM PORTS)
with the options recomended in the ports to stop it from crashing
on heavy loads.
OS: FreeBSD 4.2-STABLE
Regards,
Artem
-
Before posting, please check:
http://www
;
}
close A;
}
$DBH-disconnect();
What would cause the lockup problem?
MySQL: 3.23.33 compiled from tar ball with compiler option suggested
to make it stable for large loads on FreeBSD (they are listed in the
port's makefile).
OS: FreeBSD 4.2-STABLE
Regards,
Artem Koutchine
Relax, XML has N.O.T.H.I.N.G. to do with what you want to do.
You want dynamically update (rebuild) HTML page, well,
the only way to do it currently in more or less compatible way
is to use javascript+DHTML. And the result will SUCK, i know,
i've done it. So, go the way the elders did. Refresh
Aha, java is even better :)
- Original Message -
From: "Brian V Bonini" [EMAIL PROTECTED]
To: "Peter Skipworth" [EMAIL PROTECTED]; "Siim Einfeldt aka
Itpunk" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL
No, solve it in your own program.
- Original Message -
From: "Robert Heron" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 6:35 PM
Subject: special characters in MySQL query
I have written a program which reads data from WWW forms and passes
it to
MySQL
I said Java. Java i said. Java said I.
- Original Message -
From: "Wernher Korff" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 6:53 PM
Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL
can yopu link a database to flash?
van
-Original
try mod_auth_mda
or some generic auth module which allows authrization via
any script. However, i am happily using mod_auth_mysql
with 1.3.14, however i build from the port on mysql with
some magic envolved. However, i didn't try to build
it with 1.3.17
- Original Message -
From: "Erik
what's you table definition, what;s your query
- Original Message -
From: "Thomas Kaester(global)" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 12, 2001 11:10 AM
Subject: Problems with text fields
Hello everybody,
ich have a few problems with text fields. I want
I am not good at DB theory, but in our practice
(SQL DB development form WEB since 97) splitting
a table to get recrods to be fixed length is always
beneficial when table is in haavy use. You can get fast
lookups and just a bit slower inserts, but since, inserts
are usually much rare compared to
mysqladmin shutdown
myisamchk -o ./*.MYI
myisamchk -r ./*.MYI
(or isamchk if you are using the old isam tables)
then restart mysql.
- Original Message -
From: "Frdric Bonjour" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 30, 2001 1:05 PM
Subject: Error 127: table
the table. As i said before that
we've
been doing for years now (keep all blob, text fields in separate
tables).
For me it is a strict rule by now.
Split it!
Regards,
Artem Koutchine
Technical Director of "IP Form"
(www
(on newest Debian release)
4) It's on Dual xeon P2 400 1MB Cache, with 1G ram on board
It's slow because it contains many files. i.e. Reading a big files
is always
faster than reading many small files
- Original Message -
From: "Artem Koutchine" [EMAIL PROTECTED]
To: "S
You might take a look at my message about
MySQL 3.23.32 and FreeBSD 4.2-stable
try doing what i did there. I did it only
yersterday but so far not sig 11.
Me message is posted yersterday and it has
FreeBSD 4.2-stable in the subject and it is from
me (Artem Koutchine). Search
i don't know exactly, but based on the message it seems to be
a permission problem in the mysql rights. So, RTFM on
the mysql permission model and commands.
- Original Message -
From: "Velamarthy Murthy" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 28, 2001 3:08 PM
Why not just reinit the database as specified in the
last step on install (after make install) in the manual.
No need to delete your database, just back them up
somewhere else. Then delete eveyrthing in your
localstatedir (where thedatabases are) including
'mysql' dir. Do reinit, and copy back
I have no idea what 'apt-get' is. MySQL, IMHO, should always be
installed from the sources by compiling by hands. Get the sources
and learn to install it correctly.
- Original Message -
From: "John-Mark" [EMAIL PROTECTED]
To: "Artem Koutchine" [EMAIL PROTECTED]; [E
1 - 100 of 111 matches
Mail list logo