Re: MySQL has gone - with python and blobs

See http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Mike At 12:37 PM 6/1/2010, durumdara wrote: Hi! I want to test my program that coded into PGSQL, and PySQLite. With these DBs I have problem on many blob deletion (2 hours) and compact/vacuum (1 hours)... So I'm trying to port my progr

MySQL has gone - with python and blobs

Hi! I want to test my program that coded into PGSQL, and PySQLite. With these DBs I have problem on many blob deletion (2 hours) and compact/vacuum (1 hours)... So I'm trying to port my program, and before that making a test to check, which time needs to delete 1 GB of blobs. I installed MySQLD

Re: Temporary tables created on disk: 99%

On Tue, Jun 1, 2010 at 8:40 AM, John G. Heim wrote: > On my db server, mysql has 2 gigabytes for temporary tables and yet its > creating 99% of temporary tables on disk. > > According to mysqltuner, 99% of temporary tables are created on disk. Probably blobs: "Instances of BLOB or TEXT columns in

Re: load data in php

This sounds like a matter to take up with whoever supports the particular PHP/MySQL interface you are using. Are you using the mysql, mysqli or dbo? The restriction very likely originates from that layer. - michael dykman On Tue, Jun 1, 2010 at 11:11 AM, memo garcia wrote: > Nike, > > > > I’m

Temporary tables created on disk: 99%

On my db server, mysql has 2 gigabytes for temporary tables and yet its creating 99% of temporary tables on disk. According to mysqltuner, 99% of temporary tables are created on disk. I've confirmed this via the "show global status like 'created%'" command. This is in spite of having the foll

Strange GREATEST() result in 5.0.32

Hello all I have a stored procedure that probably does a lot more than it should, but it works fine on my test server (which is running 5.0.67). When I moved it over to the production server, (which is running 5.0.32 and I never thought to check that the versions were the same before) it works a

RE: load data in php

Nike, I’m using PHP 5.2.3 with Suhosin-Patch 0.9.7 (cli) (built: May 7 2010 08:41:40) Thanks, Memo García Sir CIS Asociados Consultores en Transporte S.A. Austria 2042 Providencia Santiago de Chile F: 56-2- 2051033 Fax: 56-2-2051029 www.cisconsultores.cl _ De: Mike [ma

Re: Security issues

In infinite wisdom "Jerry Schwartz" wrote: > Back when this was a day-to-day concern of mine, I used to check CERT's > website (the section now known as their "Vulnerability Notes Database", > http://www.kb.cert.org/vuls). If securing the database is your job, then you really need to drink fr

Re: load data in php

If you are using v4 of php this will never work On Tue, Jun 1, 2010 at 10:24 AM, memo garcia wrote: > Hi all, > > > > I have the following script: > > Load data > > Local infile ‘myData.csv’ > > Into table myTable > > Fields terminated by ‘,’ > > Enclosed by ‘’ > > Lines terminated by ‘\r\n’ > >

load data in php

Hi all, I have the following script: Load data Local infile ‘myData.csv’ Into table myTable Fields terminated by ‘,’ Enclosed by ‘’ Lines terminated by ‘\r\n’ (field1, field2, …) When this is sourced directly from mysql it works fine, but when invoked from php, I get the error The u

Re: High MySQL sleep count

In infinite wisdom Brent Clark wrote: > All servers are in datacentres. Im not 100% sure if its latency related, > but I see a load or SLEEP when I do mysqladin proc, which appears to be > hogging mysql. > > My question is. Would adjusting timeout values address this problem. The main causes

Access denied for phpmyadmin

Hi all, when i m trying to access phpmyadmin it gives the error * #1045 - Access denied for user 'pma'@'localhost' (using password: NO) ** *How could i fix the problem olease help me, Advanced thanx to you. -Regards Ganeswar Mishra Junior Programmer TathyaSoft pvt. ltd. (+91)9438014761