I am wondering are there any public mysql network ? I mean free to use and a big network which works on our computers. I have a website project which will work in my homecomputer and mysql works little bit slower in this situation. because most of the tables has more then 1 million rows. even simple queries can work really slow on this kind of situation because this is a desktop. but if there is any kind of network I like to register and open my database as slave to there and use their slave from my mysql. if there is not anykind network who like to join me to build one something like this. from http://dev.mysql.com/doc/refman/5.0/en/replication-faq.html#qandaitem-16-3-4-2 I understand that slaves can be closed anytime and boot up any time mysql will replicate when it comes online. this is something like p2p network but will be in our service for database. PM me if you like the idea.
I am watching this thread there has been 25 views. but noone said anything. ok tell me your ideas. I am wondering is there a problem about my english ? was that a bad idea or good one or non profitable ...
IMHO, if even simple queries are slow, you should look to increasing RAM, CPU speed, RAID etc. Adding a slave server is likely to help in handling more simultaneous users, but may not be useful to speed up a single query. You could do some benchmarking by adding another local Desktop and see if you get any benefits.
May be all that visited doesn't know anything about the question you asked cos if they do then they should be able to answer.
I was thinking a dsl network based database. mysql mssql does support this kind of things. because mysql is free and fast I tought we can use it as start and build our own database hosting in internet. with this way we would have the biggest mysql network and probably the fastest one. for more details about mysql check this out http://dev.mysql.com/doc/refman/5.0/en/replication.html think this something like p2p network but little bit complicated to install and at the end we can use it in our web sites. "select * from table1 order by rand() limit 1" was a slow query. how did I improve it. ok divide its steps by hand first I take max(id) with "select max(id) from table1" this works fast. and took a random number with php and again ask the database "select * from table1 where id=RANDOMIDITOOK" with this way I have a fast random selection. but still its not a solved problem because a big big table stays there and I am gonna need more complicated queries. and I dont have chance to make a upgrade little bit broke these days btw Public Mysql Network is still looks good idea. I think we may need a one strong master server which we will use it master and slave at the same time. we will make our database to slave to that server and give our database as master to that. in this way we can build a network I guess.
Hi mascix, Check out http://jan.kneschke.de/projects/mysql/order-by-rand/ for a walk through and code for writing this as a MySQL stored procedure. If this is all you use the large table for then keep it outside of MySQL. Zip it up and use a PERL script to extract the data. Certainly save a lot of space and is even faster.