jeger003

does anyone know another way without using outside softwares or browser plugins? can this be done within the page it self with php, javascript, or any other language?

i have seen plugins but I dont want to do that. i want to be able to load the page with fields already filled then I just have to fill the other ones. Could i load the javascript form in a iframe and send the data from the page to the iframe?

Hello, I submit info to a javascript on another website. I want to be able to autofill the fields so i dont have to type everything. Is it possible to send form fields through the url? if not is it possible to take the form and create a page on my own server and submit to them from my site? Just trying to see what my options are. I dont want to use any softwares or anything.

All my urls have something like this after except for the homepage. #.UTyO5hzviSo Im trying to figure out why its doing this. I turned off many of the plugins but it still appears. anyone seen this before?

I am using InnoDB tables and i have been getting multiple table locks. The tables get 6-7 update and insert queries per second as well as 4-5 select COUNT(*) of all rows per second for live data. could this activity cause tables to lock?

Table Locks makes no sense to me. I read through the mysql doc but its been no help. I have multiple tables locking and other queries time out because of it. From my understanding: MySQL locks a table on any transaction whether its doing SELECT,UPDATE,INSERT etc. MySQL will not release the lock until either the connection has disconnected or it has completed the transaction. if thats the case then when is a row locked? How can I prevent table locks? my server does 90% UPDATE INSERT 10% SELECT, JOINS etc please dumb it down for me.

db ftd_store is being replicated and rdb is not. It seems to be sending the query to the SLAVE and that db does not exist on the SLAVE.

Thanks! what about this issue? I get this error when I run a query: Error 'Table 'rdb.rest' doesn't exist' on query. Default database: 'ftd_store'. Query:... when I run this: INSERT INTO ftd_store.sdnt(dom,art,ttl,ttl_count,last_updated) SELECT * FROM ( SELECT dom,art,ttl,COUNT(OKey) AS ttlCount, NOW() FROM rdb.rest WHERE dom = dom_val GROUP BY art,ttl ORDER BY dom,ttlCount DESC LIMIT 200 ) aliasResults ON DUPLICATE KEY UPDATE ttl_count = ttlCount, last_updated = NOW();

still messing around with this and it doesnt seem to be my queries.

well does it slow anything down to have a constant connection open? thats my main reason of closing it off. Also I have an event that runs once a day to update the MASTER. So in the entire day the MASTER has activity only once!

any ideas?

I'm referring to Replication.

hello, I don't like the fact that there is a connection open 24/7 from slave to master. I want to specify a time of the day to open a connection and test whether there are any updates. Is this possible?

here it is again. <script> $(document).ready(function() { $("#domains").children('option:gt(0)').hide(); $("#bts").change(function() { $("#domains").children('option').hide(); $("#domains").children("." + $(this).val() + "").show() }) }) </script> <form action="#" method="get"> <select name="bts" id="bts"> <option></option> <?php //mysql_close(); $query = mysql_query("SELECT DISTINCT bt_name, sd,id FROM db.s WHERE bt_name != 'optimus' ORDER BY id"); while($botname = mysql_fetch_array($query)) { echo '<option value="'.$botname['id'].'">'.$botname['bt_name'].'</option>'; } ?> </select> <select name="domains" id="domains"> <option></option> <?php //mysql_close(); $query = mysql_query("SELECT DISTINCT bt_name, sd,id FROM db.s WHERE bt_name != 'optimus' ORDER BY id"); while($botname = mysql_fetch_array($query)) { echo '<option value="'.$botname['sd'].'" class="'.$botname['id'].'">'.$botname['sd'].'</option>'; } ?> </select> <input type="submit" name="go"/> </form>

I have this: http://jsfiddle.net/Mxkfr/2/ after adding my mysql query to the drop down it stops working after the 20th record in the first drop down. meaning it wont show up the record of the second drop down It's exactly the 20th. the drop down has 150 records. http://pastebin.com/G8UJei6A I put my code on jsfiddle and pastebin because I don't like it coming up on google.

yea they must only be for linux systems.

yes but none with instructions on how to run from a windows machine....they are all command lines for linux

How do I run these to get reports of my server? http://hackmysql.com/mysqlreport https://launchpad.net/mysql-tuning-primer http://jeremy.zawodny.com/mysql/mytop/ I am running on WAMP and also on Windows Server but many of the instructions are for linux users. How can I use these scripts?

