Re: Request problem (with \\)

Hi, It works, thanks you for your help :-) ViSolve DB Team wrote: Hi Gabriel, Try as: mysql select * from forum where topoc like %%; To search for '\', specify it as ''; this is because the backslashes are stripped once by the parser and again when the pattern match is made,

Query about MySQL

Hi All I got your mail id from one of the forums. can u plz tell me tht wht is the capacity of storage of MySQL DB. acutally we are in the process of making a project on LAMP technology, but the databse is too large..say 1722 records this much of records will remain in one table

Re: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

The second major problem I am running into after the upgrade is the following error, which did not occur on Development. Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP. The error occurred on line 8. MySQL version is: 5.0.27 Thanks in

RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

I'm simply executing a SELECT query that used to work before, same database, everything the same except a higher version of the MySQL server. -Original Message- From: Nuno Oliveira [mailto:[EMAIL PROTECTED] Sent: Monday, 22 January 2007 7:33 PM To: mysql@lists.mysql.com Subject: Re:

RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

I'm simply executing a SELECT query that used to work before, same database, everything the same except a higher version of the MySQL server. In that case you are probably facing some uncompatible issue between the versions you used. Maybe someone else is able to help you more that I :(

RE: Query about MySQL

Hi Raman, Is mysql is able to manage this huge amount of data. MySQL does manage this amount of data very easily. Can we put this much of data in single table database OR keeping the data in multiple tables is the good practice. You can keep this much amount of data in one single MySQL

Re: Query about MySQL

Hi, 1) In MySQL, the size of the table limits to the storage engine and the file system size. [minimum -default -2GB] 2) As of our understanding, keeping in multiple tables is a good practice, that too with perfect normalization. If multiple tables, table sizes are in hand, limit of file

low-priority-updates and innodb tables

Здравствуйте, mysql. Hi all. I want to ask about low-priority-updates and innodb tables. Does low-priority-updates=1 affect on priority of select or update query on innodb type tables? -- С уважением, Vitaliy mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For

RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

This is because with version 4.1 and higher the format of timestamp changes to -00-00 00:00:00. We had this problem, so we had to add a few lines in the scripts that take this field and work with it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

MCN's video website is now back Alhamdulillah

MAFHH (Masoomeen) Cable Network Website: http://www.mcn786.net Allah only desires to keep away the uncleanness from you, O people of the House! and to purify you a (thorough) purifying.{33:33} Respected Brothers Sisters, Assalam-o-Alaikum Wa Rahmatullahi Wa Barakatahu

Help indexing this query.

--- ptsSignups -- id int(20) No mid int(20) No 0 ptsID int(20) No 0 pps double No 0 points double No 0 loginID varchar(255) No emailConfirm longtext No time timestamp Yes CURRENT_TIMESTAMP reasonForDeny longtext No status int(1) No 1 --- index (timeframe) --- timeframe

Re: Help indexing this query.

Andrew, can you post the result of EXPLAIN query for your query? Minus the FORCE INDEX too. Also the structure of the other 2 tables would be helpful as well. Thanks, Dan On 1/22/07, altendew [EMAIL PROTECTED] wrote: --- ptsSignups -- id int(20) No mid int(20) No 0 ptsID int(20) No 0 pps

Re: Help indexing this query.

--- EXPLAIN --- 1 SIMPLE e system cid NULL NULL NULL 0 const row not found 1 SIMPLE s ref sid,status,timeframe status 4 const 20438 Using where; Using temporary; Using filesort 1 SIMPLE m eq_ref PRIMARY,status PRIMARY 4 sc_72.s.mid 1 Using where --- members --- id int(20) No first

Re: Include a stored procedure ( that returns a recordset ) in another query

At 3:00 PM +1100 1/22/07, Daniel Kasak wrote: Hi all. I'd like to be able to define a stored procedure that returns a recordset ( I've done this bit ), and then select from this in another query, eg: CREATE [EMAIL PROTECTED] PROCEDURE `sp_MyClients`( IN ACCMAN INT ) BEGIN select * from

RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

Hi thanks for replying. I can't immediately see the difference between your sample and mine, except the single quotes are missing, is that it? Thanks in advance. -Original Message- From: tere [mailto:[EMAIL PROTECTED] Sent: Monday, 22 January 2007 9:12 PM To: mysql@lists.mysql.com

