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
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
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
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
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
ains ONLY ids of products
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 reall
ow
which 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]
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
oup 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 /
er 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 Mailin
ow 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 temp
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
rds,
Artem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
'
d: fetch() without execute() at cleanfilestore.pl
line 90, line 1.
Two points here
1) The number of errors is different, rerunning the script will result in
different number of errors and sometimes no errors
at all, so, this error is unstable and sporadic
2) As you see file mentioned in the err
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-
ng in Programe 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 ev
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 th
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
+-+---+---+---+---+-+--+--+-+
| id | select_type | table | type | possible_keys | key |
key_len | ref | rows | Extra |
++-+---+---+---+---+-+--+--+-+
| 1 | SIMPLE | voc2 | range | i_vocabulary_word | i_v
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 Colu
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
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 details:
#x27;);
> >
> > CREATE TABLE MENU_GROUP_REL (
> > menu_type varchar(200),
> > data_id int NOT NULL,
> > display_name varchar(250),
> > link varchar(250),
> > ) type=INNODB;
> >
> > ALTER TABLE MENU_GROUP_REL ADD CONSTRAINT PK_MENU_GROUP_REL
> FOREIGN K
[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 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, J
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@
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, lo
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
&g
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 b
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)
>
> 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 makin
- 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 direc
define path to store files in conf file
2 upload there with unique name (use php uniqueid)
3 to show image use php getimagesize to get width, height and image
type (even for swf)
that's the way
only minus is more work to backup/copy database with images
--
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]
SET @a=0
SELECT @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.c
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 koi8
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?
>
>
>
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
t
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 PROTE
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
sorti
ake from 0 to 0.01 seconds.
Now, why 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 buil
> 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 repo
ange in many ways 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" <[EMA
rch because it does not
do any 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/
--+
2 rows in set (0.01 sec)
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Artem Koutchine'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 5:29 PM
Subject: RE:
hree words. 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
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
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 databas
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 ad
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]
Subjec
;t see any 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
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
Hello
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 PRO
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
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]
econd in my case)
> Thanks for bug report!
> 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
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:
> # at 43
aor> #020812 16:31:13 server id 1 log_pos 43Stop
aor> [www2:/opt/mysql-dev/var]:1308#
aor> --
aor> and so on.
aor> Will be fixed this error in 4.0.3?
>>How-To-Repeat:
>>Fix:
>>Submitter-Id:
>>Origin
var]:1308#
--
and so on.
Will be fixed this error in 4.0.3?
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Artem Ryabov
>Organization:
>MySQL support: none
>Synopsis: too many bin-log files
>
ies takes
about some seconds, but on real tables with more than 10 000 entries i
wait 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]
--
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(ftTe
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(ftTe
--+-+
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
Release it!
We (users) 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
744 |
+-+
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.
(`SectID`,`Date`,`ID`)
) TYPE=MyISAM COMMENT='ÓÓÓ' |
1 row in set (0.00 sec)
mysql> show variables like 'version';
+---++
| Variable_name | Value |
+---++
| version | 3.23.49yes-log |
+---
ect count(*) from Textes where SectID=6;
and many other.
JZ> Can you run "ANALYZE TABLE Textes" and see if that helps?
of course:
mysql> ANALYZE TABLE Textes;
+---+-+--+--+
| Table | Op | Msg_type | Msg_text |
+---+-+--+--+
| NewWeb.Textes |
:
Unknown 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 wr
ssible_keys | key| key_len | ref | rows | Extra
| |
+---+--+---++-+---+---+-+
| cSectText | ref | SectID| SectID | 4 | const | 21892 | where used;
|Using index |
+---+--+---++-+---+---+-----+
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 li
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 LSN
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, until
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" <[EM
work.
- 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 evid
ection 5.4
Functionality Missing from MySQL."
I repeat: "don't actually do anything"
That means not a single thing, right?
- Original Message -
From: "Russell Teo Wee Liang" <[EMAIL PROTECTED]>
To: "Artem Koutchine" <[EMAIL PROTECTED]>; &quo
u might want to have a table holding UNIQUE ids so
every inserted record is unique.
Mayways, depends on what EXACTLY you want.
Describe your case better.
Regards,
Artem
- Original Message -
From: "Dave Carter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday,
27; keyword? 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: &quo
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 key
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 facin
|
++
| 202101 |
| 202201 |
| 234201 |
| 234201 |
| 201801 |
| 201901 |
| 202001 |
| 234101 |
| 234201 |
| 234201 |
++
10 rows in set (0.02 sec)
Voila!! 0.02 seconds agains 8 seconds.
So, why Mysql chooses the wrong index?
Regards,
Artem
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" <[EM
when do configure:
--with-charset=win-1251
It is clearly explained in the manual. READ THE MANUAL!
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: "Vitaly Dugaev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 6:59 PM
Subject: Re: Use Ukrainian l
ions of records in a short time for development and
testing purposes.
Regards,
Artem
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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
figure out 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
crushed by
using INSERT DELAYED.
As for REPLACE/INSERT lockup, i figured that it could
happen when there is no space left on device.
Artem
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Frida
$data[6]+0,
$data[7]+0
) || die "Cannot execute query";
}
close A;
}
$DBH->disconnect();
What would cause the lockup problem?
MySQL: 3.23.33 compiled from tar ball with compi
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
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 Tj
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
>
> -Origina
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
> MyS
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]>
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 th
damn it, DOES ANYBODY READ MANUALS these days?
in short: yes
for details: RTFM
it might not be good. you probabluy want to keep filenames in
the db, but files itself in the filesystems. Your choice.
Artem
- Original Message -
From: "Nikhilesh Haval" <[EMAIL PROTECTED]>
t it costs time money and health to the aswerring
person, so why not to make that person's job easier by putting as much
info
as you can in your question?
Now for the topic:
WHAT ERROR ARE YOU GETTING?
You probably used a reseved word for field name.
Artem
- Original Message
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
1 - 100 of 124 matches
Mail list logo