workbench wont let me use \G EXPLAIN '1', 'SIMPLE', 'results', 'index', NULL, 'label_index', '258', NULL, '8635858', '100.00', 'Using index; Using temporary; Using filesort' WARNINGS 'Note', '1003', 'select `db`.`results`.`label` AS `label`,count(`db`.`results`.`ObjectKey`) AS `labelcount` from `db`.`results` group by `db`.`results`.`label` order by count(`db`.`results`.`ObjectKey`) desc limit 30'

any ideas on where my issue is?

here is the results table http://pastebin.com/PX6qDHCd

hello, I need help tuning my mysql server for better performance. I have a lot of resources but it still is performing poorly. I only have 3.5 million records in one table that i hit the most. I need help focusing on which settings to change for better performance. a simple query like SELECT label, COUNT(ObjectKey) AS labelcount FROM db.results GROUP BY label ORDER BY labelcount DESC LIMIT 30 EXPLAINED: '1', 'SIMPLE', 'results', 'index', NULL, 'label_index', '258', NULL, '9093098', 'Using index; Using temporary; Using filesort' takes 44 seconds. here are my settings. SHOW VARIABLES LIKE '%buffer%'; 'bulk_insert_buffer_size', '8388608' 'innodb_buffer_pool_instances', '1' 'innodb_buffer_pool_size', '16106127360' 'innodb_change_buffering', 'all' 'innodb_log_buffer_size', '10485760' 'join_buffer_size', '131072' 'key_buffer_size', '304087040' 'myisam_sort_buffer_size', '70254592' 'net_buffer_length', '16384' 'preload_buffer_size', '32768' 'read_buffer_size', '65536' 'read_rnd_buffer_size', '262144' 'sort_buffer_size', '262144' 'sql_buffer_result', 'OFF' SHOW VARIABLES LIKE 'innodb%' innodb_data_home_dir, innodb_doublewrite, ON innodb_fast_shutdown, 1 innodb_file_format, Antelope innodb_file_format_check, ON innodb_file_format_max, Antelope innodb_file_per_table, OFF innodb_flush_log_at_trx_commit, 0 innodb_flush_method, innodb_force_load_corrupted, OFF innodb_force_recovery, 0 innodb_io_capacity, 200 innodb_large_prefix, OFF innodb_lock_wait_timeout, 50 innodb_locks_unsafe_for_binlog, OFF innodb_log_buffer_size, 10485760 innodb_log_file_size, 536870912 innodb_log_files_in_group, 2 innodb_log_group_home_dir, .\ innodb_max_dirty_pages_pct, 75 innodb_max_purge_lag, 0 innodb_mirrored_log_groups, 1 innodb_old_blocks_pct, 37 innodb_old_blocks_time, 0 innodb_open_files, 300 innodb_purge_batch_size, 20 innodb_purge_threads, 0 innodb_random_read_ahead, OFF innodb_read_ahead_threshold, 56 innodb_read_io_threads, 4 innodb_replication_delay, 0 innodb_rollback_on_timeout, OFF innodb_rollback_segments, 128 innodb_spin_wait_delay, 6 innodb_stats_method, nulls_equal innodb_stats_on_metadata, ON innodb_stats_sample_pages, 8 innodb_strict_mode, OFF innodb_support_xa, ON innodb_sync_spin_loops, 30 innodb_table_locks, ON innodb_thread_concurrency, 10 innodb_thread_sleep_delay, 10000 innodb_use_native_aio, ON innodb_use_sys_malloc, ON innodb_version, 1.1.8 innodb_write_io_threads, 4

@socialcloud - i want to keep connections to dbs separate. if you look at my code it is from that php page but it does not work like the user commented. @PFMaBiSmAd - below seems to be working. Could you possibly explain how this works? I'm trying to understand mysql connections. Also what is the best way to handle errors? I want mysql to tell me all the errors rather than blank pages. $handle_db1 = mysql_pconnect("othersite.com","user","pass"); mysql_select_db("db1",$handle_db1); $handle_db2 = mysql_pconnect("mysite.com","user1","pass1"); mysql_select_db("db2",$handle_db2); $handle_db3 = mysql_pconnect("mysite.com","user1","pass1", TRUE); mysql_select_db("db3",$handle_db3);

hello, I am using three databases. two of them have the same login information. I want to be able to run different queries on the same page from all three databases. So far i am using this but it only uses the last connection no matter which $handle_db i use. $handle_db1 = mysql_pconnect("othersite.com","user","pass"); mysql_select_db("db1",$handle_db1); $handle_db2 = mysql_pconnect("mysite.com","user1","pass1"); mysql_select_db("db2",$handle_db2); $handle_db3 = mysql_pconnect("mysite.com","user1","pass1"); mysql_select_db("db3",$handle_db3); I tried functions, classes and nothing works.

can anyone help me