Re: How to extend innodb files?

ql.com/doc/refman/5.1/en/adding-and-removing.html Carlos I do not think there is anything wrong with having one huge file is there? We have one innodb file of 85GB on ext3. Is there? Jangita | +254 76 918383 | MSN & Y!: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com --

RE: Swap data in columns

ALTER TABLE tablename1 CHANGE column1 column2 VARCHAR(64), CHANGE column2 column1 VARCHAR(64) Assuming the columns are varchar(64) Jangita | +254 76 918383 | MSN & Y!: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -Original Message- From: nixofor

RE: document for mysql performance improvement

I find this quite good http://www.mysqlperformanceblog.com/ Send your my.cnf and maybe we could look at it and pick anything that would help. Jangita | +254 76 918383 | MSN & Y!: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -Original Message- From: vo

RE: Transfer database to MySQL.Huge effort?

on the fly conversion instead of direct export import 4. test the data? How are you planning to implement the stored procedure if you are not going to move them? otherwise if you are willing to pay, I bet there are companies that do this :) Jangita | +254 76 918383 | MSN & Y!: jang...@yahoo

Re: question about VIEWS in 5.1.x

On 03/09/2010 9:26 p, Hank wrote: On Fri, Sep 3, 2010 at 6:23 AM, Jangita wrote: On 02/09/2010 8:30 p, Hank wrote: Simple question about views: Hank, Have you tried "running away from the problem :-)" by doing... CREATE PROCEDURE `combo`(theid INT) BEGIN (SELECT * F

Re: question about VIEWS in 5.1.x

(SELECT * FROM table2 WHERE id = theid); END$$ then calling it using call combo(value); Wow - thanks. This works perfectly. I'm assuming I can use "call combo(value)" in PHP and it returns the result set as if it were a proper table? -Hank Yes it should work just like a

Re: mysqldump error 1064 for database Use command

the same command on Fedora-with same mysql version. I could not possibly change the database name. There are quite a few databases I have on the system. -- Regards, Manasi Save Does it work when you dump only the database `1`? -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype:

Re: MySQL upgrades?

elp here. Regards Machiel In the old machine mysqldump -p etc etc dbname > database.sql then copy the database.sql to the new machine and run mysql -p < database.sql It should work regardless of the version you are exporting/importing to. -- Jangita | +256 76 91 8383 | Y! &a

Re: cant establish connection at application side.

On 02/09/2010 6:01 p, karthik kumar wrote: Wow .. Cool that solved our problem... Thanks a lott .. No problem, it took me two weeks to figure out why it takes sooo long to log in; :-) enjoy! -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.

Re: question about VIEWS in 5.1.x

UNION (SELECT * FROM table2 WHERE id = theid); END$$ then calling it using call combo(value); ? -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Best method to keep totals

no is indexed and the server is optimized. In addition we sum before a debit to see if the balance is suffecient, before a transfer, blah blah blah ... So it's all good. -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL G

Re: Performance problems on MySQL

On 02/09/2010 6:05 p, Alexandre Vieira wrote: Hi Jangita, I'm 15779 innodb_buffer_pool_pages_free from a total of 22400. That's 246MB of 350MB free. | Innodb_buffer_pool_pages_data | 6020 | | Innodb_buffer_pool_pages_dirty| 1837 | | Innodb_buffer_pool_pag

Re: cant establish connection at application side.

alhost (since mysql wount resolve anymore) -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Performance problems on MySQL

Increase innodb_buffer_pool_size say to 1GB? -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Replication VS Cluster

the data at server 1 at any point in time; say server 1 suddenly fell into a pond :) . I wouldnt want to open server 2 and find the last insert/update/delete missing... -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL Gen

Re: Replication VS Cluster

On 02/09/2010 4:32 p, Johan De Meersman wrote: On Thu, Sep 2, 2010 at 1:10 PM, Jangita mailto:jang...@jangita.com>> wrote: ... Growth should be linear to the growth of customers, no ? :-) I thought so too; but one customer = 1 customer record, plus all his transactions, and also w

