I am running MySQL Community edition 5.0.51a-0.rhel4 (on RedHat Enterprise
Linux 4). I am unable to load data from a text file; when I try I get the
error message in the subject of this email. In the typescript below you
will see two tries, with all the necessary file and database permissions.
Hi Saul,
I need to use C++ and I'm not writing a web application.
Thanks anyway.
Kandy
> I have done queries to the database in PHP with variables like month but
> easily can select from a range of time and data to produce the same
> results, the output goes directly to the web so if that is wha
I have done queries to the database in PHP with variables like month but
easily can select from a range of time and data to produce the same
results, the output goes directly to the web so if that is what you are
seeking for, I can help with PHP.
Saul
Kandy Wong wrote:
Hi,
I need to write a
Hi,
I need to write a C++ program in a Linux environment to query with a
timestamp.
The user will only provide with an approximate time so I'd like to know
how can I write a program or a query to return the closest data.
The followings are the timestamp in the MySQL database:
| 2008-08-05 03:56:0
Hello mysql,
As I have previously mentioned, I installed WAMPSERVER 2.0 on my
Windows XP pro box recently. It installed INNODB as the Default
Engine.
All of my legacy Databases are MYISAM and after the installation, I
copied them all into the DATA folder and everything worked, even
adding new tab
If you want MYSQL to process the SELECT, including information about how tables
are joined and in which order
usehttp://dev.mysql.com/doc/refman/5.0/en/using-explain.htmle.g. EXPLAIN
[EXTENDED] SELECT select_optionsIf you want MySQL uses the stored key
distribution to decide the order in which
Record the query, execute and see the result. Make sure that you get the
result. To me its seems that lots of request are comming and not full
filled. Check the query for optimization.
On Thu, Aug 14, 2008 at 5:17 PM, Vlad Shalnev <[EMAIL PROTECTED]> wrote:
> Hi,
>
> OS - Solaris 10, 32 Gb RAM, m
Hi,
OS - Solaris 10, 32 Gb RAM, mysql 64-bit 4.1.22
Every day I see in processlist many SELECT queries that stay in NULL state for a
long time. Something Like this
| 368966 | radius | fire-u1:35671 | srg_conf | Query | 106 | NULL
|SELECT id, deleted_id, status, name,
Yes,
mysql12940 0.0 27.3 324124 264672 ? SAug06 0:12
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
mysql12941 0.0 27.3 324124 264672 ? S
r they all runing on the same port
On 8/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> But some of the mysql server(mysql server on debian) shows only one mysql
> process.
>
> On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David <
> [EMAIL PROTECTED]> wrote:
>
> > I may be talking rub
But some of the mysql server(mysql server on debian) shows only one mysql
process.
On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David <
[EMAIL PROTECTED]> wrote:
> I may be talking rubbish here, but is it not threading?
>
> I have seen Linux processes before create more than one PID etc when it
> n
On Thu, 14 Aug 2008 10:27:29 +0530, Krishna Chandra Prajapati wrote:
> Please help me that what should i do.
Nothing. It's just multi-threaded. Everything's fine.
--
Matthias Urlichs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
I may be talking rubbish here, but is it not threading?
I have seen Linux processes before create more than one PID etc when it
needs to handle multiple requests. This may be not true for MySQL.
However when looking at my test server is shows more than one. If you
use a command called htop, simila
13 matches
Mail list logo