Re: Visual Basic 6 + MySQL

On Sunday 21 January 2007 16:41, Nuno Vaz Oliveira wrote: Just FYI: you can get the Express version of the VB.Net portion of Visual Studio for free: http://msdn.microsoft.com/vstudio/express/default.aspx That way, you're much more likely to have a fully supported app. I've not tried

Re: Help indexing this query.

Andrew, couple of suggestions: 1 - where you use s.status='2' change it to s.status=2 otherwise MySQL is likely casting your data from int to string, which is slow and also precludes using an index. 2 - in this case, instead of using a left join, try using a subquery: WHERE ... AND s.mid NOT IN

Re: Help indexing this query.

Thanks for the casting tip. Dan Buettner-2 wrote: Andrew, couple of suggestions: 1 - where you use s.status='2' change it to s.status=2 otherwise MySQL is likely casting your data from int to string, which is slow and also precludes using an index. 2 - in this case, instead of

Backup: Copy MYSQL Directory or use MysqlDump

I want to create a backup for my MySQL database every single night. I am currently running on a linux box. I have a backup drive located as /backup Would it be more effecient to use mysqldump tool, or use the unix command dump or cp Andrew -- View this message in context:

Removing space characters ... char(160)? ... char(194)?

Hi all. I'm trying to weed out garbage that comes from copying and pasting stuff from a web page. Some of the data has spaces, but a *different* kind of space ... a char(160) kind ... I think ... I figured this out by copying the space character and pasting it into mysql thus: select

MYSQL reporting an error with subquery query

Hello Fellow MySqueelers!, SELECT version() reveals... 4.0.24-nt-max-log I have looked at the following query a hundred times, and cannot find how MYSQL can report a syntax error to me. query string is... SELECT RAND() AS `RAND`, `prod`.`id` FROM `prod` JOIN `pack` ON `prod`.`id` =

Re: MYSQL reporting an error with subquery query

In the last episode (Jan 23), A Blossom of Paradise said: SELECT version() reveals... 4.0.24-nt-max-log I have looked at the following query a hundred times, and cannot find how MYSQL can report a syntax error to me. 4.0 does not support subqueries. You will need to upgrade to at

Urgent - MySQL 5 - mysqld using a lot of memory consistently

Hello all, Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are taking a lot of time to execute in the newer version. The queries which were executing within 10 secs are now taking more than 100 secs. Running an expalin on the queries showed that an index_merge optimization

Re: Backup: Copy MYSQL Directory or use MysqlDump

Hi, Hope I have faced this: If we copy the files with 'cp' command, the permissions will not be retained. You have to assign it on restoring. But in the mysqldump utility, everything are retained as it is. Hope, mysqldump utility provides more options related to db than that of 'cp'

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

Thanks, By how much should I be increasing the thread_cache? currently it is 8... Currently I can provide the EXPLAIN result of a query using index_merge on MySQL 5.0.22. EXPLAIN SELECT IFNULL(TAEM.FLD_FULL_NAME, TFMM.FLD_ASSIGNED_TO) AS ELE1 , TFMM.FLD_ASSIGNED_TO AS KEY_ID, SUM(1) AS ELE2,

Re: Backup: Copy MYSQL Directory or use MysqlDump

Hi, MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM tables and copying them or shutting down the server and taring the entire MySQL directory if you are using innodb. If you are using innodb tables only you can run mysqldump with --single-transaction option to take a

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

the monitor the threads-connected variable over a period of time and calcuate the value. you can even look at max used connections status variable and allot accordingly. BTW, is you application using demand based connections or connection pooling ? If it is using connection pooling then bumping

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

Here is the CREATE TABLE Statement for the table on which the index_merge is being applied. There will be atleast 10 queries always running on this table with an index_merge optimization. We have the max_connections variable set to 100. Also repeatedly checking the Threads_Connected status

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

Hi, Here, threads_connected is considerable and below the preset value. The threads_connected and threads_running are the good indicators to see how loaded the server is. In your case it is good numbers. So use 'iostat'/relavant utility to monitor the DB activity. Also threads_created is