Replication VS Cluster

replication and setting up a cluster (or something else)? which will also give me a painless (and later maybe automatic) changeover? Both servers are connected to the same switch. -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- M

Re: How to dump MySQL data on remote server using mysqldump

On 02/09/2010 7:19 a, James Corteciano wrote: How could I put the dump data on web server and not the local disk on mysql server? Log into the web server and do it from there? or copy the file onto the web server? -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jan

Re: Execution Time

the storage engines, type of data indexes on the table and so on. I suggest you see which one makes more logic, as speed usually becomes a problem when data becomes very large. -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail

Re: Performance Tunning

, indexes, data types: basically each setup is different. This might be a good start http://www.mysqlperformanceblog.com/ -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Recover Records

log file how can I recover particular records. Is it a binary log? if so use mysqlbinlog to search for the insert statements and re-insert them. -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List

Re: Complicated SQL Query

abase and can re-construct or roll back (by reconstructing from beginning to the time I want) from the binary log. -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.

Re: calculating memory size

unting for other apps, we would certainly exceed that. So, my question is simply: is that forumula accurate for determinning potential mysql memory allocation? Thanks! Are you running a 64bit OS/MySQL? -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk

Re: Always corrupted after restart server

ptoms? We have a particular mysql server that has been up the last 8 months with no downtime... -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Re: Reduce dataset but still show anomalies

On 20/08/2010 5:24 p, Bryan Cantwell wrote: Yes, but I DON'T want eh spikes smoothed out On Fri, 2010-08-20 at 17:16 +0200, Jangita wrote: On 20/08/2010 5:12 p, Bryan Cantwell wrote: I am trying to produce charts for large amounts of data. I already limit the user to a smaller time fra

Re: Reduce dataset but still show anomalies

the average per hour, or per day; this will generally smoothen the points out a little; In my case if i show registrations per day i get dips every Saturday and Sunday so it looks all jagged, But per week doesn't show the Saturday/Sunday dips... -- Jangita | +256 76 91 8383 | Y! & MSN:

Re: Seems like an easy query, but isn't to me. Help?

i need this info to see if it can work. -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: 5.1.x review

On 20/08/2010 4:43 a, Elim PDT wrote: > There are so many versions of 5.1, Is there some review or recommendations > for a stable one? thanks I hear 5.1.50 has been released; should be stable. Just out of interest, what OS are you using to host your mysql database? -- Jangita | +256 76 9

max_connections and max_user_connections

hi all in the mysql.user table, what is the difference between max_connections and mac_user_connections? or to put it simply, if i want each user except root to only be able to have only one connection to the server at any one time, which field should i set to 1? -- PO Box 26453 00504 Nairobi

Re: Best MySQL configuation

Is it dedicated to mysql only? what operating system does it run? Sayed Hadi Rastgou Haghi wrote: Dear All, What is the best configuration for a server with 2 XEON dual core CPU and 4GB Ram and 200GB RAID 5 hard? -- PO Box 26453 00504 Nairobi, Kenya. TEL: +254722996532 [EMAIL PROTECTED] -- M

Re: debian installation

just looking to upgrade mysql, then do the apt-get -t unstable mysql-server. If you are familiar with Debian, I apologize for being so... Beginner. Nick -Original Message- From: Jangita @ FSA [mailto:[EMAIL PROTECTED] Sent: Thursday, September 21, 2006 8:16 AM To: mysql@lists.mysq

debian installation

hello all i installed debian linux netinst which installed well; and proceeded to install mysql with the command below apt-get install mysql-server that also went well, i proceeded to configure etc etc when i logged in from a client i noticed that the mysql server version is 4! is there a w

Mysql over HTTP

I get my hands dirty; is there anything like this that exists out there? I have a week leave from Monday and if there isn't well im about to start writing one. Jangita -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]